deleting journal entries when your SQLEXPRESS DB is full

i was wondering if you knew a way to change that command to move those journals entries to another database rather than deleting them?

I'm looking to append this data to an archive database

thanks Wil

Why not just backup the database then delete the journal records and keep the backup as a journal archive?

Yes. That is what I did. I made a backup. But honestly we do 900 transactions a day in that store. I don't need to keep too much information.

Jason

Im posting this here because I forgot it in the past and didn't write it down. If your SQLEXPRESS DB is full and you want to delete entries in the Journal you cannot use Administrator to run your query. You will get an error.

Use SQL Server Management Studio Express to run

delete from journal where time < getdate()-365

and it will work.

This usually is a very stressful situation because your register will throw errors until this is fixed and when the query doesn't work it gets more stressful.

Hope this helps someone.

Jason