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
 back up to mirror database

Author  Topic 

gorashy
Starting Member

15 Posts

Posted - 2014-12-26 : 11:01:11
hi
I am new to sql server, and I am trying to configure database mirroring.I experienced some errors and I read in the forums that before I start the mirroring I must back up full and log backup to MIRROR DATABASE.
How can I do that? in management studio, please help
thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-12-26 : 13:03:24
1. backup database on primary server
2. restore that backup on mirror server using norecovery option
3. backup log on primary server
4. restore that log backup on mirror server using norecovery option
5. setup mirroring: http://weblogs.sqlteam.com/tarad/archive/2007/02/13/60091.aspx

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

gorashy
Starting Member

15 Posts

Posted - 2014-12-27 : 17:44:29
thanks, but I did not understand line number 2 "restore that backup on mirror server using norecovery option"
How can I do that?
Go to Top of Page

gorashy
Starting Member

15 Posts

Posted - 2014-12-27 : 17:53:37
thanks, but I did not understand line number 2 "restore that backup on mirror server using norecovery option"
How can I do that?
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-12-29 : 13:23:15
You can use the restore GUI or use the RESTORE DATABASE/LOG command:

RESTORE DATABASE somedb
FROM disk = 'f:\backup\somedb.bak'
WITH NORECOVERY

RESTORE LOG somedb
FROM disk = 'f:\backup\somedb.trn'
WITH NORECOVERY

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

gorashy
Starting Member

15 Posts

Posted - 2014-12-30 : 16:58:13
thank you very much
Go to Top of Page
   

- Advertisement -