by Hello,
Using SQL 2000 with SP2
I have the following scenario
1. Server should be available 24 X 7. No down time
2. Two types of Data. One Set of Data is Read/Write.
Another set of Data is read only. This data is used mainly for
report queries.
3. Every day read only data is overwritten by new sets of data through
an extract.
I am thinking of setting up the server and database as follows
1. Read/Write database (set of tables) in One Server. Say A
2. Two Read only Databases (say B and C) in another server. Another
server is required because of the time taken while converting extract
(about 300 Gig) to read only data is high.
3. Data will be extracted to B and C every alternate day. Since Users
will be on the site 24 X 7 It is not possible to extract to the
same Read Only Database.
So two databases B and C are needed .
4. Once extraction is over, I need to flip the Read only Databases
(between B and C) so that latest data should be available to new users
who log in. Users who are already logged in will continue to work in
the old Read only Database.
For example: Let us say users U1, U2 are already on the site and using
read only Database B, and new data is extracted to Read Only Database
C, and a new user U3 logs in after extraction to C is complete, he
should be connected to C, while users U1 and U2 can continue to work
in B until their session terminates.
Queries
--------
1. How to set up the servers/databases for this scenario?
2. How to flip databases (DSN, application connection) to new users,
while old users continue to work with
Old database. How this can be achieved transparent to the users
Thanks
M A Srinivas