Viewing 15 posts - 4,531 through 4,545 (of 9,253 total)
if using local system you need to allow the machine account access to the network share
November 30, 2012 at 11:01 am
What are the specs for each VM?
You have to bear in mind that the host will have an overhead for its OS and the VMWare Workstation Hypervisor before you even...
November 30, 2012 at 10:59 am
you'll typically see this when there aren't enough resources on the host machine to service all the VMs. Can you supply the full spec of your VMWare host?
November 30, 2012 at 9:19 am
This is fairly straightforward
selectobject_name(object_id) AS TableName
, name AS ColumnName
from sys.columns
where name like '%columnname string%'
November 30, 2012 at 6:06 am
abhishekkulkarni1284 (11/29/2012)
November 30, 2012 at 5:58 am
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...
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?
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...
November 30, 2012 at 5:34 am
This thread is over a year old!!
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.
November 29, 2012 at 1:35 pm
evict node and clean install
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)
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,...
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...
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...
November 29, 2012 at 6:41 am
Viewing 15 posts - 4,531 through 4,545 (of 9,253 total)