Forum Replies Created

Viewing 15 posts - 5,251 through 5,265 (of 9,244 total)

  • RE: Configuration for SQL Server 2012

    sixthzenz (7/25/2012)

    So since I have a 1TB partition (4 15K - RAID 10) to use,

    Is this a spinning platter array (I.e, physical hard drives)?

    sixthzenz (7/25/2012)

    I read a lot about...

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

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

    July 27, 2012 at 12:03 am

    #1518298

  • RE: Litespeed backup job failed

    msjust (7/26/2012)

    "Unable to create backup sub directory "\\XXXXXXX\r$\XXXXXXX...

    You're using a windows administrative share and unless the SQL server agent account is a local admin on server \\xxxxxxxxxxx the r$...

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

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

    July 26, 2012 at 4:13 pm

    #1518220

  • RE: Cluster, drive letters, and alwayson replicas

    allmhuran (7/25/2012)

    I must be missing something, aye?

    Yes, both instances must reside on separate nodes and do not use shared storage, they use local disks which you would configure with the...

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

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

    July 26, 2012 at 4:04 pm

    #1518218

  • RE: how to update SP4 using on passive node using passive switch

    If running from the active node with no switches it will update all nodes

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

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

    July 26, 2012 at 11:00 am

    #1518070

  • RE: how to update SP4 using on passive node using passive switch

    No problem, you're welcome

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

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

    July 25, 2012 at 8:01 am

    #1517367

  • RE: how to update SP4 using on passive node using passive switch

    yes, open a command prompt and change to the directory where the hotfix exists then execute the hotfix EXE passing in the PASSIVE parameter as i have shown

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

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

    July 25, 2012 at 5:34 am

    #1517284

  • RE: how to update SP4 using on passive node using passive switch

    Benki Chendu (7/25/2012)

    Customer wants me to install SQL Server 2005 SP4 on passive node using passive switch to minimize the downtime.

    How do I do it?

    I had done it long time...

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

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

    July 25, 2012 at 5:30 am

    #1517280

  • RE: New installation on passive node

    Benki Chendu (7/25/2012)

    Can I get an official Microsoft link which describes these prerequisites?

    yes, this link provides info.

    Installing a 2nd failover instance requires exactly the same process and resources as installing...

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

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

    July 25, 2012 at 3:14 am

    #1517241

  • RE: New installation on passive node

    You can either create an application\group or allow the installer to do this for you. You will also need shared disks, an IP address and a unique virtual network name

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

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

    July 24, 2012 at 1:59 pm

    #1517064

  • RE: Configuration for SQL Server 2012

    sixthzenz (7/24/2012)

    Good point(s). The reason I asked these questions is because I've heard people talk about having to do certain tweaks/configs when using SSDs. So are you implying I won't...

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

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

    July 24, 2012 at 9:46 am

    #1516908

  • RE: Setting up log shipping for multiple databases

    stephen.chapman 77519 (7/24/2012)

    Hi,

    I am new to this forum but I have just had to deal with setting up log shipping for a DR site which would have meant setting this...

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

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

    July 24, 2012 at 4:58 am

    #1516715

  • RE: Configuration for SQL Server 2012

    sixthzenz (7/23/2012)

    I'm building a dev server for our team and the drives are currently configured as follows:

    One 240GB SSD (Use it for the OS only?)

    One 220 GB SSD RAID 10...

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

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

    July 24, 2012 at 3:36 am

    #1516679

  • RE: huge unsent log in DB mirroring

    winston Smith (7/24/2012)

    I have two databsaes in async mirroring. Today there was a massive value for unsent log (it was showing over 50GB) and a time to send log at...

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

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

    July 24, 2012 at 2:54 am

    #1516654

  • RE: Diverting clinet network traffic form primary server to secondary server in case of log shipping

    anoop.mig29 (7/23/2012)

    hi we are trying to carry out log shipping in sql server 2008 enterprise edition.problem is how to divert client traffic form primary server to secondary server once we...

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

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

    July 24, 2012 at 2:53 am

    #1516653

  • RE: To Insert rows into a Compressed table..

    Jayanth_Kurup (7/23/2012)

    There is a CPU overhead with compression, since your inserting thousands of rows , make sure you take this into account. other than this there is nothin special needed...

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

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

    July 24, 2012 at 2:49 am

    #1516651

Viewing 15 posts - 5,251 through 5,265 (of 9,244 total)