Now I am confused :unsure:, between checkpoint making sure we recover within a small interval and us making sure we allow the db to shut down cleanly what would be...

I think the OP is really looking for an answer as to what happen during the application of the log backup during recovery i.e what gets rolled forward vs what...

The below link shows how log backups are used , and should help you understand what happens to the transaction in the log backups

http://msdn.microsoft.com/en-us/library/ms190440.aspx

in particular the section

How Are Log...

Why would you want to avoid columns in the Group by clause , btw you could also you Select distinct.

I know there is a difference in performance based on...

Being DBA is a lifestyle choice as well 😀 , stressful work environment esp when things go bad as well as night shifts etc and being the guys who...

Moral of the Story :-before shutting down the OS give SQL enough time to perform a clean shutdown of the databases else face long recovery times when things...

Worst case scenairo, drop the indexes on the tables and run shrink database you should have quite some freespace after this. then go ahead and perform your backup and restore...

Worst case scenairo, drop the indexes on the tables and run shrink database you should have quite some freespace after this. then go ahead and perform your backup and restore...

Thanks ,will look into this and get back .

Agreed 🙂

So the question is , if sql server check points every minute or say even 5 minutes , why would the database still take a long time to recover...

I know the IT team in some companies I have worked in used Symantec Ghost with good resuts

http://www.symantec.com/business/ghost-solution-suite

A lot of DBA's i know started out as developers . Every once in a while there would also be an sysops guy.

Basically networks with DBA's in your company ,...

If your not using aggregate every column in the select list needs to be part of the group by statement else you will face an error similar to

Msg 8120,...

inserted and deleted are transition table created when executing a trigger

http://msdn.microsoft.com/en-us/library/ms191300.aspx

Actually writing it

Here's what i would do :-

Download the version of sql express i want to practice on

Download adventure works DB and install it

Create a hypothetical scenario based...