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. 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
  2. This is a brilliant blog! I'm very happy with the comments!.. CCNP 350 401 dumps

    ReplyDelete
  3. 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
  4. Additionally, it appears to be very outlandish to pay a few people for utilizing similar devices you can utilize yourself. Lead generation

    ReplyDelete