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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-11-09 : 14:06:57
|
clark writes "This scenario is on Windows NT4 Server SP5 with SQL 7 SP1. I have a database called live and one called test. The live database has a cold backup each night and hourly transaction log backups throughout the day.
How can I write a script to restore the live database to the test that includes all the transaction log backups?
Variants on this might be a point-in-time restore from live to test or if there are also differential backups (which I'm not doing right now).
Thanks in advance,
Clark" |
|
|
|
|
|
Scripted restoring of differential/transaction log backups to another database