Post reply

How to Backup Remote MsSQL database?

  • July 5, 2004 at 8:31 am

    #108552

    Hi,

    My friend has a web site.

    He has a site with ms-sql database. He is using it. Now, hw wants to backup the database. but we cant. there is no such thing at the control panel.

    it only allows us to open a new database. not see whats in nor backup.

    I have installed Microsoft SQL Server and tried to backup with Enterprise manager.. but it failed.

    Now, How  can i connect and backup the database.

    it maybe an asp script, or a program.. but please help me...

  • July 5, 2004 at 12:29 pm

    #513347

    You probably won't be able to without contacting the web hosting company.  Generally, they will make a backup nightly though.  They will need to make you a Backup Administrator to allow you to perform backups; and I doubt they will.  Generally, you can request an adhoc backup and just pay a one-time fee.

     

    Derrick Leggett
    Mean Old DBA
    When life gives you a lemon, fire the DBA.

  • July 5, 2004 at 3:29 pm

    #513355

    Thanks for your reply.

     

    Site doesnt belongs to me %100, When i asked the host for help they wanted a different username.. so it didnt worked. Now i am looking some other ways..

  • July 6, 2004 at 12:21 am

    #513394

    A simple approach:

    backup database northwind to disk = 'c:\yourfile.bak'

    but this ends up at c:\ at the server c:, not your own local disk, and, yes, you need db_backupoperator or db_owner rights.

  • July 6, 2004 at 1:15 am

    #513406

    About the only "backup" you can do via the Web is to create an ASP page that dumps the data from all tables as a text page in some delimited format (CSV, tab).  You would then have a copy of the data stored locally. 

    I've used this to make a local copy of the tables on a development server. I formatted the data for BCP insertion into an MSDE version of the database (on my laptop) so I could work while sitting in the airport.

    If you put the data into BCP or CSV format, the web hosting company could possibly restore it for you if needed.

    John

     

  • July 6, 2004 at 1:38 am

    #513408

    Those all means "No WAY"

  • July 6, 2004 at 4:53 pm

    #513532

    I don't think so....

    You can try using DTS to copy all your tables (with content) from the site into a local (on your pc...) copy  of the database.

    Just build a package with a 'transfer object' task, where you put all your tables, and if needed all other objects (sp/view/...)

    I'm using this to save my data from my provider (in California) to my local pc (I'm living in Italy....)

    HTH

  • July 6, 2004 at 10:27 pm

    #513561

    Just contact your hosting company.  They're generally very cooperative.  There's a lot of competition out there.  If they're not cooperative, remind them of this fact.  You are their customer.

    Derrick Leggett
    Mean Old DBA
    When life gives you a lemon, fire the DBA.

  • July 7, 2004 at 3:28 am

    #513587

    Thanks everbody

Viewing 9 posts - 1 through 8 (of 8 total)

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