Advanced Search

Shrink Databases

/ Published in: SQL
Save to your folder(s)

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  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


Comments

You need to login to view comments.