Answered by:
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
Monday, July 15, 2013 12:52 AM
Answers
-
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
- Marked as answer by '''HuuM''' Monday, July 15, 2013 1:55 PM
Monday, July 15, 2013 4:28 AM
All replies
-
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
- Marked as answer by '''HuuM''' Monday, July 15, 2013 1:55 PM
Monday, July 15, 2013 4:28 AM -
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
Monday, July 15, 2013 5:13 AM -
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.
- Proposed as answer by Geoferry Toburen Friday, August 2, 2013 4:34 PM
Monday, July 15, 2013 11:49 AM -
Perfect, Resolved
k
Monday, July 15, 2013 1:55 PM