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 |
|
sam123456
Starting Member
3 Posts |
 Posted - 2006-11-30 : 10:21:10
|
| hiI have a database that is regularly backed up using the maintainance planwhich means the backup file's name is changed everytime it is backed up.i need to run the job to restore this backup file every day to a different databasei am not sure how to do it.would appreciate if anyone can help me.thanks in advance |
|
|
Westley
Posting Yak Master
229 Posts |
Posted - 2006-11-30 : 23:33:10
|
| If you are adding a timestamp to your backup file, then you can most likely work that out from the backupset table in msdb, if you are using a random file name generation, then you might need to paste the output from xp_cmdshell 'dir <path>' might need to have a DTS for that. Am in the process of writing an app for copying DB, hopefully can get that done soon...then no more manual copy DB for me ....yeah!! |
 |
|
|
|
|
|
to restore the dynamic backup