Forum Replies Created

Viewing 15 posts - 556 through 570 (of 758 total)

  • RE: SQL 2012 High Availibility

    Perry Whittle (5/21/2012)

    This is already detailed in my previous replies, but

    derekr 43208 (5/21/2012)

    does each node need to be part of the same cluster?

    derekr 43208 (5/21/2012)

    Does SQL need to be installed...

    May 21, 2012 at 4:43 am

    #1490325

  • RE: SQL 2012 High Availibility

    Perry Whittle (5/21/2012)

    This is already detailed in my previous replies, but

    derekr 43208 (5/21/2012)

    does each node need to be part of the same cluster?

    For availability groups, yes, all nodes need to...

    May 21, 2012 at 4:40 am

    #1490323

  • RE: SQL 2012 High Availibility

    Marios Philippopoulos (5/18/2012)

    I would move away from shared storage, now that we have SQL 2012 AlwaysOn Availability Groups.

    In our organization, at least, we have had a bad experience with shared...

    May 21, 2012 at 3:27 am

    #1490294

  • RE: FILESTREAM messages in error log

    Sorted!

    Ran profiler trace

    Vendor Application was causing the fuss....

    May 18, 2012 at 7:17 am

    #1489663

  • RE: Log Shipping with Compression

    Steve Jones - SSC Editor (5/17/2012)

    Backup compression isn't available in every edition of SQL Server.

    The CPU cost is the main thing, and it's not horrible, but it depends on...

    May 17, 2012 at 11:50 pm

    #1489483

  • RE: Log Shipping with Compression

    Steve Jones - SSC Editor (5/17/2012)

    I haven't used it, but compression in terms of row/data is fairly minimal load. You will be reading the logs, compressing the data, and sending...

    May 17, 2012 at 1:16 pm

    #1489319

  • RE: Log Shipping - Index Maintenance

    opc.three (5/17/2012)

    anthony.green (5/17/2012)

    No, as an index rebuild is a fully logged operation so it logs the same amount in Full or Bulk-Logged so there is no difference

    Slight tweak here. The...

    May 17, 2012 at 12:45 pm

    #1489301

  • RE: Log Shipping with Compression

    Steve Jones - SSC Editor (5/17/2012)

    I haven't used it, but compression in terms of row/data is fairly minimal load. You will be reading the logs, compressing the data, and sending...

    May 17, 2012 at 11:45 am

    #1489266

  • RE: Log Shipping - Index Maintenance

    anthony.green (5/17/2012)

    Yes, the index rebuild is logged to the transaction log and therefore replayed on the subsequent restore.

    Am I correct in that when the Log Shipping Primary is running in...

    May 17, 2012 at 8:25 am

    #1489051

  • RE: Log Shipping - Index Maintenance

    anthony.green (5/17/2012)

    Unsure if you will see the alter index, I would of said you would see restore database or restore log as its restoring the log, it just so happens...

    May 17, 2012 at 8:12 am

    #1489045

  • RE: Log Shipping - Index Maintenance

    anthony.green (5/17/2012)

    secondary server is generally in norecovery mode so no users, so no load on the database so can usually do things quicker as its not serving user requests

    Ok

    So if...

    May 17, 2012 at 7:56 am

    #1489031

  • RE: Log Shipping - Index Maintenance

    Michael Valentine Jones (5/17/2012)

    Yes. Index maintenance is just like any other transaction, so it is logged and gets applied to the target.

    Ok

    Why is it that when the logs are...

    May 17, 2012 at 7:49 am

    #1489022

  • RE: SQL 2012 High Availibility

    Perry Whittle (5/12/2012)

    derekr 43208 (5/12/2012)

    Perry Whittle (5/12/2012)

    derekr 43208 (5/12/2012)

    Regarding Storage: Am I right in that SQL 2012 HA Features doesn't make use of shared storage?

    From what I understand, it uses...

    May 12, 2012 at 10:32 am

    #1486770

  • RE: SQL 2012 High Availibility

    Perry Whittle (5/12/2012)

    derekr 43208 (5/12/2012)

    Regarding Storage: Am I right in that SQL 2012 HA Features doesn't make use of shared storage?

    From what I understand, it uses Failover Clustering, without the...

    May 12, 2012 at 9:52 am

    #1486762

  • RE: SQL 2012 High Availibility

    Perry Whittle (5/12/2012)

    derekr 43208 (5/12/2012)

    Which configuration Provides Database Level redundancy including Hardware Redundancy(Clustering)

    Thanks

    AlwaysOn availability gropus provide redundancy at the database (or a group databases) level.

    How is this different from Mirroring/Log...

    May 12, 2012 at 9:49 am

    #1486761

Viewing 15 posts - 556 through 570 (of 758 total)