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 |
|
ashley.sql
Constraint Violating Yak Guru
299 Posts |
 Posted - 2007-05-30 : 15:55:57
|
| I have a .bak file(device) and I want to create a DTS package to restore this to a database using a DTS packing every night.What is the best way to do this. Do I right a script or there are other options. Then I would need export data from some tables from this restored database to Test database which I can do using DTS export/import.But any good way to restore the bakup automatically every nightAshley Rhodes |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-30 : 17:20:23
|
| Why? Just run restore as scheduled job. |
 |
|
|
|
|
|
DTS PACKAGE TO RESTORE DATABASE FROM BAK DEVICE