Forum Replies Created

Viewing 15 posts - 3,106 through 3,120 (of 9,241 total)

  • RE: clustering Vs Mirroing Vs Logshipingf Vs replication

    need to know a bit more about your requirements first, as well as answers to the following

    Network connection between sites

    Hardware available

    DR databases to be readable or offline

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

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

  • RE: Questions on Implementing TDE

    lallu_jaya (8/5/2014)


    @perry Whittle

    Thanks soo much for your reply. I was very confused regarding the concepts. your answers addressed all the questions.

    This article may help you too http://www.sqlservercentral.com/articles/Transparent+Data+Encryption+(TDE)/91712/[/url]

    lallu_jaya (8/5/2014)


    1. Is...

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

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

  • RE: cluster installation

    the most notable are

    sql server 2008 now supports service based SIDs for clustered installations when installing on Windows 2008 and above, instead of the old AD based group config used...

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

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

  • RE: Questions on Implementing TDE

    lallu_jaya (8/5/2014)


    Question 1:

    I tried moving a TDE database to another server. I only needed a backup and restore of Certificate and the Private key associated with the Certificate.

    I did...

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

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

  • RE: sql 2014 --jobs

    muthyala_51 (8/4/2014)


    Can we stop and start sql server agent based on AG failover ? Instead of editing all the jobs/job steps to check which one is primary before running, it...

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

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

  • RE: cluster installation

    jamessdba (8/5/2014)


    Hi,

    Please give the cluster Installation Differences from 2005 to 2008/R2 for a SQLDBA.

    & What are the changes.

    Thanks in advance.

    Cluster installation has changed radically. SQL server cluster installations are now...

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

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

  • RE: question on cluster private and public network

    vsamantha35 (8/2/2014)


    When the private network goes down cluster communications will carry on through the public network. Loss of a private network does not initiate a failover. The loss of the...

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

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

  • RE: Moving SQL Server DB's

    Like2SQL (7/31/2014)


    We have a SQL Server located in India; We need to move all the DB's on that server to a server residing locally for various legal reasons. The Server...

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

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

  • RE: configure log shipping in sql server 2008 between two different domains

    Where you can't trust domains treat the servers like a workgroup and follow my guide at the link provided 😉

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

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

  • RE: log shipping job failing

    grkanth81 (7/31/2014)


    HI guys,

    I am having a LSAlert_Serv job and this job runs the system stored procedure sys.sp_check_log_shipping_monitor_alert. when this job is run I am getting the following error message:

    Here...

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

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

  • RE: configure log shipping in sql server 2008 between two different domains

    annam.dba (7/31/2014)


    Hi,

    There is a requirement to one of our client to configure log shipping between two different domains, Is there any way is there ? could you please help...

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

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

  • RE: Mirror database stuck-in-restoring-state

    lescobar (7/30/2014)


    Hello everyone

    I have two sql servers

    It is setup as a mirror databases

    1) database 1(principle, synchronized)

    2) database 2 (Mirror, Synchronized / Restoring)

    I do not know how this happen

    Someone...

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

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

  • RE: AlwaysOn AG failed over changed sql user passwords???

    If you ran sp_help_religion on a 2008 instance and moved to 2012 the passwords would be lost due to the changes in encryption.

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

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

  • RE: AlwaysOn AG failed over changed sql user passwords???

    lkennedy76 (7/30/2014)


    When they were created about a month ago, I used sp_help_revlogin. I scripted out the users on the old server, created on the primary node, used sp_help_revlogin to get...

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

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

  • RE: VIEW SERVER STATE permssion.

    Grant Fritchey (7/30/2014)


    Pretty sure the key word there is VIEW, but we could also add STATE. Same thing with VIEW DATABASE STATE.

    😀 clearly those terms are confusing!

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

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

Viewing 15 posts - 3,106 through 3,120 (of 9,241 total)