need to restore sql with some specific location
Created: 11 Oct 2012 | 4 comments
hi
We are using BE2010R3 and backing up a win2008 r2 sql 2008 R2 server.
I want to test a backup of a DB1 with this setup
DB1 [mdf file is on D:\mdf folder]
DB1 [LDF file is on e:\ldf folder]
DB1 [Ndf file is on f:\ndf folder]
The backup is succesfull. Now can I restore this DB1 database as DB2 on same instance
DB2 mdf [file should go to d:\mdf1 folder]
DB2 ldf [file should go to e:\ldf1 folder]
DB2 ndf [file should go to f:\ndf1 folder]
Thanks
Prashant Mehta
Discussion Filed Under:
Comments 4 Comments • Jump to latest comment
If you are using the SQL agent to backup the database, then you can use the SQL file re-direction to restore it to another location.
If you just do a flat-file backup, then restoring the files to another location would be of no use because the master database is not updated.
hello PKh
I am backing up DB1 using Sql agent but in the background it is configured this way.
If you find my comment informative and helpful please mark the post as resolved.
Just restore them to one location, and move the after the restore is completed.
If this response answers your concern, please mark it as a "solution"
I think that is not supported. Backup of a database is done as a single set and it can be redirected to a single place in its entirety.
Would you like to reply?
Login or Register to post your comment.