How to Take Database Offline and Bring it Online - SQL Server DBA Tutorial

In this video you will learn how to take database offline and bring database online using SQL Server Management Studio as well as using T-SQL script. It also demonstrates real time scenarios when it is best to attach and detach sql server databases.

Script used in this video

ALTER DATABASE [SalesOrders]
SET offline WITH ROLLBACK IMMEDIATE 
GO
ALTER DATABASE [SalesOrders] SET online;



 

How to Take Database Offline and Bring it Online

5 comments:

  1. UnknownMay 21, 2019 at 7:38 AM

    Good job

    ReplyDelete
  2. Michael SmithSeptember 28, 2020 at 12:39 AM

    Unfortunately I need to concede every one of my endeavors to begin an online business were futile and I never made any genuine progress. Website Scraper and Email Extractor

    ReplyDelete
  3. SHAHZAIBOctober 14, 2020 at 4:52 AM

    This is a brilliant blog! I'm very happy with the comments!.. CCNP 350 401 dumps

    ReplyDelete
  4. SHAHZAIBNovember 19, 2020 at 4:30 AM

    Thanks for posting this info. I just want to let you know that I just check out your site and I find it very interesting and informative. I can't wait to read lots of your posts. سایبربان

    ReplyDelete
  5. D. James AndersonNovember 20, 2020 at 11:25 PM

    Additionally, it appears to be very outlandish to pay a few people for utilizing similar devices you can utilize yourself. Lead generation

    ReplyDelete

Subscribe to: Post Comments (Atom)