Results 1 to 6 of 6
  1. #1
    Join Date
    May 2007
    Posts
    23

    Unanswered: Database Backup Issue

    Hi Guys
    I have been working on database backups and recently I realised, when I take back up from enterprise manager and by my own scripts, these two files have differ in size like first one is MB and second one is GB.

    Procedure One: I Have my own script to take backup
    Checking DB Integrity
    Rebuilding Table Indexes
    Shrinking DB
    DB Full backup

    Procedure Two: Simply by right clicking on the DB using Enterprise manager.

    Your advice will be appreciated.

    Poison

  2. #2
    Join Date
    May 2007
    Posts
    23

    Resolved

    Hi
    Thanks Alot .. I have resolved the issue...

  3. #3
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    What was the resolution?
    George
    Home | Blog

  4. #4
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    I would bet that one of the methods was not initializing the backup file, but appending to it.

  5. #5
    Join Date
    May 2007
    Posts
    23
    Hi Geroge
    With my script I was appending the data where as in Enterprise manager I was backing up with over write option...
    Its my mistake....

  6. #6
    Join Date
    Jun 2004
    Location
    Long Island
    Posts
    696
    backup .... with init

Posting Permissions

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