You already have the proper way. You can validate to make sure you have all the indexes in place to make sure this runs as fast as possible.

Other than...

Syed Jahanzaib Bin hassan (4/21/2011)

---

I think I guess you are taking log backup with tail option,if this option check then database is come to restoring state,check this option also

Regards,

Syed Jahanzaib...

Just a hint, but we have a san here and restoring a 2.8 GB would be counted in seconds, not minutes / hours.

So that would be 1 of the first...

alan.fisher (4/21/2011)

---

My sp code is irrelevant, it doesn't matter which sp I run, the same thing happens.

I am new to this forum, is there a way to mark this...

Here's an option I had never heard of. I used to do this manually but this is much better :

There's a way to both take the tail t-log...

Hey Grant, when turning autostats on, would you also redo a full update stats of the system?

steveb. (4/21/2011)

---

winston Smith (4/21/2011)

---

I have been offered a position of working with a small SQL focused consulting agency .

The owner is gifted, has worked on systems in my current...

I've worked once for a mom and pop shop and it was great. Only 40 hours week. As much overtime as I wanted to put hours in a...

The only way that can happen is with a restore command.

Unless like grant said you just found the mother of all bugs in SQL Server.

Can you post the script you are using to do the log backup?

You're getting this backwards.

Step 1 : define clearly in your mind what you want, what is negociable and what is NOT.

Then find jobs that match that.

Looks to me like...

Nothing blunt in there... just solid experience. I don't see...

Might be faster to just uninstall and redo the setup...

Well then the...

That's what I...