Database is in use error while restore database from backup (SQL Server)

Sometimes you are trying to restore a sql server database and you'll get the error:
"Exclusive access could not be obtained because the database is in use."

The Solution is type the script below and run it (SQL Query) :

Before Restore Attempt

 use master  
 alter database DB_NAME set offline with rollback immediate;  

After Restore

 use master  
 alter database DB_NAME set online with rollback immediate;  

Anda sedang membaca artikel tentang Database is in use error while restore database from backup (SQL Server) dan anda bisa menemukan artikel Database is in use error while restore database from backup (SQL Server) ini dengan url http://wellysundawa.blogspot.com/2014/06/database-is-in-use-error-while-restore.html

Anda boleh menyebarluaskan atau mengcopy-paste jika artikel Database is in use error while restore database from backup (SQL Server) ini sangat bermanfaat bagi teman-teman anda, namun jangan lupa untuk meletakkan link Database is in use error while restore database from backup (SQL Server) sebagai sumbernya.

-- Welly Sundawa Well Blog --

Posted in: Tutorial