SQL Server, database update

• Gabe-650699

  Newbie

  Points: 1

  More actions

  April 29, 2008 at 1:37 am

  #125073

  Hi!

  Here is my situation. I have one production database running with multiple tables. I also have a backup of that same database on another server just in case the database goes down. Everyday I have to update the data on the backup database. Is there a way I can append all new records for each table on the backup database using some kind of automated form. Like a store procedure or DTS?

  😀

• rlondon

  SSCarpal Tunnel

  Points: 4653

  More actions

  April 30, 2008 at 7:58 am

  #809044

  Have you thought about log shipping, replication or database mirroring? Here is a link you might want to look at that describes all three options.

  http://www.logicworks.net/page.php/prmID/313