Dear Professional,

Just want to ask one question.

Three months a ago one of my database size was 5 GB and now it's 12 GB but I
didn't see much data from last three months, is there anyway I can findout,
do I have to shrink the data file or shrink the database because in three
months double the size means something is fishy.

Please advice.

Thanks in advance

If the database is in Full Recovery mode and you're not doing transaction
log backups, the transaction log continues to grow forever. Look in Books
OnLine for details and the backup procedure. You will also see how to check
the separate data and log sizes. Shrinking the database will make the
transaction log grow even bigger, negating any size reduction from the data
portion.

"Noor" <naissani (AT) hotmail (DOT) com> wrote

Thanks Paul,

Recovery Model is FULL
This database also Mirror to another Servers. (implemented database
mirroring)

I shrink the log file and that works fine, I am worry about DATA FILE.

Please advice.

Thanks
"Paul Shapiro" <paul (AT) hideme (DOT) broadwayData.com> wrote

Impossible for us to say. Something causes the database data files to
autogrow (as you told us), but that is also all you told us. Index
fragmentation is one possibility. Or perhaps something just added data
enough to justify that growth. Did you analyze things such as used
space, free space what tables and indexes uses most space?

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"Noor" <naissani (AT) hotmail (DOT) com> wrote