sql server - Restore mirrored database as non-mirrored -
we have sql server 2012 mirrored database want restore (essentially, copy) different server , run in non-mirrored mode. other server application testing , not require mirroring. proper restore steps? imagine @ point i'll need alter database set partner off when? safe total restore , set partner off? wouldn't want restored db begin participating in mirroring .
i found after restore, set partner off command said off. guess restore turns off mirroring. leaves different question of how restore mirrored db mirrored db doesn't concern me right now.
sql-server sql-server-2012 database-mirroring
No comments:
Post a Comment