Skip to main content

Posts

SQL Error System.Data.SqlClient.SqlError: The operating system returned the error '32(The process cannot access the file because it is being used by another process.)' while attempting 'RestoreContainer::ValidateTargetForCreation'

Hi all, While Restoring a SQL Backup from SQL Server Management Studio sometime we get an error as shown below - System.Data.SqlClient.SqlError: The operating system returned the error '32(The process cannot access the file because it is being used by another process.)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'C:\Program Files\SQL\Databases\\TestDB_2012_10.mdf'. (Microsoft.SqlServer.Smo) Cause of Error we typed the name incorrectly during the file name creation in Restore Operation. Resolution  - Check out the file name in Option tab of Restore Database window. You would have put two \\ instead of one while specifying the path where file should get created. Below is the image of what i did - Thanks & Regards, Saurav Dhyani http://saurav-nav.blogspot.com/

Error: 5133 SQL Server while attaching the Database

Hi all, One of my friend reported an error while trying to attached a database received from client to SQL SERVER 2008 R2. The database received have only two files one is .mdf & second one is .ndf. while attaching database to the server he was getting below error - TITLE: Microsoft SQL Server Management Studio ------------------------------ Attach database failed for Server 'XXX-XX--XX'.  (Microsoft.SqlServer.Smo) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.2500.0+((KJ_PCU_Main).110617-0038+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476 ------------------------------ ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ Directory lookup for the file "G:\SQLLOG\NAV_D_CQPA_370B_Log.ldf" fa...

Microsoft Dynamics NAV Client has stopped working..

Hi all, some time we face issues when RTC Client Crashes. There can be multiple issues for the same. below is the screen shot for same. The Event Viewer Details for the Error is -.NET Runtime 2.0 Error Reporting. EventType clr20r3, P1 microsoft.dynamics.nav.client, P2 6.0.0.0, P3 4d030e65, P4 microsoft.dynamics.nav.client.ui, P5 6.0.0.0, P6 4d030e5c, P7 74e, P8 69, P9 k0r55xemoobpb22dbjzdn4p0sfjo3u25, P10 NIL. Below is the error message for same. Generally these issues comes due to issues in Role Center Pages in Navision 2009 and later. You can filter objects by using filter @*Role* in Pages. Below is the List of Pages in NAV 2009 SP1 IN Database. Case 1 - When the values in cues is negative. Then due to having a negative value in integer field crashes the client. These tables can be found by filtering tables in NAV 2009 & later by @*cue*. Below is the List of Tables in NAV 2009 SP1 IN Database. Most of the fields in these tables are flowfield, if by a...

How to Disable ESC Key in Navision Classic

Hi all, Sometime User want to force the user to click on the Cancel button instead of pushing the Esc key. This can be done From in Navision from Tools Menu in Navision Menu and select Options. There is an option Close Forms On Esc which is by default set to YES, set it to No. Refer to screen below. This option will set the ESC Disabled for all objects. If we want to customize this for a specific form follow steps below - 1. In the form declare a Boolean variable i.e. OverwriteEsc. 2. Set the Cancel property of the Cancelbutton to No 3. In the OnPush trigger of the Cancel button and Ok button: OverwriteEsc := TRUE; 4. In the OnQueryClose Trigger of the form: EXIT(OverwriteEsc); Thanks & Regards, Saurav Dhyani http://saurav-nav.blogspot.com/

Restore a Database In SQL Server Managment Studio.

Hi all, Most of us are aware with Navision Backup but at the same time unaware of SQL Server Backup. So lets discuss how to restore a SQL Database backup. Let see the steps how to restore a SQL Server Database Backup.

Error 3154 - The backup set holds a backup of a database other than the existing database.

Hi all, While Restoring Database on SQL Server Management Studio, some of us encounter an error i.e Error 3154- "The backup set holds a backup of a database other than the existing database". Resolution for the error After selecting the database backup, goto option Tab from the Left Hand Side Menu and click on First Restore Option i.e Overwrite the existing database(WITH REPLACE) as shown in screen below. * Make sure that there is no database file exist at the path mentioned in RESTORE the database file as section  with same file name otherwise it will replace those files. For Reading How to Restore a database from scratch in SQL Server Managment Studio, read article here . Thanks & Regards, Saurav Dhyani http://saurav-nav.blogspot.in/