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 |
|
umstorom
Starting Member
6 Posts |
 Posted - 2010-05-22 : 06:06:32
|
| HiI've got a small (non-urgent) problem which my limited T-SQL cannot fix! I can just about get away with SELECT statements and simple joins!We've got 2 databases running on SQL Server 2005 SP3 one of which is the live data and one of which is the test system. The department using the databases currently call us when they would like a backup of the live database restored onto the test one for various reasons. They have asked if it is possible for us to automate the restore with the a copy of the latest backup each Saturday night (a backup taken each evening). I thought this may be possible with a maintenance plan but I can't see how.Any help much appreciated,Best Regards,Tim.http://www.developerbay.net |
|
|
|
|
|
Make an automated backup restore