Best way to backup Native DB?

slmaluwa

Hi all

Currently my DB size is around 25GB and it still Native. (Moving to SQL is on the cards, anyway).

What is the best possible way to take the backup overnight? Whether to use the Backup feature of the Navision it self or taking the copy of the DB after shutting down the service?

I currently have a script running during the night to
1. Shutdown the service
2. Compress the DB using WinRAR
3. Copy to an external Drive
4. Restart the server

Expect your experience and opinions

TIA

Oneway

You should be able to use Hotcopy to do this.

You can also create a windows schedule task and call a bat then call the hotcopy.

There are lots examples if you search the forum

stryk

Well, actually "HotCopy" is not a "Backup" solution in the original sense - it's a "Replication" feature.

Automatic native backups (FBK) could be created with ExpandIT utilities:
http://www.expandit.com/templates/expandit.asp?catalog_id=616

slmaluwa

ok, so which will be the better method for a faster recovery?

I think the copying the full DB is better because, to disaster recovery process, I just need to copy it back to the location.

What do you all think?

garak

for an faster recovery its better to use tools like HotCopy.

Restoring an *.fbk file can be take a long time.

Waldo

I agree with Garak.
You can do it online ("hot"), and recovering is just copy/past... .

You can always add some kind of zip-function in the batch routine to make your files smaller.

bbrown

Hotcopy can be used to maintain a warm standby server. Just install the NAV server (not running) on a second computer and configure Hotcopy to backup the live db periodically to that computer.

If the main server fails you just need to start the service and have users connect to the second computer.