Error #100807
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.
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.
User's solution
This works!
-1
Vote Up
Microsoft KB article
You cannot restore a database from a backup file when you use a SQL Server login ID that has the dbcreator server role to connect to an instance of SQL Server 2005:
http://support.microsoft....;spid=2855
