Web Programming Knowledge Sharing
Friday, March 11, 2011
SQL Server Restore Database Failed - Because the database is in use.
Force to close all existing connection
use master
go
alter database
DatabaseName
set single_user with rollback immediate
alter database
DatabaseName
set multi_user
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)