943,985 Members | Top Members by Rank

Web Development > Databases > MS SQL > Restore Database from a Remote Backup
Ad:
  • MS SQL Discussion Thread
  • Unsolved
  • Views: 1940
  • MS SQL RSS
Permalink
Nov 9th, 2009
0

Restore Database from a Remote Backup

Expand Post »
Good Day All

am restoring a Database Programatically in Sql. Now if the backup is located in the remote machine i use a Share

Quote ...
\\Vuyiswa\MyShare\


but i will get the Following Error

Quote ...
Exception caught in: ExecuteStoredProc: The file "\\Vuyiswa\Databases\\REmoteTest33.mdf" is on a network path that is not supported for database files. File 'TNGoedit_Data' cannot be restored to '\\Vuyiswa\Databases\\REmoteTest33.mdf'. Use WITH MOVE to identify a valid location for the file. The file "\\Vuyiswa\Databases\\REmoteTest33_log.ldf" is on a network path that is not supported for database files. File 'TNGoedit_Log' cannot be restored to '\\Vuyiswa\Databases\\REmoteTest33_log.ldf'. Use WITH MOVE to identify a valid location for the file. Problems were identified while planning for the RESTORE statement. Previous messages provide details. RESTORE DATABASE is terminating abnormally. Database 'REmoteTest33' does not exist. Make sure that the name is entered correctly.



Thanks
Similar Threads
Reputation Points: 31
Solved Threads: 14
Posting Whiz
vuyiswamb is offline Offline
310 posts
since Mar 2007
Permalink
Nov 10th, 2009
0
Re: Restore Database from a Remote Backup
I don't think you can do backup/restore on UNC paths. You should look in to mapping a drive for that share on the SQL Server.
Featured Poster
Reputation Points: 1749
Solved Threads: 735
Senior Poster
sknake is offline Offline
3,948 posts
since Feb 2009
Permalink
Nov 10th, 2009
0
Re: Restore Database from a Remote Backup
Its the same thing. UNC and the Mapped drive is the same thing. so that will not help. i thought there was another way.
Reputation Points: 31
Solved Threads: 14
Posting Whiz
vuyiswamb is offline Offline
310 posts
since Mar 2007
Permalink
Nov 12th, 2009
0
Re: Restore Database from a Remote Backup
Hi vuyiswamb,

Check the account under which the SQL Server instance is running.

SQL Server instance is generally running under Local System/Local Servce/Network Service accounts which may not have access rights to the UNC path.

Change that account to a domain user account which should have access to the UNC path, restart the service, and try now. Hope this will help you.

Refer these links also.
http://support.microsoft.com/?kbid=555128
http://social.msdn.microsoft.com/for...-f09b78d89ed1/
Reputation Points: 165
Solved Threads: 113
Posting Pro
Ramesh S is offline Offline
580 posts
since Jun 2009

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in MS SQL Forum Timeline: SSIS skip bad row
Next Thread in MS SQL Forum Timeline: Connection to remote server





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC