March 26, 2017

Decrease SQL Server Database and Table Size with simple steps

In this clip shows you Practical Tips to Reduce SQL Server Database annd Table Size .

The  Steps are provided but process is taking time so final result not shown . You can check from your end by applying steps and it will be for your practice exercise also.

How to Shrink MDF,LDF Database Data  and log File in SQL Server and How to check size of all tables in database.

Script is  provided to get all table records count,used space,unused space etc.

  You can check single as well as multiple table details by checking query in script.

If you clean log files before database shrinking then you will able to decrease more size for database.

Database size increased due to daily transaction by users and log file size getting huge so you can see this clip to reduce the size of database to improve disk space.

You can also set batch job to do in automatically based on time frame you given for batch job in SQL.

You can visit below online clip to get more details.

If you like this clip do not forget to subscribe it to get more updates on SQL database administration.