Ahh yes, i see on SVR#2 the "LSRestore_SVR#1_DBName

I have looked in the Job History of this, and you can pin-point the LOG files that HAVE been restoring into the Db...

ok i think you have cleared up allot.

Can you confirm my thoughts then.

- SVR#1 running happily, shipping logs to SVR#2 (Folder contains about 24hours worth of logs) and on SVR#2...

I worked out that using

RESTORE DATABASE <my DB name> WITH RECOVERY

and refreshing the console, puts it into normal mode.

I then was able to run queries on it.

Im just a...

Strange thing is, this started working again by itself later in the night.

Very odd, and it looks like it might have been a problem a month ago for a while.

Odd...