Below simple T-SQL codes can be used to take a SQL Database online or offline. This also can be done by SQL Server Management Studio.
– Take the Database Offline
ALTER DATABASE [DatabaseName] SET OFFLINE WITH ROLLBACK IMMEDIATE
— Take the Database Online
ALTER DATABASE [DatabaseName] SET ONLINE
Charith Silva is a Microsoft certified SQL Server developer and database administrator who was graduated at Buckinghamshire New university in the UK. His career was started in 1998, primarily into Web application development, and later diversified into database development.
He has got a vast experience in SQL Server database development, Database administration and Business Intelligence development. He believes that sharing the knowledge is key to the success.
Number of Posts : 87