backup for SO

Do you have an HQ database in your organization? With sales in the HQ? Because it's possible to rebuild a correct store database from item/item dynamic, transaction/transactionentry,item inventory and po.. only for items with movements. (with a rebuild of foreign key).

For the backup .. do you have a backup device? or another computer in your shop-network? It's possible to create backup of your SO in the network ...

cod

HI Mohd, I think Cod has answer you already but let me add something new to you.

I have no HQ but how I implemented the SO in my Head office is using Replication technology so any damagae come to my so machine I have no problem becasue i have already replicated database as backup.

The sec> Hi All

Thanks Cod and Akber

Cod we already make that one we replace SO database by using HQ database but the partener make maistake cuse they not check Item ID on transactionentry table so we pass that problem now but I want make ready solution if this happen agin. and we not have network on store.We have just now 42 SO and we go to open 5 more and my manager he well not accept buy backup devaice for all store.

Akber actully this first time I hear about Replication technology but if you send to me I can learn about that. I well try agin with my manager to fix backup device.

but Akber if I replace backupdevice and we go to use your process I have to install SQL server on Store?

Do you can establish a connection between store and hq via SQL ? Because it will be mandatory run a query of update in store database with data of hq, or to have a copy (through DTS) of Item, ItemDynamic, Transaction, TransactionEntry (only of current store) of data in HQ in a new database in the store ...

cod

Hi I have server DB. and I use normal deal-up for comminication.