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.
PoisonHi
Thanks Alot .. I have resolved the issue...|||What was the resolution?|||I would bet that one of the methods was not initializing the backup file, but appending to it.|||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...|||backup ... with init
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment