Viewing 15 posts - 721 through 735 (of 757 total)
Vishal.Gajjar (10/20/2011)
SP1 is the latest service pack for SQL Server 2008 R2.SP2 is released for SQL Server 2008 (not R2).
SP3 Has been released for 2008...
October 20, 2011 at 8:19 am
SQLRNNR (10/17/2011)
Which scripts have you tried to use thus far? Have you looked through the scripts section here on this site?
There are a few useful scripts on this site...
October 19, 2011 at 4:34 am
You could probably set up a trigger that logs events into a table.
With SQL auditing, you can query the audit file that it creates and pull that results into a...
October 19, 2011 at 4:02 am
You need to regurlarly assess the fragmentation and Reorganize or Rebuild the indexes
I would also recommend updating the statistics, rebuild indexes does update the statistics but only on the indexed...
October 18, 2011 at 4:33 am
Is it not deleting the bak files?
I had a similar problem
In the maintenance plan for folder, I put a \ after the path and I removed the . from the...
October 18, 2011 at 4:26 am
Hi Perry
Is this process in any way different when you have an existing 2 node cluster and adding a 3rd node?
Thanks
Derek
October 18, 2011 at 3:13 am
Hi Perry
From what I understand - The storage needs to be presented to the new node prior to doing anything else?
Am I correct in this?
Thanks
Derek
October 18, 2011 at 12:21 am
Is this the maintenance plan "Cleanup History"??
October 17, 2011 at 8:59 am
Backup and Restore your system DB's as well
October 14, 2011 at 5:12 am
Sounds good
Make sure that you have the same drive structure on the new machine as the old one.
October 14, 2011 at 4:55 am
Viewing 15 posts - 721 through 735 (of 757 total)