June 13, 2011 at 1:25 am
HI All,
I want to take the cold backup of mirror server master database without distrubing the mirroring... how can i?
Can u please help me in this one .. its very urgent...
🙂
June 13, 2011 at 2:17 am
A regular sql backup doesn't break mirroring !
backup database [xyz] to ...
See books online :http://msdn.microsoft.com/en-us/library/ms191304.aspx
backup using SSMS : http://msdn.microsoft.com/en-us/library/ms187510.aspx
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
June 13, 2011 at 3:25 am
you cant take cold backup without interupting the mirror because when you go for cold backup then you have to shutdown all sql server services
you can take hot backup as ALZDBA mentioned regular backup do not interrupt your mirroring mechanism
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
June 13, 2011 at 4:38 am
I just reread your original question and need to revise my answer a bit.
You cannot mirror sqlserver master database !
ref: http://msdn.microsoft.com/en-us/library/ms189852.aspx
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
June 13, 2011 at 6:34 am
he want to take backup of Master database of Mirror server ,doesnt want to mirror the master database
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply