Automatic backup for database

Automatic backup for database

Create an automatic backup is quite easy

1-= Create a folder on the root drive "C" - with the name "AutoBackup"

2-= Open a notebook and write the following script


3-= Save the script with the name of backup.sql (inside the folder we created in the root of the drive "C")

4-= Open another notepad and type the following script


5-= Save the script with the name of backup.bat (inside the folder we created in the root of the drive "C")

Now we just have to go to task scheduler

create a new task to run the .bat file

the number of times you want

every week - every day - every hour

the number of times depends on you

I hope you serve someone in need :bandit:

The SQL itself create backup. Just use only developer version. I find it easier

Or you can use this program too, has a free version.

Runs backups, and also you can restore any database on just a click.
It uploads the backup files to the internet, for example dropbox.

[Only registered and activated users can see links. Click Here To Register...]