How is it possible to restore a database in Machine A (where sql server is installed) from the backup file located in Machine B.
Is it possible to avoid to copy the bak file to the machine A?
+1
A:
Create a file share on machine B. Then restore from the file there.
Although you don't create a copy of the file 'per se' you still have to get the content of the backup file across.
John
2010-08-06 14:41:21
+1
A:
You have to (read: want to) get that file on the server hosting SQL Server. Assuming that this is a large file, you don't want to restore from across the network which will be much slower. If you can't copy it because of the time involved, or the space on the SQL Server, I'd suggest an external USB drive or something.
Thyamine
2010-08-06 14:42:03