Web Programming Knowledge Sharing: SQL Server Restore Database Failed - Because the database is in use.

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

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)