The first thing you need to do when setting up Database Mirroring is perform a full backup followed by a transaction log backup on the principal server. You then must restore these to the mirror server using the WITH NORECOVERY option of the RESTORE command.
I have been looking for these codes. Thanks for sharing. Check out this site https://customwriting.com for impressive custom writing services.
ReplyDeleteThanks great and very short article.
ReplyDeleteI was facing issue while doing failover.
[error msg:-The database mirroring service cannot be forced...]
I would suggest to keep safety ON to avoid such error.
Please refer below code.
/*Set partner, set asynchronous mode, and setup job on principal server*/
ALTER DATABASE DatabaseName SET PARTNER = N'TCP://MirrorServer:PortNumber'
ALTER DATABASE DatabaseName SET SAFETY ON --use ON instead of OFF.
EXEC sys.sp_dbmmonitoraddmonitoring -- default is 1 minute
I had a great time reading this kind of valuable post. Please keep sharing and enlightening your readers' minds. Visit my Lawrence Todd Maxwell pinterest page when you have some spare time.
ReplyDelete