Greg, Practix might be a good example for you to look at then.
They use the Default Instance (1 SQL server), but they have 3 databases that they use. Mspdata - This stores the completed data - can get large Msplocal - This is temporary data, such as appointments etc - should be relatively small Mspref - This is Data like Item Codes, Bank Details, and other Static data. - will be small The application uses all 3 Databases which all have a 2 gig limit giving them the ability to address 6 gig theoretically, getting around the 2gig restriction. Clearer ?? Regards Bazza -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Greg Twyford Sent: Thursday, 2 February 2006 10:50 AM To: General Practice Computing Group Talk Subject: Re: [GPCG_TALK] File repair utility in MD2 Barry Lollo wrote: > Greg, > > In MS SQL server 2000 you can have up to 16 instances installed on the > one PC. > > In essence, and Instance is another SQL Server. > > Example: > My computer name is "SERVER", then the default instance (or SQL > SERVER) would be referred to as SERVER when configuring the connection > details in your application. Inside that SQL Instance we can have many > databases. > When one installs Pracsoft, you must have an Instance (2nd SQL Server > installation potentially....I'll qualify that later) called > "SERVER\HCNSYSTEM". > The 3rd installation of SQL server in that PC would be called > "SERVER\<instancename>" whatever you want to call it. > So when configuring your application to talk to an SQL server you > would refer to its Instance. > Each of them can be stopped and started independently as they are all > individual SQL servers. > Qualifying that statement before, one can install the 1st installation > of SQL server on a PC and call it "SERVER\HCNSYSTEM". > > We can have an situation where the default Instance "Server" is SQL > 7.0 We can have out 2nd Instance as SQL 2000 Service Pack 2. > We can have our 3rd Instance as SQL 2000 Service Pack 4. > > I suspect, but haven't tested it yet, but our 4th Instance could > probably be SQL 2005. > > Oracle and other products in the same vein have a similar strategy > available. > > I hope that clears it up. Barry, Yes and no, its a nice internal explanation of some of the complexities of MS SQL, and the \SERVER\HCNSYSTEM structure is familiar to me. What I'm still not clear about is that if you have a database for MD3, can you have more than one instance for it in order to increase the available database capacity, say by breaking up parts of the application's table structure into different instances? Is this how you can get around the alleged 2 GB database limit? The discussion related to data volume, and it seems you can have multiple database engines addressing multiple applications simultaneously, but that still doesn't explain how a single application like MD3 would have its data handled. Greg -- Greg Twyford Information Management & Technology Program Officer Canterbury Division of General Practice E-mail: [EMAIL PROTECTED] Ph.: 02 9787 9033 Fax: 02 9787 9200 PRIVATE & CONFIDENTIAL *********************************************************************** The information contained in this e-mail and their attached files, including replies and forwarded copies, are confidential and intended solely for the addressee(s) and may be legally privileged or prohibited from disclosure and unauthorised use. If you are not the intended recipient, any form of reproduction, dissemination, copying, disclosure, modification, distribution and/or publication or any action taken or omitted to be taken in reliance upon this message or its attachments is prohibited. All liability for viruses is excluded to the fullest extent permitted by law. *********************************************************************** _______________________________________________ Gpcg_talk mailing list [email protected] http://ozdocit.org/cgi-bin/mailman/listinfo/gpcg_talk _______________________________________________ Gpcg_talk mailing list [email protected] http://ozdocit.org/cgi-bin/mailman/listinfo/gpcg_talk
