Viewing 15 posts - 6,766 through 6,780 (of 9,244 total)
patch the passive node first, remove the node from the possible owners list on the cluster resources. Install the SP. Add the node back to possible owners list afterwards.
Once done...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 24, 2011 at 11:01 am
Jinu43 (8/16/2011)
configured security( i already configured security)
Sorry for the delay replying. I believe you may already have an endpoint configured on the mirror instance that is different to what you...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 24, 2011 at 10:56 am
shew (8/24/2011)
Does anyone on this forum have experience with building a Windows Server 2008 Failover Cluster on cheap hardware at home?
Follow my 3 part guide on this site starting at...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 24, 2011 at 8:53 am
take a look at this article
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 24, 2011 at 2:46 am
Minaz Amin (8/23/2011)
Generally standby ( using mirroring or Log shipping ) will be in read only mode.
A mirror database will only be read mode if you use database snapshots and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 24, 2011 at 12:51 am
Lowell (8/23/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 23, 2011 at 9:27 am
It's consistent, i'll give it that. It's the same in SQL Server 2008 R2 management studio 😀
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 23, 2011 at 6:39 am
i see what is confusing the OP now
go into the shrink file dialog and select the log file and release ununsed space, then script action to new query window. It...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 23, 2011 at 6:10 am
GilaMonster (8/23/2011)
p.s. TruncateOnly on shrink is ignored for log files. It's only a valid option for data files (see BoL)
good catch Gail i totally missed that bit 🙂
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 23, 2011 at 6:04 am
which hyper visor are you using?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 23, 2011 at 5:50 am
MarvinTheAndriod (8/23/2011)
I am shrinking the log file. When scripted out it comes up with the command line:DBCC SHRINKFILE (N'HCMPRD88_Data' , 0, TRUNCATEONLY)
it looks like youre trying to shrink the log...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 23, 2011 at 5:20 am
MarvinTheAndriod (8/23/2011)
Perry Whittle (8/23/2011)
are you referring to the option to release ununsed space in the database shrink dialog?Yes this the option, im looking at
Are you shrinking the database or an...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 23, 2011 at 5:12 am
are you referring to the option to release ununsed space in the database shrink dialog?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 23, 2011 at 5:02 am
check the Windows application event log for messages
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 23, 2011 at 3:58 am
yes, terminal services does not affect sql server agent jobs
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 23, 2011 at 3:39 am
Viewing 15 posts - 6,766 through 6,780 (of 9,244 total)