Actually, you were quite clear. There was apparently no error messages that you could provide. The backups are run sequentially and one can't run until the other has...

Perhaps I was unclear.

There is 1 database in question.

Command 1 spid 313 = Backup database x with file = y to disk = \etwork\z

this hung, was killed and entered...

That is what it says... can't run a db backup while one is already running!

For what it is worth a cluster failover was initiated during our activity trough and completed swiftly. The zombie connection cleaned up effectively instantly and hopefully everything is now...

Cant run a backup as they are serialisable, and we have to wait for the last one to complete...

No error message, afaik the client hasn't returned an error yet.

How about just using sysindexes or its modern equivalent? Sure it might be a bit dated, but broadly close enough.

That way you don't have to load your server runnning...

Robert Mahon-475361 (10/25/2010)

---

Read;

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=6136&whichpage=2

All of quazibubble's posts,...

Helpful indeed.

However, wouldn't it be even more helpful if there was an equivalent of sp_helptext for indexes and tables...

Hi

Just a suggestion - but when you are doing your workday bit - you should really ensure you get the right setting for datefirst into the script, otherwise you might...

Its fine on something small, but absolutely appalling performance wise on bigger tables. GHY if you have a set of joins on big tables and you try to use...

Might sound like it, but only to someone who doesn't understand the language...

Thomas-282729 (6/8/2010)

---

Again, what you are suggesting is a poorly written query where the developer uses the wrong alias (A.Id instead of B.Id). How does that improve clarity in the scenario...

Stefan Krzywicki (6/8/2010)

---

Why stop at the primary key column? Because ID is likely the only column that's going to be in every table. You're very unlikely to have lots of...

Excellent article, thanks for sharing. I look forward to the next installment!

If such a facility existed I would suggest it be pinned, and enshrined in the hall of fame.

However,...