i get this error when there is a job running on a linked server:

Named Pipes Provider: Could not open a connection to SQL Server

the job could not connect to...

Robert,

If this is not a bug, why would Microsoft not charge us for the support they had provided us during this outage. And the cummulative fix actually helped with the...

We were finally able to bring back the database back up. There is apparently a bug in sql server, which takes a long time for the database to come back...

Did the restore complete? If it did how long did it take. I am in a similar kinda of situation. The restore says 100% processed but it is still in...

nope that didnt help either. Thanks for your suggestion.

Yeah that sounds about right if the backup file name does not change. In my case the file name changes with a data parameter in it. So any ideas on...

Thank you so much for replying.

But I am looking for a script to restore databases regardless of whether they are red gate backups or regular backups. Something which is done...

Thanks David. That article was really helpful. Hopefully the db is back in action by 6 hours. Cant wait for this day to be over.

The current completion value is at 41% after 5 hours. So i am assuming it should be done in less than 61/2 hours. I hopefully dont fall into the other...

The sql server is a standard 64 bit edition. We have about 21G left of the drive now. The error log specifies that it is about 32 % complete....

thanks for your replies. It currently is telling me that it has 10 hours to recover. But I am not sure if we could wait untill then. Could it...

Did you find an answer to this question? I am facing the same issue. I do not want to convert it to varbinary. I would like to use varchar instead....