Viewing 15 posts - 7,741 through 7,755 (of 9,241 total)
personally i would use the same file size, or maybe just one slightly smaller about 2048 MB minimum. The local controller will not have the overhead of the storage network...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 20, 2010 at 8:24 am
Hawkeye_DBA (8/20/2010)
try to run EXEC sp_change_users_login Auto_Fix, 'username'
that's because you have some parameters missing. if autofixing the database user account you need to supply a password and null for the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 20, 2010 at 8:20 am
After deploying a clustered SQL Server instance I always check my resource dependencies.
😎
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 20, 2010 at 7:03 am
On a Windows 2008 cluster the install will default to an MNS quorum configuration. You have to actually force it to use a disk which is no longer recommended. You...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 20, 2010 at 2:08 am
Mani
On the cluster node go into Failover Cluster Manager and at the top of the treeview underneath where it says "failover cluster manager" click on the Windows cluster name.
The centre...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 20, 2010 at 1:31 am
Mani-584606 (8/19/2010)
Could you please provide me the screen shot where the SQL Server 2008 installation gives the option for selecting the Quorum drive?
It doesnt, the quorum is part of the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 19, 2010 at 4:15 pm
quorum will be present as part of the cluster deployment.
Create a DTC clustered application first and then install SQL server
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 19, 2010 at 12:24 pm
SQL_Padre (8/19/2010)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 19, 2010 at 12:04 pm
onlo (8/18/2010)
and re-started the service.
you have to reboot the server, this is an operating system policy which will be forced by a reboot. Service restart has no effect!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 19, 2010 at 11:58 am
exec sp_change_users_login 'report'
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 19, 2010 at 11:53 am
make sure the size of your test file is larger than the SAN cache by at least 2 x
Param file should be something like
F:\testfile.dat 2 0x0 4096
Check the Microsoft document...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 19, 2010 at 11:47 am
you should already have some sort of quorum in force even on the single node cluster.
Create a clustered DTC application and then install SQL Server failover cluster.
The necessary groups, IP...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 19, 2010 at 11:43 am
Duran (8/19/2010)
set aside 15GB for a quorum,
no you dont!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 19, 2010 at 8:56 am
Brad
you're welcome, this does trip a few people over 😉
SQL Server when clustered will only use devices that it has dependencies on!
Regards
Perry
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 19, 2010 at 8:53 am
1John19 (1/13/2010)
Somehow VMWare (I suspected) did not allow the sql named instances to use the same port number.
this is nothing to do with VMWare, the Windows Operating System will not...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 19, 2010 at 4:41 am
Viewing 15 posts - 7,741 through 7,755 (of 9,241 total)