Hi all,

I would like your help in following issue...
I'm trying to restore a database from a remote SQL Server. I have the .bak file in my PC and I want to restore it.
In Microsoft SQL Server Management Studio Express I can access to the database and I can back up it. However I cant restore it ti gives me the following error:

###########

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup
Cannot access the specified path or file on the server. Verify that you have the necessary security privileges and that the path or file exists.

If you know that the service account can access a specific file, type in the full path for the file in the File Name control in the Locate dialog box.

###########

I wouldappreciate your help.

Thank you,
Kindest regards,

Tito Duarte

To make two points clear:

• Everything you do is on the server you execute the scripts. If you backup a database and store it under C:\, its the servers C:\
• If you use a Restore statement and use c:\ it´s the servers C:\

When executing commands which access physical files on the server, you will access them under your context (if using Windows authentication) or under the Service Accounts context (if using SQL Server authentication)

-Jens K. Suessmeyer

I guess you should use the UNC path from the server to your PC:

restore database blablabla
from disk = '\\PCname\c$\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\dbbackupfile.bak'
with... (options)

---

Bodo Michael Danitz - MCITP Database Administrator - free consultant - performance guru - www.sql-server.de

To make two points clear:

• Everything you do is on the server you execute the scripts. If you backup a database and store it under C:\, its the servers C:\
• If you use a Restore statement and use c:\ it´s the servers C:\

When executing commands which access physical files on the server, you will access them under your context (if using Windows authentication) or under the Service Accounts context (if using SQL Server authentication)

-Jens K. Suessmeyer