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 |
|
PrestonZX
Starting Member
1 Post |
 Posted - 2008-09-03 : 13:55:35
|
| What order should the maintenace plan backup the data? I currently have it doing databases then logs. I found out today that to get the point in time I needed, I had to restore 3 files versus 2. For example, I needed a point in time recovery for date/time 200809021500 and had to restore these 3 files.Restore database_200809010100.bakRestore database_log_200809010100.trnRestore database_log_200809020100.trnwith STOPAT = N'09/02/2008 03:00:00 PM'I'm thinking about reversing the maintenance plan to backup the logs first then database. What do you all think? Thanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Maintenance Plan Backup Order