Am I missing something here? That link describes itself as how to manually remove SQL but then goes on to describe how to do it via control panel which is...

oops, sorry, that'll teach me to jump to conclusions.

Brandie Tarvin (5/22/2012)

Then obviously you are misusing DBCC Timewarp(). You are hereby forbidden to...

whats the recovery mode of the database?

For mirroring it needs to be in full recovery mode, for log shipping bulk or full recovery, else the features (not futures :-)) wont...

the real answer to this is probably 'it depends' but I would expect a huge .ldf is more likely to have a greater adverse affect on restore times.

Restore time would...

Is uninstall\reinstall of the OS an option for you?

thanks for the prompt response Gail.

Can I impose and ask from your experience if there is a likeliest root cause when the two processes involved are both dynamic SQL...

morning gail, thanks. the database has been reindexed since the deadlock trace captured the information so I wonder if the page is still used by the same object, but anyway...

no relevant differences in security between SQL2005 and SLQ2008 in this context.

the error says it cannot find that object, so either it does not exist, you are not connected to...

does the object exist on both servers? Is the owner of the object the same on both servers?

it does suggest the archive user has become orphaned, that is it is no longer associated with a login as there is not a matching sid. therefore it would not...

OK. You will probably find there are teething problems hitting 'permission denied' type errors but you can just work through them.

the second error is an out of space on the disk issue (run net helpmsg errorno from the command line to see what OS error codes mean)

mirroring requires both partners to be the same version of SQL so this will not work.

Whats the size of the database? I presume you want to do this to reduce...

'Unfortunately' purely in the sense that for this problem, what would at first might seem the obvious and most secure option of setting up a windows group and placing the...