Results 1 to 8 of 8
  1. #1
    Join Date
    Jul 2002
    Location
    Lima - Perú
    Posts
    30

    Angry Unanswered: looooong backup differential

    I am making backup of several data bases to tape, Sunday run backup full and the particular days backup differential, the problem is that backup differential delays more than backup full, I must mention that I am using the option nounload.

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322

    Re: looooong backup differential

    Originally posted by lvigo
    I am making backup of several data bases to tape, Sunday run backup full and the particular days backup differential, the problem is that backup differential delays more than backup full, I must mention that I am using the option nounload.
    Can't you dump to disk, then copy the file to tape?

  3. #3
    Join Date
    Jul 2002
    Location
    Lima - Perú
    Posts
    30
    No, i don't have disk for thaht, but what is the technical solution ??

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Originally posted by lvigo
    No, i don't have disk for thaht, but what is the technical solution ??
    You have to have a hard drive...is it raid? How big is the hard drive?

    Are you using the gui to set up backups or using t-sql?

    Also what version of sql server?

  5. #5
    Join Date
    Jul 2002
    Location
    Lima - Perú
    Posts
    30
    I don't have disk space for make a backup. The version is 7. with sp 3

  6. #6
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Originally posted by lvigo
    I don't have disk space for make a backup. The version is 7. with sp 3
    you can use UNC filenames to make the backup...but going across the network mught be slower...

    But if you're running out of room on tape...then you might have no choice.

    Are you overwriting the nightly dump, or appending?

  7. #7
    Join Date
    Jul 2002
    Location
    Lima - Perú
    Posts
    30
    I need make the backup to tape, full backup is executed the weekend and on the same tape we append the differential backup of the other days.

  8. #8
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Originally posted by lvigo
    I need make the backup to tape, full backup is executed the weekend and on the same tape we append the differential backup of the other days.
    Are you using 1 tape? How full is it? Can you swap out the Sunday tape with the full back ups and put a new 1 in for differential...if the get to big can you swap them out every night...

    just guessing...need to know what you're doing...

Posting Permissions

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