• if your database is using the full or bulk logged recovery model take a transaction log backup using the following

    BACKUP LOG [MYDB] TO DISK = 'some drive\some path\mydb.trn'

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉