Viewing 15 posts - 7,606 through 7,620 (of 9,241 total)
The database you are restoring already exists on the server. If you want to overwrite it use
WITH REPLACE
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 5, 2010 at 1:17 am
Hi
to find the quorum type in use do the following
go into Failover cluster manager and in the left hand pane click on the cluster name. In the centre pane the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 4, 2010 at 9:45 am
I get office, OS and server products to play with. Helps you to keep up with the latest MS technologies!
MS press are poor though IMHO
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 3, 2010 at 2:35 pm
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 1, 2010 at 1:13 am
Sachin Vaidya (9/29/2010)
Though I am...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 30, 2010 at 10:45 am
have you checked the replication job history and status?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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"
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 29, 2010 at 2:33 pm
Viewing 15 posts - 7,606 through 7,620 (of 9,241 total)