Database Clean Up

DELETE
FROM         tblInvoiceTags
WHERE     (TaggedTime < '1/1/2005 12:00:00 AM')

DELETE
FROM         tblInvoicePayment
WHERE     (PaymentDate < '1/1/2005 12:00:00 AM')

DELETE
FROM         tblInvoiceRack
WHERE     (RackDate < '1/1/2005 12:00:00 AM')

DELETE
FROM         tblLots
WHERE     (LotDate < '1/1/2005 12:00:00 AM')

DELETE
FROM         tblRefund
WHERE     (RequestDate < '1/1/2005 12:00:00 AM')

DELETE
FROM         tblVoidInvoices
WHERE     (VoidDate < '1/1/2005 12:00:00 AM')

DELETE
FROM         tblInvoices
WHERE     (DropDate < '1/1/2005 12:00:00 AM')


DBCC SHRINKFILE (dcp_log,TRUNCATEONLY )



Please change the recovery mode to SIMPL