Post reply

backup database data on the server

  • September 24, 2008 at 1:59 am

    #382790

    Dear All,

    I have a hosting account with a hosting company, and I have an SQL database hosted with them. My problem is that every time I have to backup the database, or upload a backup to restore the database, I have to ask them to do it, and it could take 8 hours before they reply.

    Is it possible to create some sort of script or SSIS package, to move the data from the server back and forth for example every day? I was thinking about the Import/Export option, however I am not aware if there is maybe something simpler than that.

    Thanks for your help

    Johann

  • September 24, 2008 at 4:00 am

    #876201

    Create job for backup.

  • September 24, 2008 at 4:10 am

    #876204

    Its very hard to do that, since I do not have access to the hosting machine, and if I do create a job, i will not be able to retreive it from their servers

  • September 24, 2008 at 7:41 am

    #876353

    What type of agreement do you have with them ?? Why can't you access your own servers ?

  • September 24, 2008 at 7:48 am

    #876360

    well i have a control panel, however I cannot access the servers physically.

    I am not paying so much monthly, its not a really big site, that is why I accepted that.

  • September 24, 2008 at 7:59 am

    #876375

    Even if you don't have physical access, you should have some kind of remote admin logon ability.

  • September 24, 2008 at 8:10 am

    #876386

    yes I can connect an instace of SQL Server on my local machine to the remote database.

    However if I create a Job on their database (remote), I still cannot get the .bak file right?

  • September 24, 2008 at 8:31 am

    #876406

    Do you want to move backups on and off the server ? I would think you should have "Remote Desktop" or something similar. Can you map to a drive on the server ?

  • September 24, 2008 at 8:39 am

    #876418

    yes i would like to move backups off and on the server.

    I have remote access, however I cannot map to a drive on the server, because of security reasons

  • September 24, 2008 at 9:26 am

    #876460

    How about FTP access, yes?

    Typical web hosting will give you control panel, file manager, FTP

    Not necessarily Remote Desktop or VPN

    so

    1. issue a backup in T-SQL, or create a job to FTP Directory

    2. download the .bak via FTP

    We have Remote Desktop to our remotely hosted servers, we still download BAK via FTP (VPN is way too slow)

    SQLServerNewbieMCITP: Database Administrator SQL Server 2005

  • September 24, 2008 at 9:43 am

    #876473

    I will try to do that.

    I will see if I have permissions to browse the folder.

    Thanks

    Regards

    johann

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

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