Viewing 15 posts - 31 through 45 (of 83 total)
In order to query groups, I think you will need to 1) Write .net code in the CLR to query AD using ADSI or 2) use the command line query...
April 9, 2011 at 8:03 am
Use Windows Perfmon.
CPU -% Processor Time - _Total
Process - %Processer Time - SQLServr
MSSQLSERVER - Buffer Manager - Page Life expectency
MSSQLSERVER - Buffer Manager - Buffer cache hit ratio
There are others...
April 8, 2011 at 6:06 am
You can also of course SAN replicate the drive storing your actual database backups.
We are doing this - we backup to a cifs share , then that is replicated...
April 8, 2011 at 5:51 am
Don't forget to configure your Windows firewall to open the port you just changed it to.
April 8, 2011 at 5:40 am
Ditto on everything Gail writes. In addition to backups, you actually need to test your ability to restore those databases. I randomly pick a server and them randomly pick...
April 6, 2011 at 6:25 am
I am currently working on getting an ODBC connection to this database however I have never set up an ODBC connection before and don't know exactly what that will allow...
April 5, 2011 at 6:12 am
Take a look at the "Central Management Server" feature on SSMS 2008 and newer. It allows you to run a query on multiple servers at the same time (properly configured...
April 5, 2011 at 5:52 am
For our reporting database, we use log shipping with the standby option and only restore logs at night. It works real well.
April 5, 2011 at 5:43 am
I suspect that your SQL Agent service account does not have enough permissions on the 8 servers where you get no data. Try actually logging on to the server as...
April 4, 2011 at 6:47 am
Cluster network name resource 'SQL Network Name (Rt4UASRVSQLCLU1)' failed to create its associated computer object in domain 'ambulance.wales.nhs.uk' for the following reason: Computer account is disabled and couldn't be re-enabled.
The...
April 4, 2011 at 6:39 am
DB Mirroring operates realtime / near realtime to send all transactions from the principal to the mirror. As long as you do not have a send queue (Unsent Log) showing...
April 4, 2011 at 6:21 am
You could also try out Log Shipping as a DR solution. But, since you stated the databases are in Simple recovery model, you would need to change that to Full....
March 31, 2011 at 6:18 am
You will need to put the mirror server name in on the DB connection wizard (3rd screen, I think). Also, your application needs to have built in reconnect logic and...
March 30, 2011 at 6:14 am
If you are looking to buy a tool, there are several offerings from vendors that specialize in SQL tools: Red-Gate, SQL Sentry, Idera, Quest etc. Many of the features...
March 29, 2011 at 6:05 am
Viewing 15 posts - 31 through 45 (of 83 total)