Forum Replies Created

Viewing 15 posts - 5,416 through 5,430 (of 9,241 total)

  • RE: Disk configuration

    Scott i don't disagree with you, we know that multiple arrays are ideal but all we're saying is in this case you have to go for something a little less...

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

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

  • RE: Disk configuration

    Lynn Pettis (6/26/2012)


    RAID (any form) is no replacement for backups. Anyone who thinks so is planning to fail instead of planning for a failure.

    I concur

    To add to Kevins comment,...

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

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

  • RE: Disk configuration

    ScottPletcher (6/26/2012)


    If you do somehow lose the (4-drive) RAID 10 here, all the dbs are also lost.

    That's why you take backups. You're more likely to lose a complete RAID1 mirror,...

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

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

  • RE: What system databases do I need to backup?

    Lowell (6/21/2012)


    you'd have to get a model from another instance with the same service packs applied (and maybe CU's as well...i'd have to double check on that)

    Same collation too 😉

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

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

  • RE: How to Secure the Database when Restore the Database

    tamil.selvanmca (6/23/2012)


    I want to secure the backup file so it can't be restored elsewhere by any One.

    I want to protect my backup file.

    Ensure you understand the effects and requirements of...

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

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

  • RE: Installation error -SQL server 2008R2 failover cluster through cmd prompt

    rherrera 67295 (6/25/2012)


    Ryan,

    I got the same issue. You need to add the parameter:

    PCUSOURCE="The path for your software"

    Use the path for the SP that you're installing.

    Example:

    PCUSOURCE="C:\install\SQL_Server2008R2\SP

    or

    Generate the file by running the...

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

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

  • RE: need sql server 2008 r2 enterprise trail set up

    Why not just buy a copy of developer edition?

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

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

  • RE: Always On with Failover clustering Instance

    An FCI can participate in an AlwaysOn availability group, could you detail a little more about the set up of the clustered nodes servicing the FCI and the node you...

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

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

  • RE: Disk configuration

    pdanes


    I don't do backups as often as I should - Express doesn't have the ability to schedule jobs, so I do them by hand whenever I see some activity on...

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

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

  • RE: Rebuild Master on cluster with multiple instances

    kenneth.holm (6/25/2012)


    Hi

    How would you solve this issue??

    I would follow this KB article 😉

    kenneth.holm (6/25/2012)


    One way would be

    1. Backup objects/ login and so on...

    2. Pause Node 2

    3. Put Sqlservice (resource)...

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

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

  • RE: Disk configuration

    ScottPletcher (6/25/2012)


    The advantage of RAID1 here is not likely speed -- atlhough you could see some speed up -- but in recoverability. With RAID1, a single drive failure does...

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

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

  • RE: Cluster Services

    As Jon has rightly pointed out before impeding the built in admins group you must add the cluster service account and the SQL server service account as logins

    See this link[/url]

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

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

  • RE: Cluster Services

    durai nagarajan (6/21/2012)[hrIn our environment we have two domain users one for SQL services and another for cluster.

    i am planning to revoke the access and configure the same with SQL...

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

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

  • RE: Disk configuration

    whichever way you look at it your disk config is limiting, as is the RAM capacity.

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

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

  • RE: Log shipping communication

    Anthony is spot on here, all communications are essentially triggered from the secondary server. Just a note to bear in mind, the backup folder for the primary server does not...

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

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

Viewing 15 posts - 5,416 through 5,430 (of 9,241 total)