Can someone assist me in shrinking the jounals tables?
Dexter
shrinking journals
Jan 14, 2008
3 Replies
Run this SQL statement in Administrator
DELETE Journal WHERE time < getdate()-365
The above statement will delete all journals over 12 months old (alter the number of days as required)
and then run this SQL statement
dbcc shrinkdatabase (DatabaseName)
Michael
Thanks for your help. This is the statement i tried to run- dbcc shrinkdatabase (7-11dataHigh). I got an error. what am i doing wrong.
Please assist.
Dexter
"Michael" wrote:
Do not put the database name in parentheses.
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required