After deletion of table data , how can free space from data base

shantanu

After deletion of table data , how can free space from data base

Slawek_Guzek

Depends.

If you are using NAV native database the only way is to make a backup and restore into new, smaller database file.

If you are on SQL you can use DBCC SHRINKFILE command, or DBCC SHRINKDATABASE, or shrink the database or individual files from SQL Server Management Studio: righ-click your database, select Task -> Shrink -> Database or File

Shrinking individual fiules will give you better control of the process.

Just remember that shrinking is very time consuming process and it ruins internal indexes structure - so it is highly recomended to run index optimisation after the database or individual files have been shrunk.

In my experience it is also quicker to execuite shrink in small steps, say 1GB size. Running 20 steps shrinking the database file by 1GB each time is quicker that shrinking it by 20GB in one go.