Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Administration (2000)  Multiserver

Author  Topic  TKFY Starting Member 1 Post Posted - 2000-09-25 : 08:43:31 Hi everybody! This is probably a very interesting subject for you all. I was wondering if it is possible to split a huge database over different computer-systems. By doing this, is it possible to query the databases parallel? This is the idea: - Main webserver without data - 2 SQL-servers with the exact same database-model but different data - An ASP-script querying both servers at the same time and waiting for results of both computers on the webserver. - Ordening the records and showing them as one list. To continu: is it possible to write to the database so the system adds the record to a server where there's still enough space, or a suggested server (passed via a command/parameter)? I hope there are people who want to share some thoughts with me! Thanks in advance, Wim