GilaMonster, One small information I want from you. Do we need to restart the sql service everytime we enable any trace or this is applicable to only some of the...

Thanks for this information to all... I shall always keep default trace running to avoid such happenings. Is this a good practice. Please let me know whether this is a...

Thanks Gila for nice explaination. One curiousity here. When we make the recovery model = simple and the create the checkpoint and then again change this to full backup. Does...

Thanks so much. Somehow I am not able to run the command. I am sure that you would have got the correct result of your respective queries ...

Msg 208, Level...

BACKUP LOG TESTDB WITH TRUNCATE_ONLY

I wanted to understand where this backup is taken. I couldn't find the backup of the transaction log.

Gilla you are correct. I found somewhere that the...