restoreing database for mirroring

Question

i have 123Gig of database,

i am trying to setup mirroring for it.

we take full backup every week and diff backup every night, and trans log every hour.

and last full database backup was taken  2 days ago and we have diff backups since last full backuop.

what should be the restore strategy for mirrored database.

Please advise

---

k

Answer 1

Need to restore as per below order.

1. Full Backup  with norecovery

2. Recent Differential Backup (not all the differential backup taken after full backup) with norecovery

3. All log backup taken after recent Differential backup with norecovery

---

Srinivasan

Answer 2

http://www.sqlserver-training.com/how-to-setup-mirroring-in-sql-server-screen-shots/-

---

Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

MS SQL optimization: MS SQL Development and Optimization
MS SQL Blog: Large scale of database and data cleansing
Remote DBA Services: Improves MS SQL Database Performance

Answer 3

1) Last Full backup with norecovery.

2) Last differential backup with norecovery.

3) Restore all trn log backups which taken after last differential backup in sequence with norecovery.

  

Answer 4

Perfect, Resolved

---

k