SQL Server Performance Forum – Threads Archive

Dabase size grwoing very fast

My database size growing rapidly. Shall i take some precaution measure except backup. Lalit

Is database full recovery model? Check property of the database Options.
If yes : how often you do transaction log backups?

You might want to calculate time before you run out of disk space. An approach to this you find here:
http://vyaskn.tripod.com/track_sql_database_file_growth.htm ———————–
–Frank
http://www.insidesql.de
———————–

]]>