You are here: Re: Database Tripled In Size!! « MsSQL Server « IT news, forums, messages
Re: Database Tripled In Size!!

Posted by Neil on 12/31/07 01:37

> OK, so there is obviously a lot of air in that table. No idea where it
> came from.

Yeah, it seems that we'll never get to the bottom of that.

> o Rename it.
> o Create it again.
> o Move the data to the new table.
> o Recreate triggers, indexes and constraints.
> o Move referencing constraints.
> o Drop the old table.
> o Shrink the database.

I think that's a good idea. What about the idea of just exporting it to a
blank db, like I did today, with the triggers, indexes, and constraints in
place, and then reimporting it with those? Then only the referencing
constraints would have to be recreated.

> I would suggest that you first do this in a test environment to see that
> it works well. And, oh, I would also suggest that you download SQL Compare
> from Red Gate (www.red-gate.com) to compare the schema of the database
> after the change with a reference copy. SQL Compare has a price tag, but
> there is a preview period you could benefit from. Caveat: I don't know if
> they support SQL 7.

I'll look into that. Thanks!

Neil

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация