Viewing 15 posts - 4,531 through 4,545 (of 9,244 total)
ravinder-317313 (11/30/2012)
we have installed SQL 2K5 With sp4 on windows server 2008 r2(No msdtc needed) successfully.
when we connect using sql virual name on Active node(Through ssms) It succede but whne...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 30, 2012 at 5:49 am
Do you plan to do an in place upgrade or side by side?
Do you plan to upgrade the hardware for the cluster?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 30, 2012 at 5:35 am
ramyours2003 (11/30/2012)
i like to configure mirroring to the databases which are in clustered environment how can we achieve this task ?
A simple google search (and i do mean...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 30, 2012 at 5:34 am
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
Viewing 15 posts - 4,531 through 4,545 (of 9,244 total)