Restore SQL Server UNC
-
My database has grown so much that I cant fit the database and the back(BAK file) on the same hard drive. I have tried to place the BAK file on our NAS Server and do a test restore from there. This did not work. Here is the proceedue I am using. ------------------------ Restore FileListOnly From Disk = '\\server_nas\TSW_Resort\TSWDataBackUp' Restore Database TSWData From Disk = '\\server_nas\TSW_Resort\TWDataBackUp' With Move 'W_Data' To 'D:\Data\TSData_Data.mdf', Move 'W_Log' To 'D:\Data\TSData_Log.ldf', Replace ----------------------- This didt not work either. Everytime I try to restore from the UNC path I get a device off line error. I have also checked my SQL Server Agent to make sure the credentials will allow it access to that file path. The last thing I have tried was to give the UNC path the address of the Mapped drive \\server_nas\G$\TWDataBackUp however that did not work either. I am using SQL Server 2000 and Windows Server 2003. Does anyone have any idea on how to do a restore. Any help would be appreciated Thanks
-
My database has grown so much that I cant fit the database and the back(BAK file) on the same hard drive. I have tried to place the BAK file on our NAS Server and do a test restore from there. This did not work. Here is the proceedue I am using. ------------------------ Restore FileListOnly From Disk = '\\server_nas\TSW_Resort\TSWDataBackUp' Restore Database TSWData From Disk = '\\server_nas\TSW_Resort\TWDataBackUp' With Move 'W_Data' To 'D:\Data\TSData_Data.mdf', Move 'W_Log' To 'D:\Data\TSData_Log.ldf', Replace ----------------------- This didt not work either. Everytime I try to restore from the UNC path I get a device off line error. I have also checked my SQL Server Agent to make sure the credentials will allow it access to that file path. The last thing I have tried was to give the UNC path the address of the Mapped drive \\server_nas\G$\TWDataBackUp however that did not work either. I am using SQL Server 2000 and Windows Server 2003. Does anyone have any idea on how to do a restore. Any help would be appreciated Thanks
oskardiazdeleon wrote:
Does anyone have any idea on how to do a restore. Any help would be appreciated
You cannot backup and restore across a network. The backup device, including a hard disk, must be physically attached to the SQL Server.
Upcoming Scottish Developers events: * UK Security Evangelists On Tour (2nd November, Edinburgh) * Developer Day Scotland: are you interested in speaking or attending? My: Website | Blog