-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: VaibhavModak
Message 2 in Discussion
Hi, The size of the log files can be physically reduced by using : A DBCC
SHRINKDATABASE statement .
A DBCC SHRINKFILE statement referencing a log file . Syntax: DBCC SHRINKDATABASE
( database_name [ , target_percent ]
[ , { NOTRUNCATE | TRUNCATEONLY } ]
)
Example to decrease the size of the files in the Pubs database to allow 20% free space
in the files of Pubs. DBCC SHRINKDATABASE (Pubs, 20)
For maintaining your database files: 1) Take a backup of your log file. 2) Execute
the DBCC SHRINKDATABASE to shrink the size of the database. For more details search
for the topic "Shrinking the Transaction Log" in SQL Server BooksOnline OR check this
MSDN link for the same article:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_da2_1uzr.asp
-- Regards, Vaibhav Modak
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you received
this message by mistake, please click the "Remove" link below. On the pre-addressed
e-mail message that opens, simply click "Send". Your e-mail address will be deleted
from this group's mailing list.
mailto:[EMAIL PROTECTED]
