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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 4, 2011 at 1:40 am
samsql (5/3/2011)
. so wat shud be action plan...
See my last response above!!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 29, 2011 at 12:08 pm
you may also need to cleanse AD and DNS too
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 29, 2011 at 2:51 am
Thank you, please don't forget to rate the article
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 20, 2011 at 3:38 pm
Syed Jahanzaib Bin hassan (4/18/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 18, 2011 at 11:34 pm
Viewing 15 posts - 7,126 through 7,140 (of 9,244 total)