Forum Replies Created

Viewing 15 posts - 2,011 through 2,025 (of 9,244 total)

  • RE: uninstall node

    how are you uninstalling the node?

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

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

  • RE: Set up AlwaysOn Replica for Reporting - Help needed

    SQL!$@w$0ME (6/18/2015)


    Servers are on the same site. But the 3rd node will not be configured for high availability, just for reporting (no vote for quorum?)

    If the servers are same site...

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

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

  • RE: Log shipping backup job is not writing log backup file

    Run this query on the primary, change the job name first, and post the output please

    SELECT j.name

    , jh.[step_id]

    , jh.[step_name]

    , jh.[message]

    ...

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

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

  • RE: Log shipping backup job is not writing log backup file

    antonio.estima 4150 (6/18/2015)


    The just only a error happens and its after after 60 minutes without the log backup job to generate the log's backup file. Part of the error message...

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

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

  • RE: AlwaysOn Availability Group Configuration Question

    thank you Johan for the correction 😉

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

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

  • RE: Log shipping backup job is not writing log backup file

    the log shipping backup job should be taking log backups and not full backups. Check the job step history and post here

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

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

  • RE: Set up AlwaysOn Replica for Reporting - Please help!

    answered here http://www.sqlservercentral.com/Forums/Topic1695309-3411-1.aspx

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

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

  • RE: How Do I check The "Always On Auto Failover" - In Which scenario ?

    so what have you done about cluster disk 1 and cluster disk 2?

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

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

  • RE: Set up AlwaysOn Replica for Reporting - Help needed

    SQL!$@w$0ME (6/17/2015)


    I would like to setup replica for one of the databases for reporting. The current environment is a 2 node cluster(active/passive). I would like to add a 3rd node...

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

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

  • RE: AlwaysOn Availability Group Configuration Question

    alex_pixley (6/17/2015)


    What I was given: a two-node Windows Server 2012 R2 WSFC to run SQL Server 2014 Enterprise with shared storage and a third (remote) Windows Server 2012 R2 machine...

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

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

  • RE: Copy Backup Files to Remote Shared Location & Delete them periodically

    To do the same in powershell only requires a few lines of code 😉

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

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

  • RE: Installing Reporting Services on a 2008 Failover Cluster

    simon.harvey 41170 (6/16/2015)


    Can anyone tell me if it is supported to install Reporting Services on both the active and passive nodes in an SQL Server Failover Cluster and use the...

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

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

  • RE: Adding T272 trace did not correct identity column 1000 jump

    Try these, no gaps

    -dE:\DATA\master.mdf

    -eE:\log\ERRORLOG

    -lE:\DATA\mastlog.ldf

    -T272

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

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

  • RE: How Do I check The "Always On Auto Failover" - In Which scenario ?

    please post the results of the following powershell query

    Get-ClusterResource | FL name,state,resourcetype,ownergroup,restartthreshold,restartdelay,restartperiod

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

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

  • RE: Please create a master key in the database

    the problem is not with the SMK the problem is with a DMK

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

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

Viewing 15 posts - 2,011 through 2,025 (of 9,244 total)