Viewing 15 posts - 7,126 through 7,140 (of 9,253 total)
melissa.dougherty (5/18/2011)
ALTER DATABASE SharePointDB
SET WITNESS = 'TCP://MirrorDB/SQLServerWitness:5033';
GO
I get the following error...
Msg 1449, Level 16, State 5, Line 1
ALTER DATABASE command failed due to...
May 18, 2011 at 9:54 am
coronaride
when using log shipping, all modifications to the secondary database must be applied first to the primary, including indexes, adding users, etc.
Replication would probably be a better option but this...
May 18, 2011 at 9:42 am
Barry
are you able to check the SQL Server logs on the instance you are trying to backup the databases on
May 18, 2011 at 9:28 am
j.jj (5/18/2011)
So you have 2 unique cluster name's?
You have unique network names!
j.jj (5/18/2011)
seperate disk resources that are accessable from all nodes,
Yes, otherwise how would failover occur
j.jj (5/18/2011)
May 18, 2011 at 5:57 am
do you know what, it's something i have never tried. If you set up a share and add this as a resource into a cluster group i wouldn't be tempted...
May 18, 2011 at 4:04 am
MysteryJimbo (5/13/2011)
Windows 2008 includes enhancements for geographically dispersed clusters and across subnets and requires no additional software.
IIRC Windows 2008 can but SQL Server as an application cannot, worth double checking
May 18, 2011 at 4:01 am
why not just use log shipping for the report databases, no need for snapshots or mirroring then?
May 18, 2011 at 3:54 am
remember that when deploying multiple clustered instances of SQL Server that they all require their own unique resources for
disk
IP Address
Network name
You do not use the same network for multiple clustered...
May 18, 2011 at 3:51 am
Elliott Whitlow (5/16/2011)
1. SQL 2008 and SQL 2008R2 Standard Edition WILL install on a cluster that contains more than 2 nodes.
2. SQL 2008 and SQL 2008R2 Standard Edition setup...
May 16, 2011 at 12:27 pm
I found a webserver connecting to a back end database using SQL Server authentication, whereby the account used in the web site config file was the SA account. When i...
May 4, 2011 at 1:49 am
the article is correct, subst will not work especially if the service runs under a user account. The steps are perfectly reasonable, although i have to say this topic (starting...
May 4, 2011 at 1:40 am
samsql (5/3/2011)
. so wat shud be action plan...
See my last response above!!
May 3, 2011 at 11:53 pm
Syed Jahanzaib Bin hassan (4/29/2011)
ACTIVE/ACTIVE means 2 separate instances in a cluster,there is no load balancing
Active\Active means more than one instance of SQL server active on more than 1 cluster...
April 29, 2011 at 12:08 pm
you may also need to cleanse AD and DNS too
April 29, 2011 at 3:11 am
Elliott Whitlow (4/26/2011)
if I were to build a 4-node cluster where there were 3 x 2-node SQL clusters, would that be allowed.
That would form the base Windows cluster and is...
April 29, 2011 at 3:06 am
Viewing 15 posts - 7,126 through 7,140 (of 9,253 total)