Got an error wen trying to restore the DB in 2nd instance:
Restore failed for Server 'ZAFAR-PC\DEVDB'. (Microsoft.SqlServer.SmoExtended)
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\Microsoft SQL Server\MSSQL10.MSSQLSERVER2\MSSQL\DATA\AdventureWorks.mdf'.
NO AUDIO IN THIS....
sanjeev7030 1 week ago
Got an error wen trying to restore the DB in 2nd instance:
Restore failed for Server 'ZAFAR-PC\DEVDB'. (Microsoft.SqlServer.SmoExtended)
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\Microsoft SQL Server\MSSQL10.MSSQLSERVER2\MSSQL\DATA\AdventureWorks.mdf'.
Njoiraja 1 year ago
in the end the DEV server has the adventureworks database being restore. is that right? because I cannot access to this database.
gongxia649 2 years ago
Excellent Intro to LogShipping!
idugindia2009 2 years ago
great tutorial , thakns
cheena11 2 years ago