I have a maintenace plan settup to take transaction log backups every 15 minutes. Well everytime it does so, it writes a message to the windows event log. How can I disable this? I looked through the maintenance plan configuration and the Agent Job it created and can't see how to change it.
SQL Server 2008 Enterprise
I have inherited a SQL database that has been configured to use two transaction log files. I'd like to just get rid of one of the log files, because it's really not best practice and just creates additional maintenance requirements. I have pulled a full backup and restored to a test server, and have attempted to just remove the 2nd log file using SSMS.
The "Remove" appeared to work, but when I went back into the database later the 2nd file had reappeared (at 1 MB in size). At this point, I was not able to remove it again at all, recieved an error from SSMS tool.
Cisco Catalyst 2960S Switch
Intel Dual Port NIC (teamed)
BroadComm Quad Port NIC (teamed 2 ports)
We hired a contractor to setup a fairly simple SQL cluster and SAN storage. With the above switch and NICs, they have teamed two cards on each server (3 servers total) for the domain network communication. There is no problem with the NIC teams, they are functioning fine, I have tested failover of each (unplug one of the cords).
The question I have is, would I gain any benefit from also creating an EtherChannel in my switch for each of these NIC teams? The contractor has not done this, and although everything is working fine, I want to get the top performance and reliability of this buildout.
Windows Server 2008 R2 (clustered active/passive) - SQL Server 2008 Enterprise - Dell MD3200i PowerVault SAN
8 x 450GB 15k SAS drives (RAID 10)
What is the best stripe unit size for this configuration (for optimum SQL performance)?
I am reading conflicting reports of 64k, 128k or 256k.
Please help! Thank you!