Viewing 15 posts - 7,726 through 7,740 (of 9,244 total)
pshaship (8/23/2010)
Do we need to stop the SQL Server services before applying SP1 in Cluster environment? Because , we have only Single node.
Not normally, no! But a cluster with only...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 24, 2010 at 4:57 am
just a thought.
Have you tried manually extracting the SP1 to a temp folder on C drive and launching it from there??
execute the following
en_sql_server_2008_sp1_x64.exe /X:"C:\SP1"
Once the files are extracted launch the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 24, 2010 at 4:50 am
Taking the SQL server service resource offline will not offline the disks. The installer must be offlining the whole group.
Take the whole group offline before running the installer, not...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 24, 2010 at 12:53 am
pshaship (8/22/2010)
As i suspected you are using file share quorum.
NO. As you see my Quorum configuration says Node Majority.
:blush: sorry my bad. yes. Was meant to say Node majority
pshaship (8/22/2010)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 23, 2010 at 9:34 am
if the nodes are close enough then yes, a bit of a crude way but yes. However, your heartbeat network could easily be 2 ports on the network switch that...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 23, 2010 at 9:20 am
Indianrock (8/19/2010)
Great info!
the info provided is designed to help re create an environment not upgrade it!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 23, 2010 at 8:53 am
Hawkeye_DBA (8/23/2010)
here's what I normally run: exec sp_change_users_login 'auto_fix', '<user name here>', NULLIs this incorrect????
that would only work when the login already exists on the server. To auto fix...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 23, 2010 at 8:50 am
ha ha, thank you. And my thanks to Russel too! 😀
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 23, 2010 at 8:35 am
As i suspected you are using file share quorum.
To recap, these are the quorum models in Windows 2008 clustering
Node Majority—There's no file-share witness or disk witness and votes are...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 22, 2010 at 3:19 pm
pshaship (8/21/2010)
I believe, QUORUM will be assigned when add the second node (correct me if we miss anything here)
no, no , no , no , no. The quorum is present...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 22, 2010 at 12:07 pm
use the following syntax
GRANT <permission>, <permission>, ... ON OBJECT::dbo.mytable
TO [user1], [user2], [user3], ..........
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 22, 2010 at 12:03 pm
I'm a big fan of HP kit, in my experience it is far more reliable\superior to Dell.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 21, 2010 at 4:34 am
Personally I would not have Dell in my datacentre!!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 20, 2010 at 5:41 pm
Derrick Smith (8/20/2010)
when you try to auto_fix a db user that doesn't have a matching login created on the server. It's not a case of missing parameters as mentioned earlier.
When...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 20, 2010 at 5:39 pm
Hmm, did you execute these queries under the context of your problem database?
The second query returns only the default database user accounts (as you would see in the master or...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 20, 2010 at 10:37 am
Viewing 15 posts - 7,726 through 7,740 (of 9,244 total)