By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,948 Members | 1,929 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,948 IT Pros & Developers. It's quick & easy.

Backup to remote pc

P: n/a
Hi there,
I use shared space MSSQL server in my hosting server.
And I can't backup my DB to my remote server.
Please help how can I do it.
Thank you
Jul 20 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a

<an***@bk.ru> wrote in message
news:e2**************************@posting.google.c om...
Hi there,
I use shared space MSSQL server in my hosting server.
And I can't backup my DB to my remote server.
Please help how can I do it.
Thank you


You can ask your hosting company to make a backup and put in on an FTP
server, or somewhere else for you to download it. If that's not possible,
and assuming you have access to your database with Enterprise Manager and
Query Analyzer, you can generate the scripts for all the objects in the
database, and run the scripts on your own server. That will recreate all the
objects, and you can use bcp.exe or DTS to pull the data from the hosted
server to your own server.

Simon
Jul 20 '05 #2

P: n/a
"Simon Hayes" <sq*@hayes.ch> wrote in message news:<41668095
You can ask your hosting company to make a backup and put in on an FTP
server, or somewhere else for you to download it. If that's not possible,
and assuming you have access to your database with Enterprise Manager and
Query Analyzer, you can generate the scripts for all the objects in the
database, and run the scripts on your own server. That will recreate all the
objects, and you can use bcp.exe or DTS to pull the data from the hosted
server to your own server.

Simon


Thank you.
But i need to backup my database twice in day, in later maybe more.
MSSQL Server is in local area with my server. Can i share folder or
disk to copy backup by script to? Or MS SQL Server can't make backup
files on share-dick?
Thank you very much.
Jul 20 '05 #3

P: n/a

<an***@bk.ru> wrote in message
news:e2**************************@posting.google.c om...
"Simon Hayes" <sq*@hayes.ch> wrote in message news:<41668095
You can ask your hosting company to make a backup and put in on an FTP
server, or somewhere else for you to download it. If that's not possible,
and assuming you have access to your database with Enterprise Manager and
Query Analyzer, you can generate the scripts for all the objects in the
database, and run the scripts on your own server. That will recreate all
the
objects, and you can use bcp.exe or DTS to pull the data from the hosted
server to your own server.

Simon


Thank you.
But i need to backup my database twice in day, in later maybe more.
MSSQL Server is in local area with my server. Can i share folder or
disk to copy backup by script to? Or MS SQL Server can't make backup
files on share-dick?
Thank you very much.


I think I didn't understand your question - if both servers are on the same
LAN and in the same domain, then there should be no problem. MSSQL can back
up to a UNC path, like \\server\sharename, but to do this the MSSQL service
account needs to have access to the target UNC path. So it must be running
under a domain account, not the LocalSystem account. Then you can do
something like this:

backup database MyDB to disk = '\\myserver\backups\mssql\mydb.bak'

See "Setting up Windows Services Accounts" and "BACKUP" in Books Online.

Simon
Jul 20 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.