Forum Replies Created

Viewing 15 posts - 4,471 through 4,485 (of 9,241 total)

  • RE: Slow Full backup in SQL SERVER 2008 R2

    local disk or NAS\SAN based disk?

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

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

  • RE: 2nd Live Copy

    you want the data in a writable state presumably?

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

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

  • RE: High availability best practice?

    Martin Stephenson (12/6/2012)


    If I set up log shipping, the translogs are applied to the target database, if the source gets a new full backup, doesnt that break the log chain...

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

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

  • RE: Log Shipping failing when the primary DB is taken offline

    Perry Whittle (12/6/2012)


    and the results of the query i supplied above????

    ?????????????? :Whistling:

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

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

  • RE: Not able to connect db user in standby database

    ananda.murugesan (12/6/2012)


    yes..Thanks

    user apperaing in secondary instance database by atuomatically during restore log shipping process..But it won't connect the application due to login is not apperaing under security->Login, Does we...

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

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

  • RE: Log Shipping failing when the primary DB is taken offline

    GilaMonster (12/6/2012)


    Has the primary been restored from a backup?

    Questions, questions. It's like the Spanish inquisition here lol 😀

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

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

  • RE: Log Shipping failing when the primary DB is taken offline

    and the results of the query i supplied above????

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

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

  • RE: Not able to connect db user in standby database

    ananda.murugesan (12/6/2012)


    I have doubt..

    I think if this didn't work as designed Microsoft would have known about it by now 😉

    ananda.murugesan (12/6/2012)


    Log shipping process have been configured on the primary database...

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

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

  • RE: Download SQL Server 2012 64 bit Evaluation

    if you read the download instructions you are instructed to either

    • download full DVD ISO image and burn to disk
    • download the Lang.BOX Core.BOX and Install.EXE to a folder and extract the...

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

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

  • RE: Not able to connect db user in standby database

    ananda.murugesan (12/6/2012)


    Thanks for reply..

    I try to created new user & login on the secondary server instance, but still facing same issues...not able to create new user on the standby read-only...

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

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

  • RE: Log Shipping failing when the primary DB is taken offline

    Ravi-156610 (12/6/2012)


    We have Log Shipping setup on SQL 2008 instances and everything was running fine until the primary database was accidentally taken offline. We bought the DB online but noticed...

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

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

  • RE: Mount Point quick question

    Mount points are a standard feature of the NTFS file system and have been for some time. Mounted volumes are very common on Unix systems too.

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

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

  • RE: Setting up log shipping for multiple databases

    jmaikido (12/5/2012)


    Hi Stephen,

    I have the exact same requirement whereby I have been given the task to LS multiple databases. approx. 25 @ this stage. (SQL2008R2) As I'm not one for...

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

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

  • RE: Mirroring: revert principal database from snapshot

    F. Dwarf (12/5/2012)


    I have to run a script against a database, and my usual backout strategy would be to take a database snapshot and revert the database from it in...

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

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

  • RE: move db files to another directory

    sqlfriends (12/5/2012)


    Thanks, but it seems detach and attach is easier and involves less steps to do.

    Do whatever you feel comfortable with, just know that in SQL server 2005 on ALTER...

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

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

  • Viewing 15 posts - 4,471 through 4,485 (of 9,241 total)