Forum Replies Created

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

  • 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" 😉

  • RE: Tuning Queue Depth settings

    consult your HBA manufacturer, this should be tuned with caution. It can provide increases in performance but can also result in the reverse to

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

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

  • RE: Sql server doesnt release memory.

    which process is taking 99% of the CPU?

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

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

  • RE: Can somebody recommend reliable sql backup software?

    there are many products as you know. For cost, ease of use and features i personally would go with Redgate SQLBackup. Having said that i'm currently using Quest LiteSpeed which...

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

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

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