Name: slanky 2009-08-03 21:48
I need to restore 1 database from another database on a schedule once a week. How can I do this with either a management plan in Microsoft SQL server 2005 management studio or with t-sql commands? The main concern is that both databases use more than one data file and are named differently. How do I make sure the restore goes to data files with the correct database name?