var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Compressing SQL Server Database
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.
You can do this..
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