How to take a database Backup

Madhan

Hi All,

I like to take a backup of the live database everyday depend upon the time which I set. whether it is possible. give me a solution. Its very very urgent. Help me.

For example:

Every day 12 PM i want a back up.

by
mans

bobnavision

Use Hotcopy.exe.

Set microsoft schedular.

Madhan

can you just explain how to use this exe and where?

kriki

The .exe is in the directory of the DB-server.

You can find on how to use it in the documentation on the CD: it is file w1w1ism.pdf.
If you don't have the file, you can just run the command without parameters and it will show which parameters can be used.

DenSter

Hotcopy doesn't create a backup though right? Doesn't that just copy the database file somewhere?

If you're on SQL Server you can create a maintenance plan (in EM open the server, expand the manager node, right click on Database Maintenance Plans and click 'new maintenance plan') and schedule it whenever you want.

Roelof

You can use Expand.IT. This is a very good product and works really well with Navision. It actually uses Navision's tool to make a backup. In this way you are sure that everything is validated before backing up.

Go to: www.expandit.com for more info.

Roelof.

Madhan

thax a lot to all,

hi Roelof,

can you tell me how much it cost.

Roelof

Did you check their website? www.expandit.com. You should get all the information there.

ashishgupta

hi Roelof,
I checked the site and also get the trial version of utility.
but can u expalin how can i use that.

Thanks.

Roelof

I think there are instructions to set it up. ExpandIT is a scheduler which runs a Navision runtime. It uses Navisions functionality to make the backup. You can schedule it for certain times a day. ExpandIT is using a scriptfile to store all the information. But again, read the instructions and you should be able to understand how it works.

Roelof.