Viewing 15 posts - 7,636 through 7,650 (of 9,244 total)
the issue is you dont just have the sql server service resources. You also have any storage, IP and name resources. SQL server will not start until these are all...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 26, 2010 at 3:22 pm
Arrange some downtime for the instance with your change manager. Go into cluster administrator and move the SQL resource group to a partner node, note how long it takes to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 26, 2010 at 8:30 am
Marios Philippopoulos (9/25/2010)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 25, 2010 at 1:02 pm
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
Viewing 15 posts - 7,636 through 7,650 (of 9,244 total)