Viewing 15 posts - 376 through 390 (of 824 total)
ALL the cluster resources move? and does the DBCluster2 instance start? You should be able to see it in the Services applet.
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
August 3, 2005 at 1:50 pm
You got it. The most common source of confusion in clustering is that people tend to speak of Servers and Instances as the same thing. Even in a non clustered...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
August 3, 2005 at 1:16 pm
ServerA isn't unaware...Instance1 is. That's why it's important to maintain consistency in terminology. Instance1 will not see the drive that Instance2 uses, it can't or else the two instances would...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
August 3, 2005 at 12:17 pm
Profiler will give you the most complete and accurate data. However, running Profiler can have a rather large impact on performance.
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
August 3, 2005 at 12:00 pm
Define capacity planning. Do you mean space or performance or both?
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
August 3, 2005 at 11:57 am
More details would be helpful. However, the first thing to keep in mind is that when you run a DTS package (regardless of where the package is stored) it executes...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
August 3, 2005 at 11:55 am
First off lets get terminology consistent. You have ServerA and ServerB (physical servers) in a cluster, then you have two virtual servers (instances of SQL Server) that are independent of...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
August 3, 2005 at 11:43 am
SQL Server needs to have the disk resouce defined as a dependency in Cluster Admin before it can use it.
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
August 3, 2005 at 11:32 am
Phill,
If the maintenance plans fit your needs, using them doesn't necessarily mean that you are in full "wizard" mode. Yes there are some things that the maint plans won't...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
August 3, 2005 at 11:29 am
I can't speak for ramses2nd but I think it's kind of funny that so many people seem to spend so much time reinventing the wheel unnecessarily. I have interviewed several...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
August 3, 2005 at 8:31 am
Funny thing that Rudy should mention backups, because it is really only in the backup history that you can track changes to the size of your databases, that is unless...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
August 2, 2005 at 12:40 pm
CREATE PROC dupQuote (@oldQuoteID int
, @NewQuoteID int)
AS
INSERT INTO test (QuoteID, Sector, Country)
SELECT @NewQuoteID, Sector, Country
FROM test
WHERE QuoteID = @OldQuoteID
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
August 2, 2005 at 12:20 pm
About the only reason I've ever had to not use the maintenance plans is if you want to use differential backups.
I suppose that if the current method provides a...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
August 2, 2005 at 8:46 am
No, SQL Server doesn't delete rows for any reason. Whenever I want to set up an audit trail like you mentioned, I use triggers rather than relying on the application...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
August 2, 2005 at 8:40 am
If you are simply wanting to move the files to a new "drive" but have it on the same instance of SQL Server it will certainly require some downtime regardless...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
August 2, 2005 at 8:33 am
Viewing 15 posts - 376 through 390 (of 824 total)