SQL Backup

Mike_B
Mike_B Member Posts: 25
edited 2006-02-15 in NAV/Navision Classic Client
We have 4 companies in one database running on SQL 2000 server.
I would like to make a SQL Backup for one not all of the companies.

I have done this many times using the Navision Backup Routine but not through SQL.

Please could anyone advise.

Thanks

Mike

Comments

  • IHateLinux
    IHateLinux Member Posts: 223
    Hi,

    i think this is impossible to do with standard SQL only backup routines.
    Because in the same database there are all tables and SQL does not know which table belongs to which company.

    The only way i can imagine to solve that is to put each company in a different database file, but i do not know exactly
    - how this works
    - if this is doable at all (because of some tables for all companies)

    The better way would be to run Navision Backup just selecting the company.

    HTH,

    Rainer
  • DenSter
    DenSter Member Posts: 8,307
    I don't think that is possible. The way this is implemented is that Navision creates a new set of company specific tables in the same SQL database. Navision can tell the difference between companies, but I don't think SQL Server can. Unless there is a SQL Server way to specify which tables to back up I don't think there is anything like that available.
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • kriki
    kriki Member, Moderator Posts: 9,121
    There might be a way, but it is a long and complicated one to do:
    You need a DB-file for each company and maybe also one for the company-independent tables.
    Then in SQL, you have to tell SQL in which to put EACH :!: table in the DB.
    After that you can backup a certain DB-file that in this case becomes a certain company.
    But to be honest. Better don't do it. It is difficult to maintain and you have to change the properties of each table from SQL and this last thing can create problems with Navision.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • Mike_B
    Mike_B Member Posts: 25
    Thankyou all for you replies. Never mind i'll have to go along with what is currently available.
  • Bernt
    Bernt Member Posts: 4
    Why dont you give each company a database of their own? Wouldnt this solve you problem?

    Regards Bernt
  • bbrown
    bbrown Member Posts: 3,268
    Why dont you give each company a database of their own? Wouldnt this solve you problem?

    It would also violate their license agreement with Microsoft/Navision.
    There are no bugs - only undocumented features.

Categories