Suggested method for taking Clone offline

GarryBGarryB Posts: 29 Bronze 1
in SQL Clone
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.
Tagged:
· Share on Twitter

Answers

  • ChrisHurleyChrisHurley Posts: 54 Silver 2
    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?
    · Share on Twitter
  • 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.
    · Share on Twitter
Sign In or Register to comment.