Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have an SQL database - I need to back it up everyday (at a minimum) - preferably multiple times a day - automatically so it definitely gets done.

I'm running Windows which the SQL database is stored on

What programs (prefer free ones) can I use to back it up - I'm completely new with SQL so if you're gonna explain something - do it in layman's terms thanks (:

It needs to get backed up to another server (on the lan).

Cheers for any help you can give!

share|improve this question
    
Hi Chuck, It sounds like you are using MS SQL Server since you specified windows. Is it the express edition? I used to see this question a lot so I created a video tutorial on how to do it through the GUI. It's rather in depth and goes through a lot of different facets, if you want something quicker check out: SQL Backup And Restore For The Accidental DBA [1]: alirazeghi.com/sysadmindba [2]: simple-talk.com/sql/database-administration/… –  Ali Razeghi Jan 31 '13 at 1:18
    
Good point by Ali. My answer assumes SQL Server and a non-Express edition. –  Thomas Stringer Jan 31 '13 at 1:23
    
Hello, I'm not too sure what it is - I don't believe its express edition because it doesn't say it anywhere. I've had a look at the links you provided - however can you also provide your video link? –  chuck Jan 31 '13 at 1:34
    
I found the video and tried it out - however when I try and backup to the server I get an "operating system error 5 reason 15105" - what am I doing wrong? –  chuck Jan 31 '13 at 1:45

1 Answer 1

up vote 3 down vote accepted

You can do this directly through SQL Server. You can schedule the backups through SQL Server Agent and just call the backup command through the job. The job will allow you to schedule it as you please.

To make this even a bit easier you can create a Maintenance Plan directly in SQL Server and specify backing up the database.

There are a few options here, and no need to look outside of SQL Server for this functionality.

Here's an article on how to do this through a maintenance plan: http://weblogs.asp.net/sreejukg/archive/2010/01/20/scheduling-automated-backup-using-sql-server-2008.aspx

share|improve this answer
    
Hi Thomas - thanks for your answer! however I can't find SQL server agent in my list - is there somewhere I need to turn it on from? –  chuck Jan 31 '13 at 1:35
    
What does select @@version return? –  Thomas Stringer Jan 31 '13 at 2:32
1  
I thankyou for your help however I found a different way - I used "SQLBACKUPANDFTP" does all that I need (: Thanks for your help both of you! –  chuck Jan 31 '13 at 2:52

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.