Viewing 15 posts - 6,301 through 6,315 (of 9,244 total)
Elliott Whitlow (10/27/2011)
I would mount the new drives in as different drive letters.
I would add the new drives to the resource group.
Then I...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 31, 2011 at 5:00 am
larrykl (10/29/2011)
Trying to install a 2 node Active/Passive SQL Server cluster but it is failing due to the fact that it can't find an available shared disk. I...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 31, 2011 at 4:48 am
Windows 2008 no longer uses a dedicated account for the cluster service, this is system managed.
Please read my response to your other post regarding taking a little more time to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 31, 2011 at 4:46 am
larrykl (10/31/2011)
I didn't realize shared storage is a requirement. We already popped for Win2K8 Ent. Edition too.
exactly why you should always research what is required before purchasing anything, even...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 31, 2011 at 4:35 am
Thank you Mohammed
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 30, 2011 at 11:31 am
ALZDBA (10/28/2011)
clustering. Is another HA. Option which has its own downsides.
and overkill if you only have a handful of databases
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 28, 2011 at 7:02 am
spidey73 (10/27/2011)
The database files are on the SQL server itself.
The SQL service account is a Active Directory account that got access to the database file...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 28, 2011 at 6:33 am
run NET SHARE on the passive node and check the output
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 27, 2011 at 2:14 am
can you post details of the query, table and the indexes
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 27, 2011 at 2:04 am
Run DBCC UPDATEUSAGE against one of the databases and then te run CHECKDB, let us know how you get on.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 27, 2011 at 1:35 am
Ed Zann (10/26/2011)
the default database is scripted out for the login, so it must exist on the destination or the statement will error out and not create the login.
This is...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 26, 2011 at 12:01 pm
yes the installer is still the same
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 26, 2011 at 10:10 am
from memory go to Control Panel > Programs > Programs & Features. Select SQL Server 2005 and click change
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 26, 2011 at 9:58 am
spidey73 (10/26/2011)
The strange thing is that from the 11 databases (including the system dbs) the same 5 always fail.
Have these databases come from a legacy\previous version of SQL Server?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 26, 2011 at 8:44 am
there's a nasty bug in the sp2 installer which if i remember correctly doesnt affect the sp3 installer.
with sp2 you cant run the installer and patch only the one node....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 25, 2011 at 10:46 am
Viewing 15 posts - 6,301 through 6,315 (of 9,244 total)