09-03-2012 06:09 AM
is it possible to restore a database out in a file, instead of direct to another Sql server?
Solved! Go to Solution.
09-03-2012 06:24 AM
you can perform redirected restore and use "Use this path" option in the restore job properties (under redirected restore for SQL options)
That option will help you restore the database to a specific location on disk. To use this option, enter a drive letter and its corresponding path. For example, C:\temp. You can also click the ellipsis button and browse to a disk location. All paths entered are maintained in the Use this path drop-down list, which can be used for future redirected database restore jobs.
However, you cannot restore the .mdf .ldf files (as flat files)
Alternatively you can perform a redirect restore of SQL databases with new name on same server\instance and get .mdf and .ldf)
09-03-2012 06:24 AM
you can perform redirected restore and use "Use this path" option in the restore job properties (under redirected restore for SQL options)
That option will help you restore the database to a specific location on disk. To use this option, enter a drive letter and its corresponding path. For example, C:\temp. You can also click the ellipsis button and browse to a disk location. All paths entered are maintained in the Use this path drop-down list, which can be used for future redirected database restore jobs.
However, you cannot restore the .mdf .ldf files (as flat files)
Alternatively you can perform a redirect restore of SQL databases with new name on same server\instance and get .mdf and .ldf)
09-03-2012 06:46 AM
Thanks this was helpfull :D