db seperation

I was given a task of doing the following and I'm not 100% sure what the
manager means. I'm not a database admin at all so I'm totaly new to all of
this. The manager wants me to seperate the transactional database from the
backend database.
What does that mean exactly? Can anyone provide me any information on what
exactly is and how to go about designing it then putting it into a working
mode?
thanksHe might mean that the 2 databases are 'transactional' and 'reporting/BI'
and should go on different servers, but who knows? We can help with
technical details but you'll need to clarify the requirements fully with the
manager first otherwise it's guesswork...
Cheers,
Paul Ibison|||Thanks, I'm in that process now actually to get more details on what she
actually wants done with the databases.
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:O6SNFx3rHHA.4180@.TK2MSFTNGP04.phx.gbl...
> He might mean that the 2 databases are 'transactional' and 'reporting/BI'
> and should go on different servers, but who knows? We can help with
> technical details but you'll need to clarify the requirements fully with
> the manager first otherwise it's guesswork...
> Cheers,
> Paul Ibison
>