Viewing 15 posts - 6,286 through 6,300 (of 6,353 total)
database backups to local backup disk
backup file is copied to remote server and to NAS
backup disk and NAS copy are backed up to the virtual tape device
every 1/4 year one...
June 30, 2011 at 6:23 am
yeah the controls are secure, there are only two people who know where the passwords are, the place where they are is secured with no in or out access other...
June 30, 2011 at 4:58 am
yeah I have checked the connection managers, they are correct, all using windows authentication, all of the engine and agent acounts have SA access across the estate so no permission...
June 30, 2011 at 2:14 am
no, we use connection managers to define the source destination databases and yes the tables are the same on all three databases.
Just find it weird how it works running manually...
June 30, 2011 at 1:59 am
Glad I am not the only one questioning this, was pretty sure that filestream wasn't encrypted
June 29, 2011 at 12:51 am
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...
June 27, 2011 at 2:09 am
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...
June 24, 2011 at 9:04 am
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...
June 24, 2011 at 7:56 am
yes,, a database can be set to modes like RESTRICTED_USER (sysadmins) or SINGLE_USER, or you can even set the whole database to read only;
restricted_user doesn't just allow sysadmins, it also...
June 24, 2011 at 7:42 am
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...
June 24, 2011 at 6:30 am
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...
June 24, 2011 at 4:51 am
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...
June 24, 2011 at 3:52 am
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...
June 24, 2011 at 3:30 am
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...
June 24, 2011 at 3:01 am
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...
June 24, 2011 at 2:51 am
Viewing 15 posts - 6,286 through 6,300 (of 6,353 total)