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...

  • 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...

  • 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,...

  • 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...

  • 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...

  • 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...

  • 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...

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