Shrink Journal Database Question

Mar 02, 2009 2 Replies

Rate this thread:

Lance 17 years ago

We have SQLExpress and are nearing my size limit. We installed SQL Express because the we needed the extra space. When I was shrinking the database before SQLExpress, I would use the following instructions:

"You will need to do two things to shrink the database. I assume you are comfortable getting into Store Operations Administrator. If so, use the following instructions:

Make a backup of the database.
Enter Administrator | File | Connect.
Connect to your database by selecting it and clicking OK.
Go to Query | New
Type: select * from journal
Query | Run
Write down the ID from the last journal you want to keep. This will be X.
Go to Query | New
Type: delete journal where ID < X
Query | Run Next we need to shrink the database:
Go to Query | New
Type: dbcc shrinkdatabase (XXX) where XXX is the name of the database
Query | Run

Would the same intructions apply for SQLExpress?

Vote

Peter Johnson w 17 years ago

Lance, they should still apply. Just backup your database before you begin, yes? and then you could always go back to what it was, or?

Peter Johns> We have SQLExpress and are nearing my size limit. We installed SQL Express

Vote

Robert 17 years ago

You can also run this DELETE MyDatabaseName.dbo.Journal where time < getdate()-x Where X is numbers of days of journal you want to keep

after you delete the journal

dbcc shrinkdatabase (DatabaseName) then reindex (Store operations -->database-->reindex) I run this combination of shrink and reindex 3-4 times One time a ran some tests and each time i did it the database got a bit smaller , it stopped making a significant differance after about 5-6 run I don't know why it gets smaller on each run but it does and does not seem to affect the database

As always test all of this on your test system and backup before you run on live system

H> We have SQLExpress and are nearing my size limit. We installed SQL Express

Vote

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required