Forum Replies Created

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

  • RE: SQL and identifying backup software

    DPM takes backups in a completely different fashion to Redgate SQLBackup. SQLBackup will most likely, if standard config, be generating .SQB files and these are the SQL Server backups.

    As Jeffrey...

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

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

  • RE: Edit the CDW - Copy database Wizard SSIS package

    the message gives you all the info you need. The task is not an editable SSIS object, rather, it has a set of properties that define the execution context. Right...

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

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

  • RE: Default Instance and Named instance using the same environment SQL 2008

    go into sql server configuration manager and check the alias section. Someone has setup an alias for the named instance probably

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

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

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

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