Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
doran_lum
Starting Member
2 Posts |
 Posted - 2011-06-30 : 06:16:02
|
| Hi all, i'm following the steps below on the mirroring and I'm stuck on STEP 2 - Restore Database on Secondary Database (Mirror Server).I have 3 VMs as per the instruction and not sure why i get the error "Msg 3201, Level 16, State 2, line 1Cannot open backup device 'D:\backup.bak' Operating System error 3Msg 3013, Level 16, State 1, line 1RESTORE DATABASE is terminating abnormally."Should I do the Step 2 within the same Principle VM ? ORShould I do the Step 2 on the Mirror VM ?http://sqlserver-training.com/how-to-setup-mirroring-in-sql-server-screen-shots/- |
|
|
ramaiah
Starting Member
27 Posts |
Posted - 2011-06-30 : 07:32:52
|
| step 2 should run on Mirror VM.. |
 |
|
|
doran_lum
Starting Member
2 Posts |
Posted - 2011-07-01 : 05:12:06
|
| If I put it on Mirror VM, it mention about restoring from the VM local drive. I don't quite understand how does it link to the Principal VM local drive. |
|
|
|
|
|
|
mirroring steps - unable to restore