Subject | Can't backup/cleanup DB |
---|---|
Author | chumlyii |
Post date | 2003-12-09T13:37:29Z |
I have inherited a database that was not maintained for some time.
Unfortunately the designer also designed it to create a huge amount
of uneeded audit records (18 million records). The single file DB is
approching 3.7gig and is about to run out of room.
3 weeks ago I was able to backup the entire DB.
I then deleted the offending 18M rows
I then tried to do a backup and the process ran for nearly 48 hours
before I had to kill it. The CPU usage goes straight to 100% and
stays there. I finaly had to kill it because the customer needed to
print from this machine (another great idea by someone to put the
print que's for the site on this machine).
I brought back the original backup and did the same delete and backup
here on our server and it ran fine in about 1.5 hrs.
How can I save the DB onsite? My working backup is 3 weeks behind
production data, Is there an easy way to just extract the new records?
Any help appreciated
Barry
Unfortunately the designer also designed it to create a huge amount
of uneeded audit records (18 million records). The single file DB is
approching 3.7gig and is about to run out of room.
3 weeks ago I was able to backup the entire DB.
I then deleted the offending 18M rows
I then tried to do a backup and the process ran for nearly 48 hours
before I had to kill it. The CPU usage goes straight to 100% and
stays there. I finaly had to kill it because the customer needed to
print from this machine (another great idea by someone to put the
print que's for the site on this machine).
I brought back the original backup and did the same delete and backup
here on our server and it ran fine in about 1.5 hrs.
How can I save the DB onsite? My working backup is 3 weeks behind
production data, Is there an easy way to just extract the new records?
Any help appreciated
Barry