Hey there, IT folks,
Over the last 9 months, our database size has nearly quadrupled.
Would there be any way that just the creation of performances--with no transactions on them--could contribute unduly to use of space?
What would be the likely areas that would contribute most to such growth?
Thank you,
sharon,
Cincinnati Symphony
Hi Sharon,
Good day.
there are a lot of different ways to control the db growth.
http://www.sqlskills.com/BLOGS/PAUL/post/Importance-of-proper-transaction-log-size-management.aspx
http://support.microsoft.com/kb/873235
have fun.
Ben