Hi Vegard Hagen,

Great. It's much clearer now.

Thanks a lot for your explainations.

Have a nice day 🙂

- Peter

...

Hi All,

Thanks for your responses.

Please see my comments below.

select * from msdb.dbo.backupset where database_name='MOR'

-> Returns: 76 rows

select distinct database_name from backupset

-> Msg 208, Level 16, State 1, Line 1

-> Invalid...

Hi Grasshopper,

Thanks for your response and advise.

I've tried to execute the script on my actual server where the backup is taken, but there is still no output.

Anything that I've missed...

Hi,

Thanks for your help on the SQL query.

I've executed the query on my DR server where I've restored the DB, but there is no output.

The message is only showing:

Command(s) completed...

Hi,

Thanks for your response.

We're using Microsoft SQL Server Management Studio (SQL Server 2008 R2) to perform the restore.

Is there a way to check what are the required transaction files...

Hi All,

I'm gettting this error from Suba' script.

Errors:

Msg 208, Level 16, State 1, Line 11

Invalid object name 'Information_Schema.Tables'.

Please advise.

Thanks.