Search This Blog

October 21, 2014

How to bring database in SQL Server from Restore mode to normal

Change the database_name to the database name having issues.
USE master
GO

 ALTER DATABASE database_name SET OFFLINE WITH ROLLBACK IMMEDIATE
GO

 ALTER DATABASE database_name ONLINE
GO