• Hi,

    1. Are you hosting the database? If no, then customisable databases, but do it this way default schema for base application client schema for client based customisations. . If you are hosting then the same schema setup applies.

    2. DR - If you are hosting there are a multitude (2) of DR options available to you:

    mirroring

    log shipping

    3. Recovering to point in time for a single client on a shared database-

    Daily database backups and hourly transaction log backups

    Restore the database to a new database and location.

    Backup production DB.

    Copy data from new DB to Prod for client only.

    Hope this helps.

    Cheers

    Jamie

    We are the pilgrims, master.
    We shall go always, a little further.