Forum Replies Created

Viewing 15 posts - 2,401 through 2,415 (of 9,241 total)

  • RE: Script to add a server login to multiple databases

    johnnyrmtl (2/9/2015)


    Hello all,

    I have migrated over 700 databases to another server and now I have to add a specific user to all these databases and sync , would anyone have...

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

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

  • RE: cluster failover

    sorry I don't follow what youre saying

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

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

  • RE: cluster failover

    ramyours2003 (2/9/2015)


    in most scenarios we will failover the node to another node . what happens internally when we failover the cluster from one node to another node .

    When you...

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

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

  • RE: Log Shipping

    Nita Reddy (2/6/2015)


    I need to do maintenance on production server and make DB as simple recovery mode for some reason, that DB is setup as Log shipping and I have...

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

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

  • RE: convert litespeed log shipping backup, copy and restore jobs to native sql logshipping jobs

    you'll need to drop the Litespeed LS plan and recreate it natively. This really isn't hard to do if you understand LS

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

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

  • RE: Bringing availability group's online during a quorum failure

    Adam Bean (2/6/2015)


    Thanks Perry.

    Don't have the article handy (on the road) but I had read that an async DR node shouldn't have a vote. Is that not accurate?

    The node...

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

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

  • RE: High Availability Group Transaction Log Shrink

    sorry, can you supply exact details of what you're doing and show a screenshot of the message

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

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

  • RE: Bringing availability group's online during a quorum failure

    Adam Bean (2/5/2015)


    Hey Perry,

    - The real world setup is that I'll have two nodes in one data center, with a file share witness and another node in a separate data...

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

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

  • RE: SSIS Issues after Master DB Corruption - "Please Recreate Master Key" When Running Package

    presumably the original Visual Studio projects are stored securely somewhere

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

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

  • RE: SSIS Issues after Master DB Corruption - "Please Recreate Master Key" When Running Package

    JoshDBGuy (2/5/2015)


    Could not, inherited system, issue with master backup restore process. It was a nightmare.

    so when you inherit a system always check that critical backups are in place

    JoshDBGuy (2/5/2015)


    Luckily it's...

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

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

  • RE: SSIS Issues after Master DB Corruption - "Please Recreate Master Key" When Running Package

    JoshDBGuy (2/5/2015)


    Unfortunately it had to be rebuilt.

    Once you rebuilt the system databases you should have restored master from a backup, I'm guessing you didn't?

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

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

  • RE: SSIS Issues after Master DB Corruption - "Please Recreate Master Key" When Running Package

    what exactly did you do to fix your master db corruption?

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

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

  • RE: Migrating VLDB to Availability Group

    gwellbrock (2/5/2015)


    Yeah I am restoring the TDE cert sorry for not mentioning. Unless I am crazy when migrating from 2008 to 2012 you have to back up the database...

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

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

  • RE: Migrating VLDB to Availability Group

    gwellbrock (2/4/2015)


    The database takes 4 hours to backup after tuning extensively(I hate TDE!!)

    Yep, unfortunately TDE negates backup compression 😉

    gwellbrock (2/4/2015)


    the issue comes from having to backup the database before adding...

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

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

  • RE: Bringing availability group's online during a quorum failure

    Adam Bean (2/4/2015)


    Hey all,

    Experimenting in a local lab with an always on setup and have some questions. The setup is pretty easy. 3 node cluster with a file share witness.

    If...

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

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

Viewing 15 posts - 2,401 through 2,415 (of 9,241 total)