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



Quickly generate script to bring all SQL Server Databases offline.

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

7 comments:

  1. Grateful DBAJanuary 14, 2020 at 12:12 PM

    Beautiful simplicity. Perfect!! Thank you.

    ReplyDelete
  2. Michael HollifieldJuly 21, 2020 at 4:42 AM

    Nicest information!!! I'll be enchanted to greatly help due to what I've learnt from here.
    user experience design agency

    ReplyDelete
  3. Charlie FredaApril 5, 2021 at 5:00 AM

    He arrived on time, and expertly investigated and recognized the problem.
    web design SF

    ReplyDelete
  4. Aubrey DickeyJune 26, 2021 at 1:26 AM

    This web page has given me loads to keep in mind and what I wanted for years!! What an extraordinary solution to design studios!!
    company logo design

    ReplyDelete
  5. Petter JohnOctober 30, 2021 at 3:46 AM

    Every day I visit a number of blog sites to see content, however this offers quality based content.
    brand strategy firms

    ReplyDelete
  6. taranstechJune 9, 2022 at 12:31 AM

    Hi, I have just started to SQL Certification Online. and this blog is really informative for me. Keep us posted for this kind of valuable blog. Thank you for this blog!

    ReplyDelete
  7. harryOctober 10, 2022 at 2:41 AM

    I liked your blog because there is a lot of good information in it, if you look for java script in
    Training Services Company in Dinanagar then you will not get anything better than Satyam Technology.

    ReplyDelete

Subscribe to: Post Comments (Atom)