Viewing 15 posts - 7,636 through 7,650 (of 9,241 total)
yes, those instructions definitely dont seem to stack up.
Right click "central managements servers" and select "register central management server"
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 25, 2010 at 12:50 pm
george sibbald (9/24/2010)
Is it me or are the instructions in MSDN on setting it up inaccurate? I don't get the drop down options as they...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 25, 2010 at 4:55 am
SQL* (9/23/2010)
what exactly the virtual server is?
It's a virtual machine, this may be either HyperV, Vmware or any other hypervisor. These products allow you to run multiple virtual operating systems...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 23, 2010 at 11:41 pm
With each new release of SQL Server, MS are providing the DBA with more tools that are netter equipped. CMS is really starting to become a seasoned tool IMHO!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 23, 2010 at 11:36 pm
By using central management server in SQL 2008 you may run multi server script and compare the outputs!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 23, 2010 at 4:23 pm
The quorum options have changed with Windows 2008, check out technet for full details
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 23, 2010 at 11:37 am
Firstly, a cluster is either active\passive or active\active, thats it
madler-797963 (9/23/2010)
So do I need to quorums? How do I get two servers to read from the same quorum?
The servers...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 23, 2010 at 8:14 am
SQL* (9/23/2010)
hi,i'm very new to clustering concepts,
Two nodes means two physical servers(Yes/No)?
No, you may also use virtual machines. See my tech article at this link for how to deploy...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 23, 2010 at 5:06 am
if you're using cell encryption then you need to call the encryptby or decryptby methods for each insert\select. The app code would need to reflect this
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 23, 2010 at 4:53 am
DBAgal (9/22/2010)
The data source connection looks like this: Data Source=servername,1433\instancename
That's wrong, it should be
Data Source=servername,port number
You configure the port number via SQL Server configuration manager and then use the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 22, 2010 at 10:41 am
from memory you need port 1434 UDP and TCP. Can you not configure the application with the server name\IP and port number like so
Myserver, 1933
or
192.168.29.28, 1933
Just open the 1933...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 22, 2010 at 10:09 am
Dude
don't tackle the registry directly! Try this link from MS
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 22, 2010 at 10:04 am
Halcyon (9/21/2010)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 22, 2010 at 9:52 am
AK1516 (9/21/2010)
We have planned for a two node fail over cluster where each nodes should have a instance of sql server 2008 running but with different database on...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 22, 2010 at 9:51 am
isd83 (9/21/2010)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 22, 2010 at 9:39 am
Viewing 15 posts - 7,636 through 7,650 (of 9,241 total)