Backing up from a remote server on to your c drive

Question

Backing up from a remote server on to your c drive

marjan76

Mr or Mrs. 500

Points: 503
More actions
March 21, 2010 at 7:10 pm

#386552

Hi,
What would be the best way to create a back up of a database on a remote server (a web hosting company) on to my local drive?
I tried the full backup option and I was only given the option of backing up on the remote server.
I'm using SQL Server Management Studio 2008.
Thank you in advance

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Stefan_G SSCertifiable Points: 6609 More actions · Answer 1

Backups can only be created on the filesystem on the sql server.

Maybe you could create a backup on the remote server and then use ftp to transfer the finished backup to your local system.

dmoldovan SSCertifiable Points: 6334 More actions · Answer 2

Talk to your host about it. Depending on your agreement, he may offer a backup / restore plan.

Michael Meierruth SSChampion Points: 10051 More actions · Answer 3

Stefan_G (3/22/2010)
Backups can only be created on the filesystem on the sql server.
Maybe you could create a backup on the remote server and then use ftp to transfer the finished backup to your local system.

With the correct permissions you can always do:

backup database MYDATABASE

to disk='\\myserver\servershare\MYDATABASE.BAK'

with stats=1

marjan76 Mr or Mrs. 500 Points: 503 More actions · Answer 4

Thank you so much for the responses.

@OldHand - so I would create a backup on the remote server then use that script to back it up on a disk?

Great, thank you so much guys.

Michael Meierruth SSChampion Points: 10051 More actions · Answer 5

I'm not sure if you have understood me. So here is a more detailed description of what I'm trying to say. Thus assume:

1. your DB server is called MYDBSERVER

2. your database is called MYDATABASE

2. the computer you are currently using is called YOURCOMPUTER

3. the user credentials under which SQL Server runs on MYDBSERVER has full access (via a share) to some directory on YOURCOMPUTER called YOURSHARE

3. you invoke isql.exe or isqlw.exe or sqlcmd.exe on YOURCOMPUTER (logging in with sufficient credentials) and issue the command

backup database MYDATABASE

to disk='\\YOURCOMPUTER\YOURSHARE\MYDATABASE.bak'

This performs a backup of a database on one computer directly to a disk on another computer.

Is this what you want?

marjan76 Mr or Mrs. 500 Points: 503 More actions · Answer 6

Old Hand, thank you for the clarification.

I really appreciate it.

I wanted the database backed up on my local computer, but I could always transfer it over to my c drive with the disk.

larence.venkat Newbie Points: 6 More actions · Answer 7

marjan76 (3/22/2010)
Thank you so much for the responses.
@OldHand - so I would create a backup on the remote server then use that script to back it up on a disk?
Great, thank you so much guys.

Hi this is venkat,

=========================================

When i go for this one :

backup database MYDATABASE

to disk='\\myserver\servershare\MYDATABASE.BAK'

with stats=1

=========================================

I got error is Operarting error 5 i cant understood why this comes

And one more thing what pre-requisite i fallow while i go for database backup on Network drive using ms sql server 2008

Please help me for complete the script

thanks in advance

larence.venkat Newbie Points: 6 More actions · Answer 8

marjan76 (3/22/2010)
Thank you so much for the responses.
@OldHand - so I would create a backup on the remote server then use that script to back it up on a disk?
Great, thank you so much guys.

Hi this is venkat,

=========================================

When i go for this one :

backup database MYDATABASE

to disk='\\myserver\servershare\MYDATABASE.BAK'

with stats=1

=========================================

I got error is Operarting error 5 i cant understood why this comes

And one more thing what pre-requisite i fallow while i go for database backup on Network drive using ms sql server 2008

Please help me for complete the script

thanks in advance

Oliiii SSCertifiable Points: 5328 More actions · Answer 9

The error 5 is an access denied, that means the service account running sql server doesn't have the right to write on the share or you forgot to specify a file name.