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 |
|
sqlpal2007
Posting Yak Master
200 Posts |
 Posted - 2011-08-19 : 11:52:31
|
| I have to restore the latest backup (from the 4 days backup files) to dev server. How do I get the latest backup file from the file directory to be able to restore?I was thinking a code in the SQL job and automate it to restore. But i don't know how to get the latest backup file?This has to be a weekliy automated job and there are 5 different databases which need to be restored.Can I write any dos cmd in T-SQL. I never tried this before.Please help!Thanks |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
|
|
|
|
|
Get max date from file directoryQuestion