how to make distributed database in SQL server 2008?

  • hello,

    I am using SQL SERVER 2008. I want to make distributed sites for my project. can anybody help me to this matter?

    and also i want sample dataset for my project . can anybody provide me the dataset?

    thanks .

  • SQL Server doesn't do scale-out (distributed systems) at all well.

    What are you trying to do and why?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • That's a big topic and not one that's going to be answered well within a forum post like this. I'd suggest starting out reading this article from the SQL CAT blog. There's probably more up to date information on this topic, but I wanted to make sure that what you saw was applicable to 2008. It'll get you started.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply