Size of database

[bishop_2]

My company installed Solomon 6.5 on December 1 to a proliant g4 server. Sql enterprise edition is now telling me that the database is 115GB how could this be and what could have caused

[Igor Karasik]

Check if transaction log or data take this space.
If transaction log grows - you need to do regular transaction log backups or set recovery model of the database to "Simple"
See
http://support.microsoft.com/kb/873235/en-us#XSLTH3179121122120121120120
for more information

[bishop_2]

thanks, I checked it the log files are extremely big so I shrunk and truncated them will this have any impact the systems funtionality

[Jon Finley]

Hopefull you did a backup through SQL first?

The backup would force a checkpoint, allowing you the option of getting rid of the transaction logs prior to the backup date/time.

Jon

[Igor Karasik]

Transaction log files can be used for restore.
You need to do one of the two things:
-do regular transaction log backups
-change database Recovery model to "Simple"
No any impact to systems funtionality, but you need to decide what to do with transaction logs according your disaster requirements plan

Since you are new on this forum see:
http://forums1.itrc.hp.com/service/forums/helptips.do?#22