Forum Replies Created

Viewing 15 posts - 3,181 through 3,195 (of 9,241 total)

  • RE: Question about initial backup for Log Shipping

    david 81886 (7/9/2014)


    Thanks Guys, I think I figured out what's happening. The restore job is skipping all the log files. I believe this is occurring because there is...

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

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

  • RE: Question about initial backup for Log Shipping

    david 81886 (7/8/2014)


    Thanks guys... so I did the manual backup/restore w/ No Recovery and then setup log shipping. All seemed to proceed without error. However, I'm not sure...

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

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

  • RE: Is is possible to run 2008 R2 and 2012 SP1 instances in the same cluster?

    Richard Bates (7/7/2014)


    Just out of interest, why would it be best to install the oldest instance version first?

    It was really only an issue with systems that had sql server 2000...

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

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

  • RE: cluster

    ramyours2003 (7/5/2014)


    how to install active\active cluster in sql2008?

    The same way you normally install a clustered instance. Active\Active is no longer used by Microsoft, multi instance clusters can run all on...

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

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

  • RE: Is is possible to run 2008 R2 and 2012 SP1 instances in the same cluster?

    Richard Bates (7/7/2014)


    Hello,

    We have a three node 2012 enterprise cluster currently running several 2012 instances.

    Is it recommended to run a 2008 R2 instance in the same cluster?

    Thanks.

    R.

    Yes you can have...

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

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

  • RE: Cost threshold for parallelism - Subtree Cost

    Lempster (7/3/2014)


    Where do you get these nuggets of information from Gail? 🙂

    Paul Randal 😉

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

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

  • RE: SQL 2012 AlwaysOn Read-Intent Secondary

    faisalfarouqi (7/3/2014)


    Do you have a script to check if it's primary or secondary? Could you pls. post it in case if you have one.

    Regards,

    Faisal

    This will pull the Primary replica for...

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

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

  • RE: Question about initial backup for Log Shipping

    Neeraj Dwivedi (7/2/2014)


    Keep in mind that that you have to restore DB with No Recovery option on DR site.

    Or standby\readonly

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

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

  • RE: SQL 2012 AlwaysOn Read-Intent Secondary

    sounds like the secondary is not set read only, check this and post back

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

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

  • RE: Enable\Disable AG Listener

    The listener cannot actually be stopped or started, it can be deleted or restarted. If you stop the IP or VNN cluster resources you'll take the AlwaysOn group offline so...

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

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

  • RE: How to take the backup of 700gb with less time

    GilaMonster (7/1/2014)


    As for making the backup faster...

    First check the throughput of the backup device. Backups are IO-bound operations, if either the source (drive with the data files) or destination (drive...

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

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

  • RE: Query to check for current database backup?

    RD Francis (6/30/2014)


    The problem is that, once every week or two, our outsourced DBA team decides that they need to shift the DB into SIMPLE recovery mode, and back to...

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

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

  • RE: point all transactions and activity to new database file so old one ceases to grow

    Jeff Moden (7/1/2014)


    I believe that if you simply add another file to the file group, it will use that new file until both files balance.

    Unless the first file is full,...

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

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

  • RE: urgent SQL query to delete table data and shrink after

    Sean Lange (6/30/2014)


    Craig G (6/30/2014)


    2. sorry on second question,its .NDF file not .LDF .

    Pretty sure you mean MDF unless you use your own extensions.

    No, a secondary database file...

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

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

  • RE: Log Shipping - Error: Logon failure: unknown user name or bad password

    miaka102 (6/30/2014)


    I am trying to set up a log shipping in my primary db server, then I encounter this error messages,"Error: Logon failure: unknown user name or bad password".

    At exactly...

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

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

Viewing 15 posts - 3,181 through 3,195 (of 9,241 total)