Results 1 to 3 of 3

Thread: BackUp

  1. #1
    Join Date
    Aug 2003
    Posts
    2

    Unanswered: BackUp

    I have a real time database and backup database. I want to create a DTS package to copy the data from real time to backup in bulk mode.

  2. #2
    Join Date
    Oct 2001
    Location
    Naples, FL
    Posts
    273
    You might think about using standard backup and restore, it is faster than a DTS copy of any sort. I use a utility called robocopy from one of the res kits for Windows to copy only the new files to a remote server (tran logs and backups)

    HTH
    ---------------
    Ray Higdon MCSE, MCDBA, CCNA

  3. #3
    Join Date
    Dec 2002
    Location
    Antwerp, Belgium
    Posts
    227
    you can use log shipping to transfer transaction logs to another server
    Johan

Posting Permissions

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