Viewing 15 posts - 7,726 through 7,740 (of 9,241 total)
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
you're welcome friend!
If you're on LinkedIn join my network and maybe recommend me if you can!
Regards
Perry
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 20, 2010 at 9:22 am
could you post the output of the following queries when run against your database
select distinct sp.name, sp.sid from sys.server_principals sp, sys.database_principals dp
where sp.type = 'S'
and not exists (select sid...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 20, 2010 at 9:21 am
Using truncateonly will shrink the file to the last used extent
DBCC SHRINKFILE (LogicalFileName, truncateonly)
Specifying a size will shrink and re arrange the file to free potentially more space (2GB in...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 20, 2010 at 8:51 am
Viewing 15 posts - 7,726 through 7,740 (of 9,241 total)