Viewing 15 posts - 7,126 through 7,140 (of 9,244 total)
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
Firstly, mirroring is way easier to set up and maintain than replication.
You may change the default timeout for mirroring using the following
ALTER DATABASE mydatabase SET PARTNER TIMEOUT 90
This will...
April 29, 2011 at 3:01 am
providing the builds are in sync you can just restore the master database in single user mode. The master database paths are held in the registry as startup parameters for...
April 29, 2011 at 2:51 am
Thank you, please don't forget to rate the article
April 27, 2011 at 2:13 pm
What command are you using to execute sp_delete_backuphistory?
Both those procedures I have mentioned trim their related tables, you need to decide how history you will keep. Execute the procedures trimming...
April 27, 2011 at 12:33 am
samsql (4/12/2011)
Perry will there be any issue if i truncate the tables.... as i dnt have any space...
April 26, 2011 at 4:29 am
Again starting with Windows 2008 you can map MSDTC resources to chosen cluster service groups although putting the MSDTC in the same group should enable it to be used by...
April 20, 2011 at 3:38 pm
Syed Jahanzaib Bin hassan (4/18/2011)
April 18, 2011 at 11:34 pm
Viewing 15 posts - 7,126 through 7,140 (of 9,244 total)