ansaurus

Question

What are your recommended Windows Server 2003 Backup Tools?

Answer 1

+2 A:

Here at my company I do the following.

At the end of the day I take a full back-up, using a SQL Server job. The syntax for this is well documented in BOL however here is an example:

    BACKUP DATABASE [DATABASE]
    TO DISK = '[PATH]\[DATABASE].BAK'
    WITH INIT;

I then execute a .bat file that runs a compression process using a free Zip utility to make the files smaller before been shipped off.

During the day I have 4 transaction log backup jobs that run every 10-12 minutes. Each backing up to a separate file.

Then Every hour I run a differential back-up (this will back-up only the differences since the last back-up) I then destroy the transaction files and start again.

Hope that gives you a little info on how it can be done in SQL Server without any 3rd party costly tools.

MrEdmundo 2009-02-16 09:34:43

Which free zip utility do you use? I've played around with PowerArchiver for doing this as they have a scheduled zip function built in. This was very unreliable though so I stopped using it.

Craig Bovis 2009-02-16 10:18:44

Hi, we use something called 7-zip. The previous guy before me had it installed and I've never had reason to upgrade or remove it. No reliability problems at all. Runs with a simple source - destination command call.

MrEdmundo 2009-02-16 10:39:06

Thanks, sounds like the one tool could handle both my SQL compression plus my file backups as well.

Craig Bovis 2009-02-16 12:15:36

ansaurus

tags:

views:

answers:

What are your recommended Windows Server 2003 Backup Tools?

related questions