Anvie
Ten Centuries
Points: 1216
More actions
February 6, 2009 at 10:46 am
#205181
If the principal server failed and totally not accessible I would like the mirror to be accesible and not in restoring mode.
How can I do that??? any comment is appreciated.
thanks!:)
DBA in Unit 7
SSCarpal Tunnel
Points: 4059
February 6, 2009 at 12:30 pm
#939736
USE MASTER
GO
RESTORE DATABASE MYDB
WITH RECOVERY
February 6, 2009 at 1:48 pm
#939777
Thank you!
I found out I have to stop the mirroring 1st.
Use master
-- Stop mirroring
ALTER DATABASE [Database]
SET PARTNER off
-- Set to recovery
Restore Database DBMirror
with recovery
February 6, 2009 at 2:22 pm
#939793
I found out I have to stop the mirroring 1st. Use master-- Stop mirroringALTER DATABASE [Database]SET PARTNER off
Good to know that!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply