Re: ASA9 and multiple databases: best practise?

Ant Zucaro schrieb am 25.08.2006 15:06:
Claus,

Is this a question of how many databases to have per server, or how
many databases per engine (and what is easier with regards to
maintenance)?

Hi Ant,

thanks for time. No, it's not a question of the amount of databases (or,
say, the limitations of ASA9), it's a question of what to prefer: one
engine for each database or one engine driving many databases. Any why
to prefer - technically and, well, maybe legally. Admittingly, I can't
see any benefit in maintenance by having several databases in one
engine. Feel free to open my eyes.

Regards,
Claus.
.

Relevant Pages

  • best solutions : sql server replication (Maintenance)
    ... and after maintenance has been completed ... replicated back to production server. ... these 10 databases will have schema changes monthly. ...
    (microsoft.public.sqlserver.replication)
  • Re: Application error
    ... Monthly wise i have scheduled for all databases. ... Do you have any maintenance in place on the database? ... we are getting this error in previous server also for so many ... Yesterday end users got a error while uploading batches into SQL ...
    (microsoft.public.sqlserver.server)
  • info and questions on conversion to A03
    ... client databases to Jet4 and then using Access to convert to Access ... Of course, once converted, Access97 can no longer read the database. ... "Engine"? ... It bombs the first time it tries to open the ...
    (microsoft.public.vb.database.ado)
  • Re: ASA9 and multiple databases: best practise?
    ... The databases and the number of engines aren't directly related. ... database with an engine. ... You can affiliate tasks and CPUs to engines. ... Think of your server as a pool of tasks (one task per connection to the ...
    (comp.databases.sybase)
  • Re: Is MS Access A Toy?
    ... The Jet engine and the current Access 2007 DB engine that is derived from ... Jet are installed by default, and they are file-server database engines. ... Details of the difference between server and file-server databases have been ...
    (comp.databases.ms-access)