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')

13 comments:

  1. navidevanJanuary 2, 2020 at 10:49 PM

    I read this blog, Nice article...Thanks for sharing waiting for the next...
    core java training in chennai
    core java training institutes in chennai
    Best core java Training in Chennai
    core java training in anna nagar
    core java training in vadapalani
    C C++ Training in Chennai
    javascript training in chennai
    Hibernate Training in Chennai
    LoadRunner Training in Chennai
    Mobile Testing Training in Chennai

    ReplyDelete
    Replies
    1. this isDecember 20, 2020 at 5:12 PM

      IEEE Final Year Project centers make amazing deep learning final year projects ideas for final year students Final Year Projects for CSE to training and develop their deep learning experience and talents.

      IEEE Final Year projects Project Centers in India are consistently sought after. Final Year Students Projects take a shot at them to improve their aptitudes, while specialists like the enjoyment in interfering with innovation.

      corporate training in chennai corporate training in chennai

      corporate training companies in india corporate training companies in india

      corporate training companies in chennai corporate training companies in chennai

      I have read your blog its very attractive and impressive. I like it your blog. Digital Marketing Company in Chennai Project Centers in Chennai

      Delete
  2. Grateful DBAJanuary 14, 2020 at 12:12 PM

    Beautiful simplicity. Perfect!! Thank you.

    ReplyDelete
  3. 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
  4. Charlie FredaApril 5, 2021 at 5:00 AM

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

    ReplyDelete
  5. UnknownJune 22, 2021 at 5:51 AM

    This article will outline all the different strategies you should be aware of when it comes to soccer.

    best ias coaching in india

    ReplyDelete
  6. 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
  7. NearlearnJune 30, 2021 at 12:06 AM

    very very informative post for me thanks for sharing

    BlockchaincClassroom Training Course in Bangalore

    ReplyDelete
  8. Best IAS Coaching In IndiaAugust 10, 2021 at 8:59 AM

    This is most informative and also this post most user friendly and super navigation to all posts... Thank you so much for giving this information to me..

    Best MPSC Coaching in Mumbai

    Best IAS Coaching in Navi Mumbai

    Best IAS Coaching in dadar

    Best IAS Coaching in Thane

    Best IAS Coaching in Andheri

    Best IAS Coaching in Mumbai

    Best ias coaching in borivali

    Best IAS Coaching in bhandup

    ReplyDelete
  9. 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
  10. neha jainDecember 1, 2021 at 12:23 AM

    MPPSC Coaching in IndoreGet Free MPPSC Notes and MPPSC Study Material for preparation of MPPSC Exam.>

    ReplyDelete
  11. 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
  12. 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)