DBA- Generate Script To Bring All User Databases Online in SQL Server

The below query can be used to generate scripts to bring SQL Server Databases from Offline state to Online.

SELECT 'ALTER DATABASE ['+name+'] SET ONLINE'+CHAR(10)+' GO' 
FROM MASTER.sys.databases
WHERE name NOT IN ('master','tempdb','model','msdb','distribution')
AND state_desc='OFFLINE'

3 comments:

  1. Mary SabatiniJune 21, 2020 at 4:06 AM

    cdx

    ReplyDelete
  2. I am blogger 14June 23, 2020 at 1:38 AM

    Great Article it its really informative and innovative keep us posted with new updates. its was really valuable. thanks a lot. Free Generator

    ReplyDelete
  3. Stephanie SchoolcraftJune 24, 2020 at 2:48 AM

    This is wonderful and quite informative website design agencies blog I have learnt so many things from here.

    ReplyDelete

Subscribe to: Post Comments (Atom)