May 26, 2003 at 11:10 am
Hi!
I need to restore a database from a different server to other database name. The database is too large to fit on the disk and to leave place for restore. I map a network
drive with the backup, but it says that the device is offline. I guess it cannot restore a database from network drive.
How can I do such a restore?
May 26, 2003 at 11:39 am
Sure you can.
restore database pubs from disk = '\\servername\sharename\pubs.bak'
Make sure SQL Server service account is a domain account and able to read the files from the share.
May 26, 2003 at 12:14 pm
Big thanks! It worked!
restore database ACCPAC2
from disk = '\\Saturn\sql_backup\ACCPAC_BACKUP.BAK'
WITH REPLACE,
MOVE 'accpac_data' TO 'd:\sql_data\ACCPAC2_Data.mdf',
MOVE 'accpac_log' TO 'd:\sql_log\ACCPAC2_Log.ldf'
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply