Viewing 15 posts - 4,531 through 4,545 (of 9,241 total)
This thread is over a year old!!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 29, 2012 at 11:49 pm
That's correct, the service should be set to manual.
What other info do you have in the event logs.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 29, 2012 at 1:35 pm
evict node and clean install
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 29, 2012 at 9:54 am
evict the old node from the cluster, rebuild the server with a new node name na dadd it back to the cluster then re install any apps (SQL,SAP,etc)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 29, 2012 at 9:29 am
sqlbanana (11/29/2012)
data and tempdb are on S:log are on L:
I ran -
select wait_duration_ms , wait_type, blocking_session_id from sys.dm_os_waiting_tasks order by 1 desc
2512536962ONDEMAND_TASK_QUEUENULL
2512536575BROKER_TRANSMITTERNULL
2512536575BROKER_TRANSMITTERNULL
2512530889KSOURCE_WAKEUPNULL
2512530880BROKER_EVENTHANDLERNULL
26978702XE_DISPATCHER_WAITNULL
906459CHECKPOINT_QUEUENULL
34778DISPATCHER_QUEUE_SEMAPHORENULL
8612XE_TIMER_EVENTNULL
4828REQUEST_FOR_DEADLOCK_SEARCHNULL
3910SQLTRACE_INCREMENTAL_FLUSH_SLEEPNULL
996BROKER_TO_FLUSHNULL
462LAZYWRITER_SLEEPNULL
211LOGMGR_QUEUENULL
thanks
s
Are these disks vmware virtual disks or RDM's.
If VMDKs,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 29, 2012 at 8:01 am
Paul Clark-418949 (11/29/2012)
Taking the Database Offline only makes the Database inaccessible. SQL Server will still have a lock on the files
No it doesn't! This is an action I have performed...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 29, 2012 at 7:06 am
runal_jagtap (11/29/2012)
Access Denied, File may be currently in use :w00t:
i have admin rights on the drives & folders.. & nothing is open still its not allowing me...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 29, 2012 at 6:41 am
either check the status in SQL Server management studio or query sys.database_mirroring
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 29, 2012 at 6:28 am
raotor (11/28/2012)
Perry Whittle (11/28/2012)
what is the error you are receiving?
There's no error as such.
When I right-click on the database, click Tasks, click Restore and then select Database the list of...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 28, 2012 at 1:17 pm
Jpotucek (11/28/2012)
currently, all Cluster resources (The Quorum and both sets of...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 28, 2012 at 12:07 pm
what is the error you are receiving?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 28, 2012 at 12:04 pm
dan-572483 (11/28/2012)
Interesting... So a 2-Node failover cluster can host multiple default instances (using separate network names & IPs & drives).
No, it can't and that's not what I...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 28, 2012 at 11:58 am
Ensure you present any shared storage to the second node and then open the sql server installer and select the option "Add node to a SQL Server failover cluster" 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 28, 2012 at 9:52 am
I'm already working on a guide for sql server 2012, windows 2012 on ESX5.1i
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 28, 2012 at 9:22 am
BigSam (11/28/2012)
A. When SQL was in a failed state on Node A I tried to bring it online from SQL Configuration Manager
Incorrect, bring the resources online manually from failover cluster...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 28, 2012 at 9:17 am
Viewing 15 posts - 4,531 through 4,545 (of 9,241 total)