Post reply

Back up file to big

  • January 25, 2005 at 12:30 pm

    #110089

    Hi, I´m  using the Bakup Database tool in Sql Server 2000, I have a 7Gb Database and when I create the database backup the file size is 23 Gb, why is this?, in other times that I used the same tool I had a 7 Gb file size.

    Thanks a lot.

    Sincerely er_sql

  • January 25, 2005 at 12:48 pm

    #539029

    If you are backing up using TSQL make sure that you use WITH INIT or you'll wind up appending to the previous backup. If through enterprise manager make sure that you select the overwrite existing media option.


    Shamless self promotion - read my blog http://sirsql.net

  • January 25, 2005 at 1:55 pm

    #539042

    You also may have a huge transaction log. A full backup takes a backup of the data file and the transaction log. TLogs should never grow as large as 16 gig but if you leave it unattended it is possible.

    I would say its either due to the appended backup or a large transaction log.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply