Forum Replies Created

Viewing 15 posts - 4,561 through 4,575 (of 9,244 total)

  • RE: Mirroring configure HA and DR

    sorry, but you have totally lost me here. The out put you posted shows the restore with 1 file found and 1 file restored, what is the issue you are...

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

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

  • RE: Mirroring configure HA and DR

    ananda.murugesan (11/26/2012)


    Please verify and suggestion need to be modify the LSRestore logs in secondary servers and database standby mode..

    Sorry, i dont understand what it is you require!

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

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

  • RE: SNAPSHOT Isolation with (NOLOCK) being used all over

    Doesn't stop you creating the policies in your dev system, they'll be ready to deploy in Jan then 😉

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

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

  • RE: Suggestions to replace DBCC INDEXDEFRAG

    DKlein (11/26/2012)


    We currently use DBCC INDEXDEFRAG to defrag indexes over 25% fragmentation. We are a 24/7 shop and I would need to replace it with a process that is 'online'...

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

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

  • RE: SNAPSHOT Isolation with (NOLOCK) being used all over

    To ensure in the future that the option persists you could use policy management to create a new policy enforcing the snapshot isolation state. You'll need to select the Database...

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

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

  • RE: SNAPSHOT Isolation with (NOLOCK) being used all over

    SQL_ME_RICH (11/26/2012)


    This is what happens when I respond to posts before coffee - thanks for that Gail!

    :crazy:

    😉

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

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

  • RE: sql server express 2008 express wont start

    Spooky huh!

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

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

  • RE: Transaction log files had grown to five times the database size.

    sanath.kumar.kura (11/26/2012)


    If i changed the frequency it would solve the issue.

    Not on its own but it's a start!

    The links posted will guide you further

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

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

  • RE: witness server

    shohelr2003 (11/26/2012)


    actually witness server is an optional requirement in mirroring. If you choose "High Safety With Automatic Failover" option, then you need a witness server.

    It's an option for Syncrhonous mirroring,...

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

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

  • RE: sql server express 2008 express wont start

    as a side note, have you changed any CPU settings in the BIOS, the reason i ask is because the stack dump occurs right after CPU detection

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

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

  • RE: Database master key and symmetric keys protection

    The database master key is itself a symmetric key. Assymetric keys provide increased security, the symmetric key is purely used to protect the main (or Assymetric key) while it is...

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

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

  • RE: Network ip

    you can also use xp_regread to query the apprpriate registry values for your SQL server instance.

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

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

  • RE: How to check mirrored database

    shohelr2003 (11/26/2012)


    Thank You, Perry Whittle. But what does "database will be totally out of sequence" mean?

    The LSNs and hence restore points will be completely different between databases, it would make...

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

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

  • RE: Error after changing the Domain

    mahesh.dasoni (11/24/2012)


    We have SQl Server 2005 Standard edition which was Intially on another domain at that time it was working fine.

    Now when it been moved to another domain we are...

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

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

  • RE: SNAPSHOT Isolation with (NOLOCK) being used all over

    SQL_ME_RICH (11/21/2012)


    Recently, my applications architect decided that we needed to change the level of the database Isolation from the the default READ COMMITTED to SNAPSHOT ISOLATION (basically Read Committed with...

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

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

Viewing 15 posts - 4,561 through 4,575 (of 9,244 total)