Forum Replies Created

Viewing 15 posts - 6,496 through 6,510 (of 9,244 total)

  • RE: breaking sql 2008 cluster for ssas

    It is true.

    If you have a clustered instance of the database engine and analysis services and database engine is active on node a and SSAS on node b then...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Went from a 3 file DB to a 6 file DB MDF,NDF

    Just because you have extra drives doesnt mean you have to create extra files. Are all these files in the same filegroup or separate filegroups? I'm guessing that they're in...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: breaking sql 2008 cluster for ssas

    just out of interest, what do you have against a clustered instance of analysis services?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: SQL Server 2008 R2 Server Side Tracing

    Sapen (10/3/2011)


    exec @rc = sp_trace_create @TraceID output, 0, N'E:\Trace\Trace', @maxfilesize, @Datetime

    this is the default when scripting a trace from Profiler, despite setting the rollover in the GUI it disables it...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: SQL server 2K8 - Cluster Configuration (active/active)

    ananda.murugesan (10/2/2011)


    Hi,

    I am new entry for sql server cluster high availability configuration, Please tell me, I want to know how to install cluster & step by step configuration.

    Active/Active and...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Creating a 2 Node SQL Server 2008 Virtual Cluster Part 1

    Hi Mohammed, sure i'm happy to help.

    May i start by asking which browser you use?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Writing to the Passive Node

    devendra_shirbad (9/30/2011)


    Clustering requires shared data storage

    For traditional cluster setups, yes.

    Geo graphically dispersed clusters negate this requirement. They remove the single point of failure on the storage and as such...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Database Size increasing

    are you running index maintenance plans\jobs at all, these can cause the database file to expand

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: SQL Server 2008 R2 Reporting Services Installation and Migration

    jared-709193 (9/29/2011)


    Hmm... You may have to create another instance on that server for the new report server databases

    no, you do not have to do this. Configure the new SSRS instance...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Tuning Queue Depth settings

    test it all the way but i certainly wouldnt set it any higher than 64 at most

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: SQL Server 2008 R2 Reporting Services Installation and Migration

    you cant configure both SSRS instances to use the same database!!

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: SQL Server 2005 Master database Restore to a Different Server

    actually its only a year old, but hey there's nothing like resurrecting the dead 😀

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Changing Host name effect sql replication ?

    you're changing the node name and not the virtual network name is that correct?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Changing Host name in win 2008 R2 cluster server

    is this your friend by any chance

    http://www.sqlservercentral.com/Forums/Topic1177927-1549-1.aspx

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Strange SQL Cluster 2008 situation

    what brand are the onboard NICs, Broadcom, Intel, etc?

    have you ensured you are using the latest team drivers for your hardware from the maunfacturer?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 15 posts - 6,496 through 6,510 (of 9,244 total)