Viewing 15 posts - 1 through 15 (of 83 total)
I envision the role of an Auditor DBA, where they have rights on the Audit Objects and that's all. Regular DBA's are denied access to the Audit system. It's a...
August 21, 2014 at 5:28 pm
Steve, I'll take this one. I'm assuming you are referring to an on-premises install? If it is on-prem, it could be a multi part series.
May 22, 2014 at 10:17 am
The Mirror database is never accessible. Test this by attempting to connect with SSMS to the Mirror. I suspect the Native Client is redirecting your application on the fly.
September 13, 2011 at 7:50 am
You may be running into a limitation in the mini-shell. I seem to recall there are some limitations there. Try rewriting it and directly invoke Powershell.exe and change the job...
May 18, 2011 at 9:43 am
in a different subnet (DR site). The link to this site is 1GB.
When you say DR Site, does that mean across a WAN connection? If it is,...
May 17, 2011 at 6:45 am
I would expect that as a production DBA that is ultimately responsible for an organization's data, would have large amounts of self directed time ( > 50%) to manage and...
May 13, 2011 at 6:06 am
A couple of thoughts. Where is your witness ? Is it on the same subnet as the Principal and Mirror? Try reproducing the problem without the witness. Also, take...
May 13, 2011 at 6:00 am
Don't forget to exclude the MSSQL system directories and the target backup location also.
May 13, 2011 at 5:48 am
I would suggest that you use perfmon trace and do an IO analysis on your application's current IO pattern (what are the typical IOPS, transfer sizes) and then design from...
May 10, 2011 at 5:50 am
You only create 1 endpoint per SQL Server instance. Don't forget to configure the windows firewall also.
May 9, 2011 at 5:58 am
Yes, you can use mirroring on your platform. You are however, limited to synchronous mirroring AKA High Safety mirroring.
May 9, 2011 at 5:54 am
However after I enable the second NIC I only get this registering against Instance Name. Does this mean I have to now enable the SPN manually?
If you are running...
May 2, 2011 at 6:10 am
QADB1 QADB2 ...
April 20, 2011 at 8:02 am
For named instances, we use mount points and a small piece of disk as the root. Example of mounted disk labels/config: I1_Data, I1_Log, I1_Tempdb, I1_System , where I1 is the...
April 19, 2011 at 5:48 am
Good luck to you , and don't forget to label everything. Doesn't hurt to take some pictures too.
April 15, 2011 at 6:03 am