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 |
|
cgunner
Yak Posting Veteran
95 Posts |
 Posted - 2006-03-12 : 08:41:43
|
| Does anyone have a script that will reference a particular directory and apply all the transaction logs in that directory to a database. I have a couple of thousand transaction logs that I need to apply to a database. |
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
|
|
nr
SQLTeam MVY
12543 Posts |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-03-12 : 15:04:03
|
| Why do you have to apply that many transaction logs?Even if you do them every 5 minutes, 2000 would be a weeks worth of tranaction logs.CODO ERGO SUM |
 |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-03-12 : 15:18:35
|
quote:
Originally posted by Michael Valentine Jones
Why do you have to apply that many transaction logs?Even if you do them every 5 minutes, 2000 would be a weeks worth of tranaction logs.
playing all the logs will probably take a week.If you don't do frequent full backups, then periodic differentials are probably a good idea.-ec |
|
|
|
Kristen
Test
22859 Posts |
|
|
|
|
|
Numerous TLogs to restore