steps:
1. backup database testmirror on pricipal server
2. backup database log of
testmirror on pricipal server
3. copy db and log backup files to mirror server
4. restore db with norecovery
5. restore log with norecovery
6. create endpoints on both
pricipal serverand mirror server
issue:
if you use sql command or mirror wizard to set mirror machine.
it will show error: "the remote copy of database "dbmirrortest" has not been rolled forward to a point in time that is encompassed in the local copy of the database log."
or
1. alterdatabasetestbackup01setpartner=‘tcp://isrv04.xxx:50221‘;
2. tasks -> mirror ->mirroring -> config security
solutions:
these did the trick for me. i generated the commands through the "script"-menu within the "restore database"-dialog of the management studio, because enabling mirroring was no problem when i restored through the "restore database"-dialog. my manually written
sql-commands were missing the "nounload" part.