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...
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...
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...
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)
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...
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!
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...
August 23, 2010 at 8:50 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...
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...
August 22, 2010 at 12:07 pm
use the following syntax
GRANT <permission>, <permission>, ... ON OBJECT::dbo.mytable
TO [user1], [user2], [user3], ..........
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.
August 21, 2010 at 4:34 am
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...
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...
August 20, 2010 at 10:37 am
Viewing 15 posts - 7,726 through 7,740 (of 9,244 total)