What are the challenges you face when working across database platforms? Take the survey
Options

Suggested method for taking Clone offline

I have a need to take a Clone offline during the night time hours. I noticed last time I did it the GUI in SSMS acted strange. So I ran a TSQL and it worked ok.

I just wanted to check if there is a method preferred.

Answers

  • Options
    Running T-SQL to take the clone database offline is fine, but Clone Agents run a monitoring service which tries to ensure that clones are online, which sounds like it might conflict with what you want to do. To check, you need to have the clone database offline in SQL Server but the machine hosting the clone online?
  • Options
    TheSQLGuruTheSQLGuru Posts: 78 Silver 2
    edited September 17, 2017 2:43PM
    I'm not sure what the OP is asking for, or did, either. Offline as in detach the database?
    Kevin G. Boles
    SQL Server MVP 2007-2012
    Indicium Resources, Inc.
Sign In or Register to comment.