2015-06-12 05:36:39.59 spid293 Error: 17053, Severity: 16, State: 1.

2015-06-12 05:36:39.59 spid293 D:\Database\Log\gems_ews\gems_ews_log.ldf: Operating system error 112(failed to retrieve text for this error....

Hi - Thanks for replying so quickly. I have tried copying the MDF but a message is retuned to say the file is in use.

Regards

Dax

Hi - The DB is on a Multi SQL Estate so restarting would affect other DB's so haven't done this as yet. Is there another alternative to try?

Many thanks

Dax

Thanks very much for that, just looking for some reassurance.

Kind Regards

Dax

I take it it's safe to just restart without stopping the SQL Service?

Many thanks

Dax

Many thanks for all the comments/advice. I have restarted the Server & the TEMPDB is now down to a sensible size. I shall carry out some analysis to work out...

Hi - Many thanks for that, I shall have a read through the article. If I were to restart the Server would this reduce the size, or do you have...

Hi - I shall be running through this process tonight so just want to be absolutely clear so I don't break anything.

(1) Launch the Installer for SQL2008 R2

(2) I'm assuming...

That's great, thanks again

That's great, Many thanks. Are there any gotchas to look out for?

Hi - Many thanks for that, have just manually run the DBCC SQLPERF, see results below:

DB Name Log Size(MB) ...

Hi - Yes this is a production environment & I already had a discussion with the user base who are agreeable to DR options. Thanks for asking though!

Does anyone know...

Based on the information I've already provided, would you expect the log to cause an issue? Or would you recommend reducing the size. Apologies I'm still getting my head around...

Hi - Many thanks for the prompt reply. What I get any benefit from reducing the size of the trn log then?

Regards

Dax

Hi - Yes the package has been deployed to the Test MDSB database.

Regards

Dax