March 21, 2010 at 7:10 pm
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
March 22, 2010 at 5:06 am
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.
March 22, 2010 at 5:45 am
Talk to your host about it. Depending on your agreement, he may offer a backup / restore plan.
March 22, 2010 at 6:44 am
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
March 22, 2010 at 11:16 am
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.
March 22, 2010 at 11:37 am
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?
March 22, 2010 at 11:46 am
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.
October 11, 2010 at 11:42 pm
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
October 11, 2010 at 11:43 pm
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
October 12, 2010 at 1:36 am
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.
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply