January 15, 2009 at 11:33 am
We have a Web Server (Windows Server 2003), SQL Server 2005 (Windows Server 2003) and Business Objects Server. We are a small shop (two of each server) with 3 production and 3 test servers. I would like to know what are some good, cheap, full server backup/restore software packages? Also, are there any free ones? Please send me any websites or information which may be helpful like 'ease of use', costs, whether it can perform a full server backup and restore, whether it can restore a single file or single database object restore (like a table or stored procedure).
Thanks in advance, Kevin
January 15, 2009 at 11:46 am
Have you looked at Data Protection Manager from MS? Check it out. Definitely worthy of a look.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 15, 2009 at 2:03 pm
6 servers is totally doable with DIY solutions 🙂
We have 50+ servers and they use in-house script/jobs with mix of Maint. Plan
I don't know any good free ones, maybe SQLLite from Quest?
Otherwise I recommend Red Gate SQLBackup
January 15, 2009 at 2:19 pm
Are you talking specifically SQL backups, or file backups also?
In any case, whatever you do, I would get a seventh server specifically for backups. Or a good tape drive or NAS device of some sort.
If you don't do backups to a different server they are really somewhat pointless.
The Redneck DBA
January 15, 2009 at 2:36 pm
I want to do a full server backup which would include the O/S, sql server backups (.bak files) and vendor application files.
Thanks, Kevin
January 15, 2009 at 3:06 pm
Then you are going to want something comprehensive that will either pull it all to tape or some remote disk as Jason already stated. You will need to consider if you are going to be backing up SQL Server to disk or if you are going to have your backup software take care of the SQL Server backups (preference would be to do them from SQL Server). Some of the major player apps were Backup Exec, Net Backup (both Symantec - at least they were not sure who owns them now), ArcServe (are they still around), and DPM (Data Protection Manager) as mentioned earlier. There are others I'm sure.
I would certainly do my homework on this as your backups are your business. And as is stated many times, your backups are only good if you can use them to recover so, test, test, and test. Do a search of threads here on this site alone where people end up with corruption and no backups.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply