We are trying to restore a SQL Server 2005 (all the databases). We have failed with the restore for a couple of times and the vendor says that we have to ensure that all database users are logged off the database. A restore will fail if other users
try to use the database while the restore operation is in
How could this be acomplished. There is no way that we can control if any user or app access the server while we are restoring.
The problem is that when when we are restoring the databases if someone access any of them while the restore is taking place the process fails.
The question is how should the restore be performed? Is there any way to change the state of the database so that the databases can be restored?
View Complete Post