Server Backup Software

[BouncyNinja]

Hi ,

can anyone recommend a decent (open source / free if possible) backup tool for a server running sql?

Thanks

 

[Fulcrum29]

Is it running in VM?

 

[rrh]

Hi ,

can anyone recommend a decent (open source / free if possible) backup tool for a server running sql?

Thanks

"A server running sql" is pretty much meaningless.

A good start would be what O/S the server is running, along with which database - here I'm presuming that the RDBMS is on the same server.

 

[BouncyNinja]

apologies

windows server 2012r2 physical machine, with ms sql, pastel evolution database

 

[DrJohnZoidberg]

Where do you want to back up to?

Bacula is a fully fledged open source backup solution, but you will preferably need to be running Linux on the target destination.

 

[BouncyNinja]

Where do you want to back up to?

Bacula is a fully fledged open source backup solution, but you will preferably need to be running Linux on the target destination.

external hard drive?

sadly my linux skills are shocking

 

[DrJohnZoidberg]

external hard drive?

sadly my linux skills are shocking

Why don't you just use Windows Server's built-in backup tool?

 

[BouncyNinja]

Why don't you just use Windows Server's built-in backup tool?

i honestly clean forgot about that

 

[DrJohnZoidberg]

i honestly clean forgot about that

Lol

It works okay, I used it for a while but since moving all my physical servers to VMs backups have become a cinch.

 

[Fulcrum29]

i honestly clean forgot about that

Just remember to test your backups on a scheduled basis. When using that tool, do check your logs.

 

[BouncyNinja]

Just remember to test your backups on a scheduled basis. When using that tool, do check your logs.

will do

thanks

 

[rrh]

i honestly clean forgot about that

SQL Server (the database) also has a built-in backup tool. There are a couple of gotchas (e.g. use UNC paths, use domain login when pointing to another machine) but otherwise all is cool.

Google is your friend: e.g. http://blogs.msdn.com/b/sqlagent/archive/2010/10/12/create-a-database-backup-job-using-sql-server-management-studio.aspx

 

[Clarotech]

You can check out Veeam Endpoint Backup. RC has just been released. It's looking very good and is completely free. It's built on Veeam Backup and Replication so should be able to backup MSSQL and restore it to a consistent state (You should of course test a restore).

We've done some testing on the Beta and managed to backup a physical Windows 2008 R2 server and restore it in a VM without any issues. Currently waiting for final release to test the integration with Veeam B&R.

http://go.veeam.com/endpoint
http://forums.veeam.com/veeam-endpoint-backup-f33/veeam-endpoint-backup-free-rc-t26694.html