February 22, 2009 at 11:52 pm
Hi ,
I have Query abt Restore.
First i have taken Backup a Database In Primary Server, Then i Tried to Restore it In Secondary server,
Then i got following error message ..
Restore failed for Server 'RAMESHS\SECONDARYSERVER'. (Microsoft.SqlServer.Smo)
------------------------------
ADDITIONAL INFORMATION:
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 'D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\desai.mdf'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&LinkId=20476
Pls reply me soon,
February 23, 2009 at 7:43 am
I assume you have connected to the secondary server and are restoring using a UNC path like below?
restore database test from disk = '\\primary server\backups\test.bak'
If you are doing the above can you access the UNC path from the second server without supplying credentials? If not you will need to grant access to the account that the SQL Server Agent service is running as to be able to restore.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply