shrink mssql database

If you have large MSSQL database then you can shrink it to free up some space on SQL server. This shrinking process will remove the unused space from database. You can follow below steps to shrink database via Microsoft SQL Management Studio Login to your SQL server. Now expand databases and...

Steps to shrink your MSSQL database log file Transaction log file (.IDF) keeps on increasing at all instances. When it exceeds after certain limit then you have to shrink the transaction log file like the database. There is a common question why the log file transaction keeps on increasing...