backup database data on the server

  • 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

  • Create job for backup.

  • 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

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

  • 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.

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

  • 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?

  • 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 ?

  • 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

  • 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
  • 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