dcsimg
LinkedIn
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


advertisement
 

Tip: Using DBCC SHRINKDATABASE

See how to easily shrink the size of the data and log files in a database.


advertisement

The following command shrinks the size of the data and log files in a database. Here is a small example:

DBCC SHRINKDATABASE (Database_Name, 10);  

This allows for 10 percent free space in the database.

 

Visit the DevX Tip Bank

 



   
Email AuthorEmail Author
Close Icon
Thanks for your registration, follow us on our social networks to keep up-to-date