Click here to Skip to main content
15,890,123 members
Please Sign up or sign in to vote.
5.00/5 (1 vote)
See more:
What is the best way to schedule daily SQL 2008 R2 backups in express edition.
How can I do this.

Thanks
Posted
Updated 25-Apr-11 20:14pm
v2

If the expression edition allows you to run jobs, that might be the best approach.
 
Share this answer
 
Comments
shanawazway 26-Apr-11 2:14am    
can u give the steps involved in that
Abhinav S 26-Apr-11 2:53am    
See http://msdn.microsoft.com/en-us/library/ms189036.aspx
It's probabaly usefull to choose a plan, based on your plan you can schedule your back-ups

Incremental Backup — backup of all changes since last incremental backup, therefore, the first day follow your full backup will include the changes for that day. The second day’s incremental would only include changes that day.


Differential Backup — backup of all changes since last full backup. The day following the full backup would include changes that day. The differential backup for the second day following a full backup would include the changes the first day and the second day since the full backup.
Full Backup — backup of all files in your critical file set


On-site storage — Onsite storage of tapes should be far enough away from your system so that if you system is destroyed in an accident, your backup copy will not suffer the same fate. Fireproof safes are often a good option.


Off-site — Off-site storage of tapes should be a separate physical location (different office building, safe-deposit box, home storage, etc.).

http://www.imation.com/smb/tips_backup_plans.html[^]
 
Share this answer
 
Since SQL Server Express does not have SQL Server Agent.

We created a stored procedure and used a Perl script to execute it based on a windows scheduled task.

Another way would be PowerShell again as a windows scheduled task.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900