database baskup

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?
Thanks

Microsoft SQL Server 2008

Last Comment

Jagdish Devaku

8/22/2022 - Mon

ASKER CERTIFIED SOLUTION

Raja Jegan R

10/7/2009

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

Jagdish Devaku

10/7/2009

Try the below script...

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...

http://www.sqlservercentral.com/Forums/Topic678215-357-1.aspx

Bye

BACKUP DATABASE [Databae_name] TO DISK = N'\\serverName\D$\folder_name\database_name.bak' WITH NOINIT , NOUNLOAD , NAME = N'Database_name backup', NOSKIP , STATS = 10, NOFORMAT
 
Note: for external location of backup, you just replace server_name with network_share_name

Open in new window

Raja Jegan R

10/7/2009

>> 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?

Not sure what you meant by this..
Can you kindly explain more on this

Jagdish Devaku

11/3/2009

Hi angelIII,

I think this question should be closed by splitting the points to any of the comments above if they are related and solves the issue posted. So administrator please check the comments and split or refund the points.

Thanks.

I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst

William Peck