The more transactions, the greater the size of the database, the greater the size of the database means that many of the processes that have occurred, the whole process was well saved by the server in the LOG file. For most who frequent database Meadowsweet sometimes this can be a problem if the size of the LOG become increasingly bulge to shrink it needs to be done in order to be efficient storage disk locations.
Reduce/remove SQL Server 2000 database log
BACKUP LOG DatabaseName WITH TRUNCATE_ONLY DBCC
DBCC SHRINKDATABASE (DatabaseName, 1)
Reduce log for SQL Server 2008
BACKUP LOG NamaDatabase TO DISK='Null'
DBCC SHRINKFILE(NamaFileLogicalLDF, 0 , TRUNCATEONLY)
DBCC SHRINKDATABASE( DatabaseName, 0,TRUNCATEONLY )
note: use this code for see the database properties
A portal that has dedication and concentration in the development of computer programming and more
resource for help people such as open project, jobs, question & answer, additional tools, and many more.
Collection of various kinds of code programming language from desktop to web programming.