acapone (8/27/2014)
Thanks Jack. Is it possible to restore backups to an older version of the database?What I mean is the database backups will be taken from one server, and then restored on a different server that has the same database but about two weeks behind in data.
Do you see that being a problem at all?
Thanks.
If you are restoring over an existing database you need to specify WITH REPLACE. Typically when restoring a database on a different server the RESTORE command will look something like this:
RESTORE DATABASE [DatabaseName] FROM DISK = 'Backup Path' WITH
MOVE 'datafile1' TO 'data file path\physical_file_name.mdf',
MOVE 'logfile' TO 'log file path\physical_file_name.ldf',
REPLACE /* only needed if the database already exists */
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question