I think Shew01's question still remains unanswered.

Has anybody out there scripted all of the Linked Server definitions on a server? If so could you share your results either in...

very good, thank you.

John Zacharkan

Have you seen this example out of BOL - if you're not using devices - exchange it for disk = 'd:\adjhasdakj.trn'

Restoring a database, differential database, and transaction log backup

This...

This should have been posted under administration. You're in the developer land here.

John Zacharkan

I don't think your database is corrupt what was the last restore statement that you used.

John Zacharkan

Here's a sample of something I did-not pretty but it works

From QA on the source server Copy and paste the code that follows

Edit accordingly to point at...

Don't remember having to use the undo file before, but that seems to be it.

I'm definitely losing it!

btw - i did read bol - just decided to...

Thanks guys,

I have to work on the connections, there does seem to be a relation to high CPU activity and high number of logins/sec. It's a web app...

Question one is impossible to tell, How big is the backup and how big are the transactions, how fast is the server, where are the backups stored, yak yak yak...

Having implemented a number of DR and fault tolerant solutions I sure would like to hear the arguments which led to you to believe that "clustering was far more...