The error message you're getting is saying that the backup was done to "too many devices". That usually means too many backup files.

Try running a separate full backup, to...

Alternately, you can do a standard string parse and process a whole table of names all at once.

SUBSTRING(@String_in+@Delimiter_in, number,

CHARINDEX(@Delimiter_in, @String_in+@Delimiter_in, number) - number) as Parsed,

row_number() over (order by number)...

Can't you simplify the whole thing by using a select with a join between the two tables?

I just did a test on a 1-million row table with 7 columns of random data (Jeff's usual test table).

Without an index on the column I had in the Where...

Truth be told, I'm going by something I read a while back, and haven't tested it myself....

So ... give me a few minutes here. 🙂

The only thing I can think of is relatively complex upserts from each server to each other server. There might be a product somewhere out there that can synchronize...

That might get you a picture of the server room, maybe even the server, but to...

If it's a complex database, you might want to look into something RedGate's SQL Doc, or ApexSQL's Doc. Those are products that will look at the data and metadata...

Select count(0) doesn't have to get any column metadata. Select count(*) does have to gather column names. It's a very minor difference and won't matter in almost any...

Add "Group By Main.CONTACT_WID" at the bottom (after "from Main").

In that case, I'd let Microsoft know that it might be a bug in Mangement Studio. Sounds like it to me, anyway.

I just noticed that almost your whole Where clause is predicated on that last "or". I think I was misreading that before. Are you certain that the last...

What code are you using for the backup and the restore?

jim.powers (6/20/2008)

---

GSquared (6/20/2008)

---

It would be easy enough to set up a proc that did something like "select 1 from database.dbo.table" for each database on your server. Have it send...

I must be missing something. The first thing you do in the proc is null the input parameters. Doesn't that kind of defeat the whole purpose of input...