Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Posts
    23

    Unanswered: backing up database

    Here is the situation, I have a web application (asp.net/vb.net) with ms sql 2000 as the database. I have two database server. I would like to backup database 1 with database 2. I would like to do it at intervals and through code. If anyone can give me some ideas on how to do this or any research material, please do.

    Thanks

  2. #2
    Join Date
    Apr 2003
    Location
    Washington DC area
    Posts
    1,770

    Use the Utility

    And the copy the stript

  3. #3
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734
    You will need to set up a linked server. You can then run:

    EXEC SERVER.master.dbo.xp_executesql @backup_command
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

Posting Permissions

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