Forum Replies Created

Viewing 7 posts - 1 through 7 (of 7 total)

  • RE: SQL Server 2005 Adoption

    Personally I think the survey should be broken into two separate sections. One section for SQL software vendors (i.e. the people who build the non-inhouse software solutions to be sold...


    Kindest Regards,

    Gareth

  • RE: sql 2000 to sql 2005 upgrade

    Just as a heads up warning (which I presume you already know - but just in case!), you really need to performance test the upgraded server. I'm experiencing a significant...


    Kindest Regards,

    Gareth

  • RE: How to Restore POS System to SqlServer 2000

    All of the above options are good, and there are a number of mechanism to physically achieve this depending on cost & paranoia needed (ranging from log backups, RAID/SAN drives,...


    Kindest Regards,

    Gareth

  • RE: Best Practice

    There are many ways to achieve this, but in 'normal' (what ever that is 🙂 ) 2000 environments logshipping is probably the least invasive solution and best solution. It all...


    Kindest Regards,

    Gareth

  • RE: NoSync subscriptions will need to be dropped and recreated

    I think you will find that although your publication didnt have the expiration, the distribution database probably did!

    If you go to 'Replication Monitor', right click, select 'Distributor Properties', select your...


    Kindest Regards,

    Gareth

  • RE: Anonymous Pull Subscription Security Question

    This is a cut and paste of what we do. Attach & Go subscriptions by default use SQL authentication regardless of the security setting from the original database. The key...


    Kindest Regards,

    Gareth

  • RE: Adventures in Replication

    There is a often underlooked replication option available in MSSQL 2000 called "Attach & Go", this allows you to take a local replicated database and "Attach" it to a remote...


    Kindest Regards,

    Gareth

Viewing 7 posts - 1 through 7 (of 7 total)