Forum Replies Created

Viewing 15 posts - 3,331 through 3,345 (of 9,244 total)

  • RE: Transport-level error referring to "network name is no longer available" - but not referring to name...

    Is the instance of sql server a named instance or default instance?

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

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

  • RE: one db versus multipl dbs

    dexdev (4/28/2014)


    We are looking into setting up a cluster, but we are getting mixes opinions on whether to convert all our individual databases (about 5000) to one big individual database,...

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

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

  • RE: System Database restores vs rebuild

    andrew gothard (4/28/2014)


    Bear in mind, the server you restore to should be exactly the same (version, sp possibly even cu, but I'd not swear to that one) as your old...

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

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

  • RE: System Database restores vs rebuild

    karend211 34657 (4/28/2014)


    Why would you need a new server just because sql server won't start??

    I am thinking worst case scenario & want to be prepared & have a plan for...

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

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

  • RE: System Database restores vs rebuild

    karend211 34657 (4/25/2014)


    I need to better understand under what circumstances you would rebuild versus restore the system databases?

    If you wanted to change the system collation.

    karend211 34657 (4/25/2014)


    I brought up a...

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

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

  • RE: What's involved in changing the collation of a database ?

    You'll also need to drop any constraints on the columns before you alter them, see books online for more detail

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

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

  • RE: Encryption of Data At Rest - SQL 2005 Enterprise

    SQL!$@w$0ME (4/24/2014)


    All,

    I have an urgent requirement to implement encryption (Data at rest) for our SQL 2005 instance. Please let me know your thoughts if I can accomplish this through SQL...

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

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

  • RE: SQL Server 2008 R2 in hung state. Need help in analyzing the log.

    are you using shared storage?

    in one scenario previously, i had a set of LUNs presented to server A and it turned out they shared storage pools with another server B....

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

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

  • RE: Error installing MS SQL Server R2 Enterprise (x64)

    please provide futher info from this file

    C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20140417_191232\Detail.txt

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

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

  • RE: Standby & NoRecovery

    lilywhites (4/22/2014)


    Each restore in the chain is running using the STANDBY file....i was wondering if we could remove these STANDBY commands and just use it at the end of the...

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

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

  • RE: Standby & NoRecovery

    lilywhites (4/22/2014)


    recently we have been having connections getting through in-between the log restores and causing issues.

    What issues have you been experiencing?

    Can you post the output of the following query run...

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

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

  • RE: Availability Group Failover Stops Working After First Failure.

    this is the default setting for all cluster resources, just something to be aware of

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

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

  • RE: Instance failover failing in Cluster

    Benki Chendu (4/21/2014)


    Yes. It is listed as a possible owner..

    possible owner of which resources?

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

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

  • RE: Instance failover failing in Cluster

    Benki Chendu (4/21/2014)


    Perry Whittle (4/20/2014)


    Benki Chendu (4/19/2014)


    I am getting the following error when I am trying to failover an instance to another node:

    The operation failed because either the specified cluster...

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

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

  • RE: Automating Database Restores

    Why not just use log shipping, seems it would be perfect for this scenario.

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

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

Viewing 15 posts - 3,331 through 3,345 (of 9,244 total)