Forum Replies Created

Viewing 15 posts - 4,621 through 4,635 (of 9,244 total)

  • RE: What would be the best RAID configuration for this hardware?

    test a couple of smaller arrays too as well as RAID5 vs RAID10

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

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

  • RE: Log Shipping question.

    jfogel (11/15/2012)


    This stuff throws a wrench in how I'm used to backing up my DBs and transaction log backup schedules too. Gotta get more practice with this stuff.

    These are the...

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

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

  • RE: Log Shipping question.

    the best bit is, providing the differential base LSN is in sync between the primary and secondary you can use a differential backup to bridge LSN gaps when resuming log...

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

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

  • RE: Log Shipping question.

    SQLSACT (11/15/2012)


    The moment your recover the secondary database in a Log Shipping setup, a restore is required to re-start the session again.

    this is incorrect, role switching in log shipping...

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

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

  • RE: What would be the best RAID configuration for this hardware?

    TheSQLGuru (11/15/2012)


    I think with so few spindles carving them up into smaller sets just sets yourself up for one or more of those smaller groups to be a bottleneck. ...

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

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

  • RE: new 64-bit Sql 2005 Server - integrity check completes then memory spikes 75% and doesnt lower

    jswong05 (11/14/2012)


    If you don't want to distribute so much memory on SQL Server usage, just lower the Max memory. You can also issue commands to clear buffer and procedure cache...

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

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

  • RE: Seaparating Data files and Log Files

    chandan_jha18 (11/14/2012)


    Perry,

    Thanks for replying.

    The server uses VMWare and the sysadmin wrote the following to me:

    'All of these drives are situated on the same set volume on the NetApp'.

    He also wrote...

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

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

  • RE: Availibility Group Listener Name

    yes, so you'll need to filter for your particular group then won't you 😉

    Check the link below for more info

    http://msdn.microsoft.com/en-us/library/ff878305.aspx

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

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

  • RE: Mount Point quick question

    sql-lover (11/14/2012)


    Thanks Perry,

    I'll take a look today

    It will help you understand better 😉

    sql-lover (11/14/2012)


    but regardless , with a max of two failover instances on a two node clusters ,...

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

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

  • RE: Availibility Group Listener Name

    Check the following system catalog for listener info

    select * from sys.availability_group_listeners

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

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

  • RE: shifting sql server from one system to another

    abdsubhani (11/14/2012)


    Hi all,

    In our organisation we are shifting sql server to another system. we are done with that but we are not able to get logins. we need to...

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

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

  • RE: Mount Point quick question

    sql-lover (11/13/2012)


    Hi,

    I am working on the design of a MS-SQL 2012 failover cluster, running on top of Windows 2008. I am assuming mount point's behavior is similar between Denali and...

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

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

  • RE: change initial size of tempdb

    are you increasing or decreasing the initial size?

    are the files all currently the same initial size?

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

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

  • RE: Failed Transaction Log Restore

    can you post details of the exact error you receive?

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

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

  • RE: SQL IO Performance

    robr-793239 (11/13/2012)


    I'm running out of brain cells trying to figure out what I've overlooked. Hoping someone has a quick checklist of things I can look for...

    Scenario: I have 3 SQL...

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

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

Viewing 15 posts - 4,621 through 4,635 (of 9,244 total)