Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 590
  • Last Modified:

Schedule SQL Backup

Hi I'm looking to automat a backup of my SQL server database (2008 express). I would like to do this daily prior to running some other scheduled jobs.Having not created backup schedules befor I was looking for a bit of advice and assistance/examples.

1) What is the best way to get a scheduled back up. Is this through SQL server or create a script and get windows scheduler to run the script (if possible) are there other alternatives.

2) when I perform a backup I would like to keep the past 20 backups. I see that you can set up backups to expire after a certain amount of time. So do I append to an existing backup or do I create a backup with a datestamp - how would I do either?

3) what other things may I need to take into consideration ?

Appologies for this being very general however I have not had much experience here.
0
Simon Cripps
Asked:
Simon Cripps
1 Solution
 
neeraj523Commented:

1. Better to schedule your backups using SQLServer Agent only

2. Keep appending backups in same file alongwith setting for keeping n number of old backups

3. You can check if you also need to take backup of SQL Log too.. Most of the cases it is not needed.
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
In express edition of SQL Server, you can't schedule backups and hence use the script in the link below to schedule automated backups in SQL Server 2008:

http://www.sqldbatips.com/showarticle.asp?ID=27

A more simpler version without deleting older backup files can be found here:

http://www.mssqltips.com/tip.asp?tip=1174
0
 
Simon CrippsOwnerAuthor Commented:
Many thanks this worked for me
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now