Question

Automatically backup my online application data

10

I would like to make a weekly backup of my online application data (production). I am using a SQL server database (2008). Is there a way to do it automatically?

asked 2009-08-13

Fedor Klinkenberg

3 answers

2

Benny is right, this is quite a technical operation.

For more info on auto back up of SQL databases you can look here

answered 2009-08-14

Michel Vermeer

1

Yes. Define a scheduled event, that executes weekly and connect a Java action to it. Ask a Java developer to write the action for dumping the production database.

answered 2009-08-13

Herbert Vuijk

Benny van Reeven · Accepted Answer · 2009-08-13

You should probably ask your system administrator to configure SQL Server to make weekly backups to a safe location. I would recommend to keep full database backups out of your application (i.e., don't use a scheduled event) and to let the database server itself handle this.