Forum Replies Created

Viewing 15 posts - 3,301 through 3,315 (of 9,244 total)

  • RE: Changing Availability Group

    Ratheesh.K.Nair (5/6/2014)


    Hi Experts,

    How can we change the backup replica in Always on Cluster.

    I'm assuming you mean AlwaysOn availability group?

    What are the current backup settings you have defined for your AlwaysOn...

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

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

  • RE: Read only on secondary Replica

    then your application intent is not readonly is it 😉

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

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

  • RE: BAckup's not completing 100%

    Lowell (5/5/2014)


    for example, if i use red gate to generate a job for backing up my db's, it lists the of six specific databases, so new databases do not get...

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

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

  • RE: Mirroring - Intermittent "network name is no longer available"

    PianoDan (9/9/2013)


    But I don't see a message that the principal lost contact with the witness.

    If it had the Principal database would have gone offline, did this happen at all?

    You may...

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

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

  • RE: SQL 2012 AlwaysOn Group Configuraiton Issue.

    sheeraz.khan (5/5/2014)


    Dear Gurus,

    Hope all is well. i am confronting one error while configuring the SQL 2012 AlwaysOn Group after the summary windows.

    Creating logins Results in an error(Microsoft.Sqlserver. Management.Hardr...

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

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

  • RE: How to create a SQL 2012 Failover cluster using VMs?

    APA0876 (5/5/2014)


    Hi thanks before everything!, I have the following question that I hope you can oriented me:

    How to create a SQL 2012 Failover cluster using VMs?

    Thanks

    APA

    Check my guide on this...

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

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

  • RE: AlwaysOn - use an Availability group listner or just point to the Cluster name

    winston Smith (5/6/2014)


    The always on front end currently is set up incorrectly and is referencing NodeA (primary node) for its database.

    I want to fix this but im unsure if i...

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

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

  • RE: Read only on secondary Replica

    mxy (5/5/2014)


    Assume if i have a connection(Application intent readonly) starts with reading, writing and again reading data for a report. how it will works in SQL 2014 Always availability on?

    With...

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

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

  • RE: log shipping with read only mode?

    Ashif Shaikh (5/6/2014)


    Hi experts,

    we are about to start a logshipping with the secondary server in read only mode.

    I just wanted to know the disadvantages of using a read only...

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

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

  • RE: Backup questions for 612GB database!

    Differential backups are reliant on the differential base LSN. This is changed during each full backup. A full backup may be followed by as many diffs as you need. As...

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

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

  • RE: Backup questions for 612GB database!

    akhamoshioke (5/5/2014)


    but the rely on the LAN from the last full to work don't they?

    No they don't, as Gail said they're based on the LSN from the last log backup.

    akhamoshioke...

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

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

  • RE: Large database migration best practices

    DBA_Learner (5/4/2014)


    HA?

    DBA_Learner (5/4/2014)


    Based on previous statistics when we did maintenance it took approximately 14 hours to complete the maintenance tasks. I am not sure if business teams can...

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

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

  • RE: Large database migration best practices

    DBA_Learner (5/3/2014)


    We are planning to move 3-4TB of databases to new environment. Can someone explain some best practices. What should we supposed to take pre and post considerations. Looking for...

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

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

  • RE: Encrypting data from Oracle to MS SQL over WAN

    Is the oracle database on unix or windows?

    Both sql server and oracle have their own TDE feature but that wont encrypt the comms point to point. Best way would be...

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

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

  • RE: Backup questions for 612GB database!

    glynn.seymour (5/2/2014)


    Wooooooh... vCenter snaps aren't backups. No way.

    Permanent snapshots can indeed be problematic.

    +1, Theyre always misused, snapshot disks, back them up then remove snapshot.

    This is exactly how...

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

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

Viewing 15 posts - 3,301 through 3,315 (of 9,244 total)