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...
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...
September 26, 2010 at 8:30 am
Marios Philippopoulos (9/25/2010)
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"
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...
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...
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!
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!
September 23, 2010 at 4:23 pm
The quorum options have changed with Windows 2008, check out technet for full details
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...
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...
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
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...
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...
September 22, 2010 at 10:09 am
Dude
don't tackle the registry directly! Try this link from MS
September 22, 2010 at 10:04 am
Viewing 15 posts - 7,636 through 7,650 (of 9,244 total)