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.




at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

how to unlink a NIC from a esxi vSwitch

  List the vSwitches from ESXI using CLI:          esxcli network vswitch standard list  output example: vSwitch0    Name: vSwitch0    Class...