Syntax for Shrinking SQL Server database mdf and log file

Try the following code through your Query Analyser to shrink the database.

backup log <database_name> with truncate_only
use <database_name>
dbcc SHRINKFILE (<database_name_Log>,2)
dbcc ShrinkDatabase (<database_name>, 2)

Post New Tips/Tricks

View all Tips/Tricks

Featured Resources:

Web Application Security — How to Minimize Prevalent Risk of Attacks

Vulnerabilities in web applications are now the largest vector of enterprise security attacks.

Introduction to Web Applications Development

This 376 page eBook "Introduction to Web Applications Development", starts with an introduction to the internet, including a brief history of the TCT/IP protocol and World Wide Web.

100% Free Subscription until Stock lost.View complete list.