Printable View
Hi,
Can anyone recommend an MS SQL server backup software that is robust and can do scheduled full, differential as well as transaction log backups and restore from the backups reliably?
Is SQL Server Backup and FTP any good? It's very affordable for sure :)
Thanks,
Stanav.
I've never used anything but the built-in SQL Backup manager... a couple lifetimes ago, our recommendation to our clients were hourly transaction backups with daily full backups and full server with off-site storag of the tapes. In 10+ years (I left after 9 1/2) we never lost more than an hour's worth of information (lag time between the last transbackup and the current time.)
-tg
Thanks, TG. Yes, the built-in SQL Backup Manager is sufficient for my organization, but it's kind of cumbersome to to set up and use. Most guys at our organization, me included, are not very knowledgeable on SQL server and database management. The guys are just programmers and I'm the system admin/network engineer. Therefore, I'm looking for a product that is reliable and easy to use, one that doesn't require a DBA certification to operate :)
There should be a Maintenance Plan wizard that you can run through... you set it up once, and that's it...
-tg
Just remember to do log backups if the database is in full recovery. Set compression on (if 2228 server or better). Set a backup folder. Add a task to remove files older the x days (how long do you want to keep a backup locally). Ensure that the network backup picks up the folder that the backup is written too. Also ensure that network backup software is not backing up the folder that the database or log files are located in.
-gary
Thanks Gary. I just begin learning to manage SQL server so any advice from the pros are really helpful for me :)
Hit szlamany up... he's pretty good with the SQL Server & admin type stuff...
He'd be more likely to find this if you post right in the database section, askign for help on setting up a maintenance plan for SQL Server.
-tg
In Linux you can set automatic backup of databases, some panels as isp manager support