|
In Sql Server 2005, is there any way to restore a database from a backup file with out having to copy the backup file to the server's hard drive first? E.g., if I have the backup file on one computer, is there a way using t-sql to restore to a database on a different computer without first having to copy the backup file to physically reside on the target machine?
(comments are locked)
|
|
Absolutely. All of our backups are stored on a network share so the restore command would be like:
(comments are locked)
|
|
Sure can although I had an issue with a very large database file. Best of luck. http://msdn.microsoft.com/en-us/library/ms179313.aspx Specifying a Universal Naming Convention (UNC) Name To specify a network share in a backup or restore command, you should use the fully qualified universal naming convention (UNC) name of the file for the backup device. A UNC name has the form \\Systemname\ShareName\Path\FileName.
(comments are locked)
|
