How to reclaim unused space for SQL DB

 Error:

Many times, after deleting SQL data from tables won't reclaim the unused space.


Solution:

Easy way is to click DB from SQL Studio

Tasks->Shrink ->Files

choose the default "release unused space" option.




No comments:

Post a Comment

How to increase ESXi webclient login user application timeout

 To increase the default 15min timeout to 2hr Login to the esxi webclient on the right top corner ->Click the User login tab Select "...