Help needed with Backup and Restore

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Vincento Harris
    #1

    Help needed with Backup and Restore

    If I decide to backup my transaction logs on one server and move them
    to another server with the same "everything "

    What do I need to do in order to automate this if it is possible


    Vincento
    Tags: None
    • Simon Hayes
      #2
      Re: Help needed with Backup and Restore


      "Vincento Harris" <wumutek@yahoo. com> wrote in message
      news:2fa13ee7.0 410121038.777ed 048@posting.goo gle.com...[color=blue]
      > If I decide to backup my transaction logs on one server and move them
      > to another server with the same "everything "
      >
      > What do I need to do in order to automate this if it is possible
      >
      >
      > Vincento[/color]

      It sounds like you're looking for log shipping - if you have SQL 2000
      Enterprise Edition, then check out the information in Books Online. If you
      don't, then it's still relatively easy to implement something yourself:

      http://www.winnetmag.com/Article/ArticleID/23231/23231.html

      http://sqlguy.home.comcast.net/logship.htm

      http://www.sql-server-performance.com/sql_server_log_shipping.asp


      Also search Google for "log shipping" and you should get plenty of hits.

      Simon


        Comment

        Previous template Next
        Working...