Forum Replies Created

Viewing 15 posts - 2,761 through 2,775 (of 9,253 total)

  • RE: AlwaysON Secondary Full backup?

    ramana3327 (11/13/2014)


    Hi All,

    We are also in the process of migrating to Sql 2014 and setting up always on.

    We are concerning about the normal full backup on Alwayson.

    Correct me if I...

  • RE: FCI and Availability Groups

    Brandie Tarvin (11/12/2014)


    I'm getting this last bit from MSSQLTips:

    this statement seems in direct contradiction to an article Perry Whittle published on this site.

    If you scroll down the MSSQL Tips article...

  • RE: Windows Server 2012 R2 Failover Cluster Question

    when the cluster comes back online the first available node will grab the resources.

    If you know you're gioing to have an outage such as that it would be more prudent...

  • RE: SQL Server Cluster : Backup the quorum drive

    with the current quorum configurations available you ideally wont be using a quorum disk, this is the single point of failure. No need to back up the disk as the...

  • RE: Windows Server 2012 R2 Failover Cluster Question

    dajonx (11/13/2014)


    Hi,

    We are running SQL Server 2008 R2 on a two-node Windows Server 2012 R2 failover cluster.

    During unexpected network outages, we noticed that the failover cluster attempted to...

  • RE: FCI and Availability Groups

    Brandie Tarvin (11/12/2014)


    1) Both FCI and AG require windows clustering in order to work.

    Yes, both technologies require a functional Windows Server Failover Cluster.

    Note that you may also use an FCI...

  • RE: AlwaysON Secondary Full backup?

    Sathvik (11/13/2014)


    Thanks for your clarification :).

    Excuse me if I am asking basic question, why clearing DCM Page(full DB backup and Diff backup) doesn't support for readonly databases?

    Thanks.

    What would happen if...

  • RE: Database Schema creation date and user who created it.

    i don't believe that information is available

  • RE: Tempdb lost - but starting SQL Server with -m -f still fails

    John Langston (11/11/2014)


    SQL 2008 R2 - drive hosting tempdb was lost.

    Do you plan to replace the drive?

    If so, recreate the folder structure and apply the correct permissions for the service...

  • RE: Is Shrinking Log Files Good or Bad?

    scantoria (11/10/2014)


    This is interesting. Currently, our Diff runs every Wednesday and Full every Sunday.

    With once a week fulls i'd prefer more regular diffs

    scantoria (11/10/2014)


    Base on our current scenario, what...

  • RE: Backup and Restoration Time Issue

    balasaukri (11/11/2014)


    They are SAN drives! Not local drives.

    OK so engage the help of your SAN administrator and as previously suggested capture perfmon counters to check for throughput and latency.

  • RE: Moving and Data from One Table to Another

    BWFC (11/11/2014)


    I have a series of flatfiles that I need to import into my database. These files have a name format prefix1_Entity. There are a series of tables...

  • RE: SSMS Connection via IP issue

    Yuri55 (11/10/2014)


    I am afraid it's not an IP issue

    I havent said it is yet!!

    I've asked you to list out the IPs from the cluster group!!

  • RE: Backing up a production SQL Database

    why not just create unique backup file names by using either the date and time of the backup or the current LSN number??

  • RE: Backup and Restoration Time Issue

    balasaukri (11/11/2014)


    Perry Whittle (11/11/2014)


    is server B a virtual machine?

    Yes all are Virtual machines only in my Environment. Absolutely there is no physical servers.

    what is the back end storage configuration for...

Viewing 15 posts - 2,761 through 2,775 (of 9,253 total)