CODEWITHSUNDEEP
sql-serversql-server-2008
Refti
Refti

Reputation: 755

SQL Server Database Size Reduction Query

I have a SQL Server 2008 Express Database which is 7.8 GB in size

DataFile 1.2 GB
LogFile 6.6 GB

Recovery Model = Full
Auto Shrink = False

On a Live database, what is the best way to reduce the size of this database?

Upvotes: 1

Views: 1202

Answers (2)

Amit Gajjar
Amit Gajjar

Reputation: 51

  • You can also identify unused tables and remove those tables(if there is)
  • you can create Archive database that will stored some old unused data
  • you can normalize your database more to reduce table size.

hope this information helps you.

Upvotes: 1

Steven Berkovitz
Steven Berkovitz

Reputation: 781

Before you can shrink a database running in full recovery model, you must backup the transaction log. So the procedure is to run a transaction log backup, and then shrink the log file.

If you have never performed a transaction log backup then you will continue to suffer from run-away log files and shrinking it will only be a band-aid solution.

Upvotes: 1

Related Questions