Viewing 15 posts - 1,186 through 1,200 (of 4,272 total)
Question Guy (7/14/2011)
July 14, 2011 at 12:06 pm
The SQL setup program has an option to add a node to an instance. If Instance 2 has not already been configured for failover to node 1 then you...
July 14, 2011 at 10:46 am
Hm, I would recommend looking at:
How to configure volume mount points on a Microsoft Cluster Server: http://support.microsoft.com/kb/280297
CEWII
July 13, 2011 at 3:01 pm
Lebanese (7/13/2011)
peer-to-peer replication is not typically used in cluster configurations because the database files are on shared storage and onyl one server may be in control of the...
July 13, 2011 at 2:55 pm
Lebanese (7/13/2011)
really thankfull for your information.
just have a question, why you don't like peer-to-peer in this configuration?
i already have sql enterprise and it can be setup in a breeze.
thanks...
July 13, 2011 at 2:46 pm
I was unaware of a difference in behavior. However I would expect an offline database to stay offline till I said different. However, if you are seeing other...
July 13, 2011 at 2:38 pm
I think Brent's article is probably just as true today as it was in '09. While the hypervisors and other VM technologies get better the one constant which cannot...
July 13, 2011 at 1:54 pm
Whats in the errorlog? databases going on or offline are recorded there..
CEWII
July 13, 2011 at 1:48 pm
I also found this related to cross-subnet clusters:
http://msmvps.com/blogs/jtoner/archive/2008/08/08/multiple-subnets-with-windows-2008-clusters.aspx
CEWII
July 13, 2011 at 1:45 pm
You are most of the way there.
Let me restate your requirement and then then configs that can handle that.
You have databases that you need to have high availability on. ...
July 13, 2011 at 1:17 pm
Phil Parkin (7/13/2011)
Elliott Whitlow (7/13/2011)
If I remember correctly SQL 2005 SSIS won't let you step through the script. I seem to remember using MSGBOX a lot..CEWII
You do not remember...
July 13, 2011 at 10:36 am
If I remember correctly SQL 2005 SSIS won't let you step through the script. I seem to remember using MSGBOX a lot..
CEWII
July 13, 2011 at 9:33 am
Lebanese (7/13/2011)
If sql1 is down, all the requests...
July 13, 2011 at 8:33 am
Sounds great, I have been working slowly at that for the better part of 8 months. I think people would love to have a set of policies that they...
July 13, 2011 at 8:19 am
Probably not.. TDE protects data-at-rest, while the database is attached to a SQL Server and the server is running ANYONE with sufficient rights can read the data.
As I remember...
July 12, 2011 at 4:07 pm
Viewing 15 posts - 1,186 through 1,200 (of 4,272 total)