I believe the question was meant to discover whether your instance was started in Single user mode, also known as maintenance mode. Startup parameter: -m

I know it's already been covered, but just to put in cleartext:

The reason why you need to be careful about which indexes to add is that adding indexes can actually...

Suspended is not necessarily bad, it simply mens we're waiting for some resource, which practically all queries will at some point and for some time.

The questions we need to...

Yep. Your server's backup history will only show backups that were actually made on this server.

However, the server also keeps track of your restore history.

So, if you need to know...

A differential backup is a backup of all pages changed since the last full backup, so there MUST be a preceding full backup somewhere. However, there is no requirement for...

Are you sure the one server isn't just busier than the other and that's the reason why things take longer?

Actually, if we're talking about full-text search catalogs and that's what is not refreshing, than yes, I'd say that's probably it and I'm probably the one who was off. ...

alanspeckman (10/23/2012)

---

I have always referred to SQL 2008 R1 and the RTM version of 2008 and the 2nd major revision of SQL 2008 as R2, according to what I have...

You should start by going back to whoever wrote this and have them provide whatever additional details they may have regarding the alleged "2 instances of the database". To me...

Sure, no problem. They are seperate files that can be grown (or shrunk) separately.

Well, at least you're cleaning up your own mess and learning from it. 🙂

Trust me, we've all had to do that a few times along the way.

Most likely you've come across a piece of bad application code that doesn't clean up after itself.

All temporary objects created in tempdb must be dropped when you're done with them.

You...

Also, you do need to be sure if changing recovery model of all databases to simple is really an OK thing to do.

This change has a significant impact on recoverability.

In my opinion, this whole having to "Run as administrator" thing is actually one of the worst ideas to be adopted by Microsoft in many years. While I can see...

Hmmm, we'd really need more info about your server and the actual job steps to say anything or certain, but one thought that strikes me is perhaps you're actually doing...