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<anuke@.bk.ru> wrote in message
news:e23cb98a.0410080308.1596832a@.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|||"Simon Hayes" <sql@.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.|||<anuke@.bk.ru> wrote in message
news:e23cb98a.0410090412.2473a5ec@.posting.google.c om...
> "Simon Hayes" <sql@.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
