SQL Backup

Mike_B

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

IHateLinux

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

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.

kriki

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.

Mike_B

Thankyou all for you replies. Never mind i'll have to go along with what is currently available.

Bernt

Why dont you give each company a database of their own? Wouldnt this solve you problem?

Regards Bernt

bbrown

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.