Schedule backups for SQL Server 2005 Express databases


I have to implement a solution to back up a SQL Server 2005 express database for a project. Here is a detailed step by step instruction to do this.
Create a stored prodedure in Master database to do the backup; create a .sql file to define which database to  backup; use window scheduler (Scheduled Tasks ) to schedule the backup  re-occurring times. Here is the link with the details: http://www.mssqltips.com/tip.asp?tip=1174
Advertisements


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s