Thank you Beatrix & Northern Soul for your replies, much appreciated.

Kind Regards

Dax

Thank you for your reply - I have already advised that I will not undertake this task until it has been installed successfully on a non-production environment, as I'm fully...

Hi Thom - Many thanks for your reply, please see below:

select @@LANGUAGE returns us_english

select default_language_name
from

That's great, many thanks for your reply

I have checked the recommended Security update. I've looked at the System Requirements & the supported Operating Systems listed doesn't contain Windows Server 2008 which we're running. I take...

Many thanks for the workaound information regarding Report Builder. I'm currently running Service Pack 1. Do I need to install SP2 before Installing SP3, or can I go straight to...

Thanks everyone for your advice. I've heard the Resources DB mentioned before, does this list configuration details & how can this be backed up as it isn't listed in the...

Thanks very much for that. Are there any issues installing this Service Pack or is it just a simple case of backup everything & run the exe?

Is it easy enough...

Hi - Many thanks for coming back to me. I have now received some additional information:

What my colleague is actually looking to do is to asign a DB to use...

That's great, many thanks for the quick reply, it's appreciated!

Hi - Many thanks for that, I'm going to be travelling down to Cambridge soon so will e-mail the key user to see what is acceptable & will come back...

Hi - It's my understanding that this DB isn't live yet so is in Development. I can restore back to yesterday morning at 08:00 which I'm sure will be sufficient.

As...

2015-06-11 23:45:47.74 spid120 Error: 18204, Severity: 16, State: 1.

2015-06-11 23:45:47.74 spid120 BackupDiskFile::CreateMedia: Backup device 'E:\\gems_ews\gems_ews_backup_2015_06_11_234515_4578504.bak' failed to create. Operating system error 3(failed...

Will do, in a meeting now until around 16:00 so will be back. Thank you both for all your help.

Hi - Thanks so much for all your help with this. I have run the following SQL:

Query1

SELECT log_reuse_wait_desc

FROM sys.databases

WHERE name = 'gems_ews';

Returned value: 1 LOG_BACKUP

Query2

SELECT Name, state_desc

FROM sys.databases;

Returned value:...