Glad I am not the only one questioning this, was pretty sure that filestream wasn't encrypted

Just Dynamics 2009 but been working with it now for over a year, only recently got more and more into the tuning as it has only just taken off throughout...

While I agree with Oliiii using SQLIO is a good way to get a baseline, I doubt you will want to do that at this moment in time as it...

We gave Idera DM and Quest Spotlight a go side by side and went with Quest, to get a good comparision, I would try as many as you can before...

restricted_user doesn't just allow sysadmins, it also...

Unfortunately no, each SAN is different, my background with SAN's as a DBA is with an EMC CX4-960 which has its own monitoring tools built in, to where you go...

You need to be doing this at the SAN level if the SAN controllers are maxed, that way it should be able to tell you which RAID groups and LUN's...

I cannot tell you how to setup your backups, that varies between companies as they will all have a slightly different requirements but your backups full/diff should be done as...

We have an RTP of 15 minutes with an RTO of 2 hours, for this we use logshipping but we use the no recovery setting as we do not report...

As mentioned on my first post all three can provide DR but they are all different, it all depends what you need from a DR POV. You are best...

You will find that most of Dynamic's is written in cursors, we have the exact same issue here. Was talking about this yesterday on a different thread.

You need to...

Yep exactly what I thought, its because you dont have the "disconnect users................" setting checked, which I detailed in my first post and the one above.

What are your intentions for...

Thanks, one thing I would say is enable the "disconnect users.............." check box if you are going into standby mode as this way it will not fail any restores and...

can you detail the setup, backup/copy/restore/restore delay frequencies as well as the paths both local and UNC, or even better screen shots of the log shipping configuration.

it would seem that...

Yeah its nasty, from what I have heard about the whole Dynamics range, is that it was purchased off a company that was developing the suite for Oracle, obivously Oracle...