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-31 : 09:05:13
|
| i have to restore database from production bakup to development everyday, there is a program which does this bakup and names the file like PROD_20070523.BAK based on the date.is there any way to run this with SQL agent and make sure everytime the current file is backed up. can i rename the file to a different name everyday automatically.Also this file is a zip file so can i unzip this automatically.Ashley Rhodes |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-31 : 10:15:35
|
| Winzip has dos command utility for that, you can write batch file to rename and unzip file. |
 |
|
|
|
|
|
restore db daily with a job but BAK file is diff