Newbie - SQL 2000. I have a database file 150 MB and my log file is 400 MB. Is there anyway I can compress the size of these files.
Thanks,If you don't need to take the backup of the Transaction Log:::
Take the full database backup(Recommended not Reqd)
go to Query Analyzer and
use [your database]
backup TRAN [your dbname] with no_log
once it's over then you can run:
dbcc SHRINKFILE([YOUR DBNAME_LOGFILENAME,TRUNCATEONLY)
and it will reduce the size of the Transaction Log
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment