How to handle melon of record in SQL server

Question

In SQL server every time i got Filegroup is full, Execution timeout. How can i release some space in SQL database.

System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

Answer 1

You can shrink the SQL Server Database Size.

Step 1: Right-click on the database name >> Tasks >> Shrink >> Database. Step 2: Then Click OK.

for more details you can read the following blog https://stackoverflow.com/a/18292136/1805776