To reduce the database size:

Modified on Thu, 26 Mar, 2020 at 8:27 AM

To reduce the database size:

 

In SSMS, Right-click on the database name >> Tasks >> Shrink >> Database.

 

In SQL, DBCC SHRINKDATABASE (DatabaseName, 'target percent')  Example: DBCC SHRINKDATABASE (test, 10);

 

To reduced the ReportFYI, purging the reports usually frees up space.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article