Results 1 to 5 of 5
  1. #1
    Join Date
    May 2006
    Location
    Sweden
    Posts
    2

    Question Unanswered: Backup MS SQL Server using ASP.NET

    Hi!

    For the moment I’m hooked up with this hosting company that refuses to give me any backup files of my Microsoft SQL Server database/tables. I’ve even asked if the can do it just once but they still won’t. I don’t know what they are doing because they won’t even let me use Enterprise Manager so, from what I know, can’t use the scripts that I’ve found that use stored procedures.

    Which is the easiest way to do a full backup just using the built in functionality of ASP.NET 1.3 and with limited permission on the SQL server? The goal is to move everything to a new company.

    A friend recommended this way:

    Create a class that holds both the table structure and a dataset for the data.
    Each instance of these class is then stored in a collection that we serialize and store on the web server.
    When this is done we reverse the process at the new hosting company.

    Would this work / be the easiest way?

    Thanks
    Last edited by wmli; 05-14-06 at 14:55.

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    You can take help of SQLDMO in this case, refer http://www.aspfree.com/c/a/VB.NET/Si...O-Using-VBNET/ and http://codingforums.com/archive/index.php?t-25387.html for information.

    HTH
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    May 2006
    Location
    Sweden
    Posts
    2

    Thumbs up

    Thanks!
    I've got the same advice on another forum, http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=66036 (remove if it's not ok to link), who also suggested using DMO.

  4. #4
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734
    Hey...I think that was me.

    How you doing Satya???
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

  5. #5
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Hi Derrick
    Thanks, I'm fine.. hope you had a good holiday as I don't see on the forums since a month (I think).
    Its good to catch other forums too ... different from routine
    Quote Originally Posted by derrickleggett

    How you doing Satya???
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •