3 questions about database maintenance: 1. can i expand a DB while other users are working on it? 2. can i make a backup of a DB while users are working on it? 3. can i optimize tables of a DB while users are working on it? thx in advance.
yes u can expand,take backup and optimize u r tables while other users are working. BUT SHOULD AVOID DOING IT. [;)]
yeah sure, the menu items are active and i have permissions to do it 
but i’ve tested a bit around now: (Navision Native Server) 1. possible, but tables get locked, users will get upset 2. also possible, but backup is only taken of data that was in the DB the moment you hit the OK button. 3. i really dont want to risk a scene similar to the one at 1.
I read this thread today and decided to try point 3. Today we have only 3 users in Navision, instead of normally 35. I didn’t hear any complaints, so I guess is no problem to do it. But I must say I wouldn’t do it with all 35 users in Navision at one time. [;)]
Don’t forget that you can also optimize the Tables/Keys in a selective way. It is not necessary to optimize all Tables. If you know that Purchases will not be used for a few hours, you can optimize Vendor Ledger Entry, for example.
quote:
- also possible, but backup is only taken of data that was in the DB the moment you hit the OK button.
According to this post ( http://www.navision.net/forum/topic.asp?TOPIC_ID=11446 ), the backup is taken of the data in the DB as of the moment you open the Backup form.
Backup is OK. Expansion on the other hand can be dangerous since the versioning principle doesn’t work when expanding and You could end up with a corrupt db if anything goes wrong.
Is there a good reason to optimize your tables? (beside the fact you save some space on the database) Performance maybe?
Here’s Your Answer Marc http://www.navision.net/forum/topic.asp?TOPIC_ID=8033&SearchTerms=optimizing