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.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 mirroring steps - unable to restore

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 1
Cannot open backup device 'D:\backup.bak' Operating System error 3
Msg 3013, Level 16, State 1, line 1
RESTORE DATABASE is terminating abnormally."

Should I do the Step 2 within the same Principle VM ? OR
Should 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..
Go to Top of Page

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.
Go to Top of Page
   

- Advertisement -