It's the syscolumns view in the master database. syscolumns used to be a table in SQL 2000 it's now a view and it's one of the meta-data views. There's a...

A workaround?

Indexing is the key to good performance. No indexes,...

It's probably the checkpoint process. As I said, don't worry about it. The system processes have all sorts of wait types in 2005 and above and they're supposed to have...

Glad to hear that.

Microsoft gives an immense amount of software away for free.

Just a couple of examples: the express versions of SQL Server and Visual Studio and all the Windows Live apps, Virtual...

That said...

Check with whoever's responsible for the backups and ask whether or not there are any differential backups been run. If there are, to avoid messing up the recovery chain,...

edtraviles (12/29/2009)

---

I presume removing the existing backup destination in this dialog won't affect anything except the one-off backup I want to run, i.e. the removed destination will still be valid...

I am out of ideas.

Nothing needed on a cluster other than remote DAC. I have done it before, no problems at all.

Way out idea. Does the cluster have a...

No. If...

Hit your favourite search engine and search for clustering best practices on technet.microsoft.com. There are pages and pages (and I mean that quite literally) on it.

GSquared (12/29/2009)

---

For anyone here a month or so ago, I have good news on the employment front. Starting a new job with a much better company in mid-Jan. ...

You're 100% sure that remote DAC is enabled?

EXEC sp_configure 'remote admin connections'

So that means that restart-recovery is in process. Give it time and the DB will either come online or it will go suspect.

Error log?

Willian Funes (12/29/2009)

---

the log file show me a message "SQL server has encountered 1 occurrence(s) of cachestore flush for the bounds trees cachestore (part of plan cache) due to some...

Yes, it will work. sys.databases is in master. The reason for asking you to query...