Can someone assist me in shrinking the jounals tables?
Dexter
- posted
16 years ago
shrinking journals
Loading thread data ...
- Vote on answer
- posted
16 years ago
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)
- Vote on answer
- posted
16 years ago
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:
- Vote on answer
- posted
16 years ago
Do not put the database name in parentheses.