Our webserver is down, there is no ftp access, but I can access the database server, when I pefrorm a backup it works but it backsup the database on the server itself. Once I try to backup it to my local machine I get the following message;
TITLE: Locate Database Files - MICRO108\SQLEXPRESS
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.
In the dialog box there is no possibility to type anything. Is there any possibility to make a copy of the database on the local machine?
SQL Server does not recommend the backup of db on different server.
Make sure that the folder on your machine is shared and have necessary permissions...
for more info check the below link...
Open in new window