Your Ad Here

advanced code snippet search

Posted By

burnsra on 01/13/09


Tagged


Versions (?)

Shrink Databases

 / Published in: SQL
 
Expand | Embed | Plain Text 
  1. USE kpi
  2. dbcc shrinkfile ('kpi_log', 1)
  3.  
  4. USE tempdb
  5. dbcc shrinkfile ('tempdev', 1)
  6. dbcc shrinkfile ('templog', 1)

Report this snippet  

You need to login to post a comment.