I can't find anything like that at all; the menu structure looks very strange. I think I might have to get the contractor for the application in question to have...

Thanks for the help!

Ok, it's called [Application name] 5.5 Server - [Application name], and under log on as it has .\[a username related to application name]

sqlcmd -E returns:

"Named...

Thanks for the reply. There are no newer instances. The service is running, although it took a while to find because it was given a very unusual name for some...

I probably explained myself badly above, sorry; the SIDS did match, that's why I was going round in circles. Thanks though.

Thanks all.

I did sp_changedbowner after the recovery. I sorted out all the SIDS by running EXEC sp_change_users_login [etc.]. Oh, and the databases were on the same instance before as well...

If possible check these settings against the original instance/databases:

- login/user permissions in both databases and on instance level : as far as I'm aware this is identical. I've compared everything...

Weirdly it's not a remote connection, but I can see why you're asking. Thanks though. It seems to be puzzling people all over the internet because I haven't found an...

Do you mean the command prompt? Sorry if I've misunderstood the question.

Thank you. I think the stress is getting to me; this stuff is basic. If I could delete this thread I would!

Hang on, it will automatically upgrade the database for me if I restore it to a higher version, won't it? I just need to change the compatibility level?

Ok, I've got it working now, but in case anybody else has this problem in the future I thought I'd let you know that although SQL Server Agent appeared to...

Hi

The job is enabled and scheduled (and it is running successfully); I've also been running it manually.

Hi all. Thanks for the advice. I definitely don't want to be unnecessarily obstructive, so I'll try to get the vendor to define their terms a bit more.

I don't mean this rudely but the text of the error message gives you quite a lot to be going on with, there. Are there any long-running transactions that might...

Cool, thanks. I've amended it to.

and LEN(CURRENT_POINT) > 0

🙂