SQL DB SHRINK
SQL 2005
BACKUP LOG DesignerStencils to DISK='NUL:'
DBCC SHRINKFILE (DesignerStencils,500)
SQL 2000
DBCC SHRINKFILE (FileName_log, 500)
DUMP TRANSACTION DATABASE_NAME with no_log
http://support.microsoft.com/kb/272318/
Trouble logging in? Simply enter your email address OR username in order to reset your password.
For faster and more reliable delivery, add HelpDesk@VSSBusinesssolutions.com to your trusted senders list in your email software.
A code was sent to the recovery email address. Please provide the 6-digit code.
A code can be retrieved from your authentication app. Please provide the 6-digit code.
An email was sent to your recovery email address. If you need further assistance, please contact your system admin.