Forum Replies Created

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

  • RE: How to rename a SQL Server 2005 Failover Clustered instance

    In failover cluster manager, expand the virtual network name resource and the virtual IP resource will be there.

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

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

  • RE: 2nd Live Copy

    mike 57299 (12/10/2012)


    Yes, the data in a writable state is a must. That is why mirroring and log shipping won't work.

    Mike

    It wasn't stated hence my question, now that we...

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

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

  • RE: move db files to another directory

    sqlfriends (12/10/2012)


    Perry Whittle (12/5/2012)


    Stopping sql server is a bit like using a sledge hammer to crack a nut. You only need to take the database offline as follows

    ALTER DATABASE mydb...

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

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

  • 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" 😉

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