MS SQL

Restore Database from a Remote Backup

Please support our MS SQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Mar 2007

Posts: 158

Reputation: vuyiswamb is an unknown quantity at this point

Solved Threads: 5

vuyiswamb

Offline

Junior Poster

Restore Database from a Remote Backup

Nov 9th, 2009

Good Day All

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

•

\\Vuyiswa\MyShare\

but i will get the Following Error

•

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

Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."

•

Join Date: Feb 2009

Posts: 3,473

Reputation: sknake has much to be proud of

Solved Threads: 630

sknake

Offline

.NET Enthusiast

Nov 10th, 2009

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.

Scott Knake
Custom Software Development
Apex Software, Inc.

•

Join Date: Mar 2007

Posts: 158

Reputation: vuyiswamb is an unknown quantity at this point

Solved Threads: 5

vuyiswamb

Offline

Junior Poster

Nov 10th, 2009

Its the same thing. UNC and the Mapped drive is the same thing. so that will not help. i thought there was another way.

•

Join Date: Jun 2009

Posts: 452

Reputation: Ramesh S will become famous soon enough

Solved Threads: 82

Ramesh S

Offline

Posting Pro in Training

Nov 12th, 2009

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/