Forum Replies Created

Viewing 15 posts - 6,541 through 6,555 (of 9,241 total)

  • RE: Sql Server 2008 Enterprise Evaluation Edition Expired!!

    p.van.der.zande (9/26/2011)


    how to solve it?

    Put the DVD disc into the drive, run the setup and upgrade the existing instance. Ensure you have backups first.

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

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

  • RE: Restore DB from SQL 2005 to SQL 2008

    Dan-Ketil Jakobsen (9/26/2011)


    and 1 TB for log.

    wow!

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

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

  • RE: Two Node Cluster Performance Improvement over single server ?

    isuckatsql (9/26/2011)


    What type of performance improvement could i expect from a two node cluster, running sql server 2008 r2 x64 enterprise, over just a single server.

    As Gail said, absolutely none....

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

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

  • RE: SQL Server 2008 R2 SP1 Installation - The cluster disk device name is not valid

    Is this a Windows cluster or a Veritas Cluster Server?

    Are you saying that you saved the SP executable to the C drive and ran it from there?

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

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

  • RE: SS08 SP2 w/ Compression - effectiveness varying wildly on a single table

    can you post the table definition

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

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

  • RE: Adding a node to Cluster - "No mapping between account names and security IDs was done."

    Dr Pliers (9/26/2011)


    How do I change the AD Group that I specified as part of the cluster security policy?

    so you used legacy group security and not Service SID based security?

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

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

  • RE: SQL Server 2008 R2 SP1 Installation - The cluster disk device name is not valid

    Try unpacking the SP to the local C drive and then execute the Setup from there

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

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

  • RE: A time-out occurred while waiting for buffer latch

    so now detail the other drives

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

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

  • RE: SQLServer becoming unresponsive

    what other software runs on this server?

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

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

  • RE: A time-out occurred while waiting for buffer latch

    Ok so can you supply more information regarding the d drive set up and file information for database id 5 as that is what the error is complaining about

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

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

  • RE: Migrating from one db to other

    Generally your vendor should be able to provide the mappings between the legacy database schema and the new database schema.

    IMHO, If they can't then one has to wonder what their...

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

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

  • RE: A time-out occurred while waiting for buffer latch

    could you please also return the results of the following query

    SELECTNAME

    , PHYSICAL_NAME

    , (size * 8) / 1024 as SizeInMBs

    , CASE max_size

    WHEN -1 THEN 'Unrestricted'

    WHEN 0 THEN 'NoGrowth'

    WHEN 268435456 THEN '2TBS'

    END...

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

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

  • RE: A time-out occurred while waiting for buffer latch

    Ok, for a start you should really be using

    ALTER INDEX ...........REBUILD

    ALTER INDEX ...........REORGANISE

    The drives for the tempdb are they local RAID. SATA or SAS, SAN based storage, .........?

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

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

  • RE: Unable to shrink temdb having lot of unallocated space internally

    this thread is 3 years old!! Theres nothing like raising the dead is there 😀

    Please start a new thread in future

    You may add the file without restarting

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

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

  • RE: A time-out occurred while waiting for buffer latch

    balasach82 (9/24/2011)


    we have tempdb in separate drive and 5 filegroups, primary, and log drives.. Any idea what the error means and how to avoid the 15 seconds error.

    can you give...

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

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

Viewing 15 posts - 6,541 through 6,555 (of 9,241 total)