Viewing 15 posts - 7,621 through 7,635 (of 9,253 total)
Hi Keith
are we talking SQL server user accounts or Windows user\group accounts?
The only way you'll lose permissions for the user in the database is to drop the database user! When...
October 3, 2010 at 4:15 am
i have a technet subscription which i have just renewed for another year without any issues. I did however have issues with MS and misprints in one of their press...
October 3, 2010 at 3:11 am
paul.knibbs (10/1/2010)
And stopping it will also tell you real quick if somebody actually IS using it, because you'll get a complaint! (Or something you have installed will stop working). 🙂
My...
October 1, 2010 at 1:44 am
Sachin Vaidya (9/30/2010)
There is a different instance of SQL Server installed on this server but as of now in my knowledge, nobody is using that server apart from myself.
Aah now...
October 1, 2010 at 1:13 am
Sachin Vaidya (9/29/2010)
Though I am...
September 30, 2010 at 11:24 am
no problem. Take a bit of time to get used to failover cluster manager before going any further and you'll be golden 😉
September 30, 2010 at 11:06 am
Marios Philippopoulos (9/30/2010)
Node 1: active node for instance SQL01
Node 2: active node for instances SQL02 and ABCD
Node 3: passive node
Instance SQL01 can only fail over from...
September 30, 2010 at 11:03 am
it doesn't setup the log, events are now monitored through the event viewer in failover cluster manager. The command below dumps a copy of the log to "cluster.log" for interrogation\support...
September 30, 2010 at 10:45 am
have you checked the replication job history and status?
September 30, 2010 at 8:15 am
Pre create the empty service\application and then fill it with the appropriate resources (disk, DTC IP, DTC NAME, DTC service) and then install SQL Server 2008 selecting the pre created...
September 30, 2010 at 8:12 am
pshaship (9/29/2010)
Does running the Cluster validation when one of the clustered nodes have SQL Server instance and databases, corrupt any data?Thanks
no reason why it should, in fact what makes you...
September 29, 2010 at 2:38 pm
cluster.log has gone in Windows 2008, you can generate a log though using the following command
Cluster log /gen /copy "C:\yourpath"
September 29, 2010 at 2:33 pm
which quorum type did you specify when deploying the Windows 2008 cluster?
September 29, 2010 at 11:52 am
--supply a date or getdate(), etc
declare @dtime datetime
select @dtime = '2010-07-04 10:25:21'
--pick out the parts you need
select cast(datepart(mi, @dtime) as varchar(2)) + ':' +
...
September 29, 2010 at 11:06 am
Duran
you add the disks as cluster resources and create a clustered DTC app for each one you want to deploy. You could even create them in the SQL groups they...
September 29, 2010 at 10:53 am
Viewing 15 posts - 7,621 through 7,635 (of 9,253 total)