In general, a database should be in full backup mode for precisely the reasons described here. There are advantages to using the Simple backup model.

The prime one...

Lynn Pettis (9/15/2009)

---

I have to make two observations about this article. As of just checking the main page, there have been 7,992 views recorded for this article. Compare...

Lynn Pettis (9/15/2009)

---

It is possible that the t-log backup files could over run the available disk space as well. That is another pain point in this process, but it...

Great article, Lynn.

One area that you mentioned, but that I think can be elaborated on, is the number of log backups this can generate. If the space is available,...

bhavster27, the article discusses the number of questions and time. I would not worry about that though. In every Microsoft exam I have ever sat for, I have...

Paul White, you made some excellent clarifications. Thank you for expanding on what I was trying to say.

Hello, Pete. Glad its helping you out.

A well written article, but it does say

. Which is not true.

I did a...

Elliot is right, but also note that if you run the account from a member of the administrators group it will execute the command with the privileges of the SQL...

Matt has a point. You don't need the outer where clause at all. Also, when you alias a table in the from clause, you can use that alias...

bhavster27, I am going to echo Mike here.

I have never known a certification to get someone a job, but it can definitely help in getting the interview. ...

Yes, for sp_who2 to be useful you need to run it during the trouble. If that is not possible/impractical then consider either the server side trace or profiler. ...

Was this captured during one of the slow periods? It shows very little running and does not seem to have any particularly long running queries at all (of course...

Gsquared is right.

I would be very surprised if you used up all values for bigint. If you needed to reset the identity column anyway for some reason,...

Raj has a very good suggestion.

If you know when it is actually happening you can look at sp_who2 or else the Activity Monitor if you prefer a gui....