• What is the recovery mode of your database? Do you have transaction log backups set up?

    John