Forum Replies Created

Viewing 15 posts - 6,691 through 6,705 (of 9,241 total)

  • RE: Clustering Performance

    More importantly the OP hasn't provided details of the storage on the stand alone server which i'm asuming is using local disks unless told otherwise

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

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

  • RE: Misaligned disks but the disk is dynamic with 2 partitions.

    Could you execute the following and return the results for disk6

    wmic partition get BlockSize, StartingOffset, Name, Index, type, primarypartition

    robster (8/31/2011)


    I have a dynamic disk (4.5TB) in size which is SAN...

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

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

  • RE: Misaligned disks but the disk is dynamic with 2 partitions.

    Do you have the diskpart commands to create the new partitions

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

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

  • RE: log shipping from SQL 2000 to SQL 2008 in order to keep the tow databases in sync

    Sql server 2000 standard does not support log shipping!

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

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

  • RE: log shipping from SQL 2000 to SQL 2008 in order to keep the tow databases in sync

    What edition is your SQL 2000 instance?

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

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

  • RE: log shipping from SQL 2000 to SQL 2008 in order to keep the tow databases in sync

    Ok but if you log ship between 2000 and 2008 the database can only be in restoring mode!!!

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

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

  • RE: log shipping from SQL 2000 to SQL 2008 in order to keep the tow databases in sync

    Ok so if youre moving a copy to dev why are you log shipping it? The log shipped database will not be in a state that will allow access to...

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

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

  • RE: Misaligned disks but the disk is dynamic with 2 partitions.

    if you're going to wipe the partition and format it, change the disk from Dynamic to Basic before creating the new partition!

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

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

  • RE: log shipping from SQL 2000 to SQL 2008 in order to keep the tow databases in sync

    why would you want a dev database that is in restoring state?

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

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

  • RE: Database Mirroring - Error 1418

    So if you dont have a domain where are you getting this from????

    Marcondes Josino Alexandre (8/30/2011)


    SET PARTNER = 'TCP: / / fortes01.secran.com.br: 1400'

    To set up mirroring for a workgroup you...

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

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

  • RE: Database Mirroring - Error 1418

    Marcondes Josino Alexandre (8/30/2011)


    Hello everyone, how are you?

    I am deploying SQL Server 2005 Database Mirroring here at the University with a database with compatibility level 80 where we as an...

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

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

  • RE: Dont see Transaction log shipping option under properties under database properties.... why?

    Please execute the folowing against your instance and post the result

    select SERVERPROPERTY('edition')

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

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

  • RE: Backup and old file delete GOTCHAs!

    jpSQLDude (8/30/2011)


    all I can do is warn them repeatedly that they are setting themselves up for failure, and keep my fingers crossed (and save a month's worth of backups locally...

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

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

  • RE: SQL Server 2008 R2 Database Mirroring

    a failover is entered into the sql server log on the principal. You could capture these events and act on them. Messages will be something along the lines of


    The mirrored...

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

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

  • RE: How to Build a Windows Server 2008 Failover Cluster on Cheap Hardware for a Home Lab

    okbangas (8/30/2011)


    or you can try the iSCSI target in FreeNAS.

    that's exactly what my guide uses 😉

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

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

Viewing 15 posts - 6,691 through 6,705 (of 9,241 total)