Your points really clarify the issue at hand. Thanks a lot.

Karim

Dear Rama,

Do you mind explaining how a step object controls a task object? If there is a one-to-one corr. between task and step objects, then how can a single step...

Steve,

First of all, I really appreciate your compliment.

I am still somewhat confused regarding this MinLSN concept. BOL states that the MinLSN is the minimum of the LSN of the start...

Thanks a lot, Yelena. Your point does make sense. Basically, if I am getting it right, you are saying that one should let the database stay in bulk-logged recovery mode...

Steve,

I greatly apologize if my questions have disturbed you or other people. The fact is that I am currently in the process of learning SQL Server. I am not a...

Thanks a lot, Kevin. Your explanation of the need to backup both table and index at the same time in simple recovery model makes a lot of sense b/c transaction...

Thanks Ray. But I have a question there. In BOL, there is a separate question right after the critical periods question that states the following:

When does the database experience heavy...

Thanks Vladan. I do get your point.

Would you forget to load the tape because backups take place automatically and your share in the job is to basically load the tape which you forget to do, leading...

Dear Kevin,

I am sorry but I couldn't follow you exactly. First of all, I don't understand what you mean by rolling forward a database. I also don't understand how you would do...

The table states that when switching from full recovery to bulk-logged mode, no action is required. But I would like to know why since if you want to recover up...

Also, could someone clarify one more thing: when indexes are created in the bulk-logged recovery mode, is index creation fully logged as in full recovery mode or are they minimally...

Thanks a lot, Paul. I really appreciate that you took the time to clarify this.

Thanks a lot. Your answer really helped me understand how differential backup help SQL scale.

Thanks a lot. The question that popped up in my mind was that when you shrink a file with the SHRINKFILE command, does it compact the data to the front...