Viewing 15 posts - 2,896 through 2,910 (of 6,679 total)
This is how I would move to a new cluster:
1) Build New Cluster instance as PR002
2) Migrate logins, ssis packages, agent jobs (script out of PR001 - execute into PR002).
3)...
February 17, 2012 at 11:43 am
It makes sense to test as you have outlined.
I am thinking that you won't find much in the way of usage of the transaction log. Altering a column from...
February 17, 2012 at 11:26 am
The Cleanup History Task removes history for several areas. It will only work for the job history if you disable the default setting on the History page for SQL...
February 14, 2012 at 12:22 pm
A database file will only grow when all the space in the file has been used - and the autogrowth setting is defined. That setting should be defined to...
February 14, 2012 at 12:15 pm
I would go with backup/restore for the user databases and not worry about the system databases. Build the systems at the new site, script out all jobs and logins...
January 31, 2012 at 12:51 pm
plaid_draco (1/31/2012)
Thank you for the quick responses! Very helpful.I guess my assumption that an active-active cluster would avoid that problem is unfounded. 😀
Well, there are a couple...
January 31, 2012 at 12:42 pm
The version you are on had issues with maintenance plans and there were also issues with xp_delete_file.
You really need to upgrade to SP3 - and if that is not possible,...
January 26, 2012 at 11:57 am
Another thing you need to realize is that when you rebuild/reorganize an index - SQL Server will spread the data across both files according to the proportional fill algorithm.
After the...
January 26, 2012 at 11:53 am
Does this table contain any (n)varchar(max) columns or xml columns?
January 18, 2012 at 3:59 pm
It really depends on where you are backing up to - and whether or not everything is on the same fabric, SAN, disks, etc...
It also depends on how much cache...
January 15, 2012 at 7:57 am
BTW - inserting data using an ORDER BY clause will not guarantee that the data is inserted with no fragmentation. Even if you have an IDENTITY column as the...
January 5, 2012 at 1:43 pm
Define what you mean by one disk - is that a single LUN presented from a SAN? If so, how is that LUN setup on the SAN?
What you can...
January 4, 2012 at 3:18 pm
You cannot use UNC paths with SQL Server.
I would recommend downloading the trial version of Redgate's SQL Virtual Restore. After reviewing the functionality, you can then determine whether or...
January 4, 2012 at 3:00 pm
Perry Whittle (1/4/2012)
January 4, 2012 at 2:53 pm
Having just installed the latest version on several clusters - I can say that you have the option. I chose to run the installation on each node since trying...
December 23, 2011 at 7:59 am
Viewing 15 posts - 2,896 through 2,910 (of 6,679 total)