How to take SQL Server Database Offline and Online?

-- OFFLINE
 ALTER DATABASE [TEST_DB] SET OFFLINE WITH
 ROLLBACK IMMEDIATE
 GO
-- ONLINE 
 ALTER DATABASE [TEST_DB] SET ONLINE
 GO

0 comments:

Post a Comment