March 23, 2007 at 8:48 am
I am working with a SQL Sever 2000 database. After making a backup and restoring it, and also detaching and reattaching
the database, the size of the database suddenly double. Can anyone explain what might have happened? Or what can be done to get it back to the original size?
March 23, 2007 at 9:06 am
Ran any big index maintenance lately?
Changed a clustered index or PK on a big table?
March 23, 2007 at 9:16 am
No. Nothing at all. The database has been unchanged for a few weeks. Someone requested we look at a previous version, so I did the following:
1) Backed up the original
2) Detached the original
3) Rename the original with the date added as a suffix.
4) Copied an older version to the Data folder.
5) Attached the older version.
6) Detached the older version.
7) Renamed the original to its original name.
8) Attached it, but it was not the original data.
9) Panic set it.
10) Restored the backup, but it was not the original data either.
11) From this point on I was coping, detaching and attaching like crazy.
12) Eventually, the original data was showing, but the size had doubled.
March 23, 2007 at 9:47 am
Is it possible that a restore appended the data to the original database (asking anyone alive for this one)?
March 25, 2007 at 11:05 pm
What has doubled? The data file? The log file? Both?
My suspicion is that in all the attach/detach/reattach/restore panic, you only think it has doubled in size, but it hasn't.
What makes you think it has doubled in size?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply