ok... I rolled back sqlserve.exe to the previous version on the node and copied the sqlserve.exe from the node that was up reaplied the SP and everything came back up....

From Dells web site on SQL disaster recovery:

More sophisticated and expensive third-party backup tools provide enhanced functionality, such as full autoloader and tape library

support. However, Enterprise Manager in SQL...

are you using log encapsulation and openview?

You have to use something like Veritas or arcserve to control the tape library autoloader features. SQL doesn't have a way to rotate out tapes that I know of. I...

That will give me a base line. I've been out of the loop for a while they are relocating me 300 miles from home. I think I have the final...

I'll take some notes and write it up. I'm still working on the exchange bug and SQL 2000

So, basicly it stores all the data in an index almost like it was a seprate indexed table.

Look on microsofts sql site for the stress tool and load tool. Or, you can pick up the sql server 2000 resource kit.

Wes

cool. I guess I need to get off my ass and read the manuals and use it 🙂

I've got ERwin and have no clue how to use it. I though it just did schema layouts easyer for you.

actually, all but two of my servers are now sending mail. Microsoft has confermed a known bug with no solution. Apearatly, when sql tries to resolve a MAPI name it...

Sorry I should have given more info. This cluster is a nt4sp5 cluster with sql 7.0 on it. I know 7.0 wasn't as strict about smtp as 2000.

Wes

what OS version sql version and patch lvls for both? Also, you may want to run a DBCC to make sure there isn't any corrupt data. The last time I...

I concur that the OLAP solution is one good way. Indexes won't help you much with 17m records. I would also sugest pulling all totals you need on an enterval...

I would sugest a book on T-SQL, the guys here recommend one I personally use the O'Relly press T-SQL book and have for quite a while.

Wes