Hi all, thanks for the replies!

Fragmentation and statistics are good.

The min memory setting is 0 on both, the max is 112G on 1 and 118G on 2.

They are looking into...

Thanks for all the input!

I have one other question... Is mirroring an effective solution to implement a standby database in case of corruption?

If corruption occurred in my primary, would...

I do see in the sql log that when the snapshot backups are taken that the database IO is frozen, backup is taken & IO is resumed. So I...

The server rebooted itself because of windows updates. Networking guys said this was a clean shutdown + supposed to happen.

We do sql database snapshot backups through a third party...

Here was the initial error in the log on 6/13 at 6:20am:

Starting up database 'XXXXX'.

Error: 5173, Severity: 16, State: 1.

One or more files do not match the primary file of...

That is what I originally wanted but the source database is the backend for third party software, so their key.

I asked them for the information (create symmetric key...

Thank you! Solved my problem.

Tom,

I am a developer in the same situation. I used a third party tool that was called "ignite", solarwinds owns it now. They have a free...

Yes, I read...

Bear in mind, the server you restore to should be exactly the same (version, sp possibly even cu, but I'd not swear to that one) as your old one otherwise...

I am thinking worst case scenario & want to be prepared & have a plan for all avenues....

Thanks for the reply John, but question....

I understand what you are saying about the consistancy issue being possible... but say I had a corrupt master occur on a...

Thank you very much, looking at the link you supplied now.

I do have another question though 🙂 our networking team do the backups using a third party...

Hi,

thank you for the response. This is what I tried before, however I did try it again but still the reports are not visible in safari.

I am running...

This is VMWare ESX version 4.1 I believe. I asked once if the sql had fixed resources so

i'm going to assume the disks are all virtual disk files. ...