Viewing 15 posts - 7,651 through 7,665 (of 9,244 total)
Halcyon (9/21/2010)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 22, 2010 at 9:52 am
AK1516 (9/21/2010)
We have planned for a two node fail over cluster where each nodes should have a instance of sql server 2008 running but with different database on...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 22, 2010 at 9:51 am
isd83 (9/21/2010)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 22, 2010 at 9:39 am
Run the first log backup followed immediately by another then check DBCC Loginfo
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 20, 2010 at 9:14 am
hi
what does the following return when executed against the database in question
DBCC LOGINFO
Hint: scroll down the results and check for a status of 2 near the end of the output!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 19, 2010 at 7:53 am
Hi Jeff
results attached. I have a HP laptop with win XP SP2, 3GB RAM and AMD Turion x2 1.9ghz
query took 23 mins 21 secs
Regards
Perry
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 18, 2010 at 5:04 pm
try now, the pdf is fairly large so download to disk and then open!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 18, 2010 at 4:57 pm
if you have 2 instances of sql server and 2 nodes
active\active
1 instance running on node 1, 1 instance running on node 2
active\passive
2 instances running on node 1, no sql...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 18, 2010 at 4:48 pm
try them again, they do take a while to download as they are around 4MB each
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 18, 2010 at 4:45 pm
yes, to create an active active installation simply install a second failover cluster instance and move the group to a passive node!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 18, 2010 at 9:30 am
Hi
check my guide at the following link for SQL Server 2008 on a Windows 2003 cluster
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 18, 2010 at 9:02 am
Hi
check my guide at this link using VMWare Server 2
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 18, 2010 at 8:55 am
Firstly dont use VirtualPC or Player. Use either Microsoft Virtual Server 2005 R2 SP1 or VMWare Server 2.0.x
Check my guide at this link for step by step details using VMWare...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 18, 2010 at 8:44 am
to install a new failover cluster instance you select "new sql server failover cluster installation". For each node after that you add to the instance you select "add node to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 18, 2010 at 8:40 am
this is another good reason to slipstream SP1 at install time. Cures a whole load of issues with the RTM installer!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 17, 2010 at 10:44 am
Viewing 15 posts - 7,651 through 7,665 (of 9,244 total)