Dev (12/6/2011)

Perry Whittle (12/6/2011)

Log shipping...

first of all, make sure the growth factor on the log file is not set to something which is going to gobble up all your disk space (ie the default...

are you able to back the log up to free some space within the log?

Once you have some space if removedbreplicaton does not do it try the trick advised by...

SQL thinks you have 🙂

try running sp_removedbreplication against the database

was this database originally restored from somewhere else?

try running sp_removedbreplication against the database

I would try changing the select to:

select name from master.sys.databases where name not in ('tempdb')

its listed right at the start of the errorlog after a sql restart (not just a errorlog cycle)

sorry, I've tried the script and it returns those two permissions for me. Have those rights been granted to anyone in your setup?

yes, I had a distant memory that was possible, so I tried it before replying to the OP, and oddly I got exactly the same error as the OP, so...

what have you tried?

googling 'script server level permissions' returns quite a few options.

this looks quite good

you would have to start again from a full backup restore.

But there is no reason why the chain should become broken in this scenario as long as all your...

I would aim to just disable the copy and restore jobs on the DR server.

This is because it is best to keep backing up the logs on the primary for...

you cannot connect to SQL2008 from SQL2000 tools. You need at least SQL2008 client tools

Thanks for sharing Warren. If this is to be used on SQL2005 and above you really need to be switching to 'create user' syntax rather than sp_grantdbaccess, else the user...

glad to hear thats working again.

you say you copied ALL the diffs? Only the latest one would have been needed to be restored.

Presume you enabled the copy job as well?...