Forum Replies Created

Viewing 15 posts - 1,051 through 1,065 (of 9,244 total)

  • RE: AlwaysOn AG failover works if on same VLAN, fails from Other VLANs

    Michael Gerholdt (12/20/2016)


    Initially, AlwaysOn Availability group works from everywhere with clients of various sorts aimed at listener.

    Do a manual failover, and now only clients on the same VLAN as the...

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

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

  • RE: Log Shipping with Cluster Shared Volumes and SQL Virtual Name

    Cluster Shared Volumes are a feature of Windows Server and integrate with Windows Server Failover Clusters, hence their name of Cluster Shared Volumes.

    They were originally employed to provide storage configurations...

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

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

  • RE: SQL database recovery from corrupt database file!

    This thread is over 2 years old!!

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

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

  • RE: Managing Log Files Sizes the Easy Way

    Pre size your log and don't shrink it

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

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

  • RE: SQl 2012: change database restoring mode to Standby mode?

    elulu2000 (12/15/2016)


    I have a SQL database that must be always on 'standby' mode because I must restore transaction logs from a vendor database to my local database on stand by...

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

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

  • RE: Can a database be removed from single AG replica without affecting other replicas

    praveen_vejandla (12/15/2016)


    Hi,

    In case of multiple AG secondary replicas, can a database be safely removed from only one of the secondary replica without any impact on other replicas?

    I don't want to...

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

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

  • RE: Managing Log Files Sizes the Easy Way

    Don't shrink your log files, apart from the fact it will very likely introduce massive file system fragmentation it's also very bad for perfomance.

    Each time the log is grown the...

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

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

  • RE: Renaming Logins From AD

    BradGrantSky (12/15/2016)


    Hi

    AD user names have changed. Just the naming standard has changed not the domain.

    eg

    Previous Name : ROCK\JDaniels

    New Name : ROCK\AA230373

    On SQL Server, there has been no issues.

    There is...

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

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

  • RE: Instance Stacking vs. VM Stacking

    Clint-525719 (12/12/2016)


    For SQL Server, yes. For Windows, the team responsible told me that each VM needed its own license. I am going off of what they are telling...

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

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

  • RE: Check my logic - moving TDE Encrypted databases and changing the encryption certificate

    Siberian Khatru (12/14/2016)


    but in order to change the certificate on a database -- don't I need to un-encrypt it and then re-encrypt it with the new certificate? Or is...

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

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

  • RE: Backing up log in High Availability

    krypto69 (12/8/2016)


    Hi,

    I am backing up the transaction log via a maintenance plan every 15 minutes on my secondary high avail server.

    It works and creates trn files every 15 minutes.

    My...

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

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

  • RE: How to move exisiting production Availability Group to new SAN

    shadow66 (12/13/2016)


    We are planning to migrate an existing AG (2-node AG cluster, no shared storage)

    to a new SAN, and want to keep the same drive letters, say F and...

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

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

  • RE: Availability Groups and Log Shipping

    GBeezy (12/14/2016)


    AG is set to backup the Primary.

    Ok, so this will change with a failover as the Primary obviously changes.

    GBeezy (12/14/2016)


    The backups are being stored on the network

    Ok this...

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

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

  • RE: Availability Groups and Log Shipping

    You're obviously missing some log backups.

    What is the current config for your Ag backups?

    Secondary?

    Primary?

    Any Replica?

    Are the backup files being stored centrally?

    When the primary changes the backup location, if local, will...

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

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

  • RE: Check my logic - moving TDE Encrypted databases and changing the encryption certificate

    Siberian Khatru (12/14/2016)


    I have a new SQL Server 2014 instance that I need to import many older SQL 2012 databases to in an effort to refresh a development environment. ...

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

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

Viewing 15 posts - 1,051 through 1,065 (of 9,244 total)