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 |
|
cat_jesus
Aged Yak Warrior
547 Posts |
 Posted - 2008-05-19 : 17:03:48
|
| I just inherited a database that has never been backed up with a request to restore it to another server as of a certain date. Shouldn't I be able to do a db backup and a log backup and then do a point in time restore?This would be easy if there were regular backups but since there are none at this time I'd like some input from you guys.This DB was set up in full recovery mode. The log file is about 10 times the size of the DB.An infinite universe is the ultimate cartesian product. |
|
|
cat_jesus
Aged Yak Warrior
547 Posts |
Posted - 2008-05-19 : 17:07:21
|
| Crap I just realized I can't. It's all or nothing with the logs if you haven't been backing them up. That's why more frequent log backups give you a smaller data loss.An infinite universe is the ultimate cartesian product. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-05-19 : 17:09:22
|
quote:
Shouldn't I be able to do a db backup and a log backup and then do a point in time restore?
No, that's not how point in time recovery works. For point in time recovery, you need some full backup and the entire transaction log chain leading up to the time. The key here is "leading up to". You can have a differential in there as well.You can perform the final tlog backup after the time though, but you need a starting point of a full backup and then the chain leading up to the final tlog.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
|
|
|
|
|
|
Point in Time recovery / No backup