DavidPike
Programmer
- Oct 9, 2007
- 18
How does one schedule a SQL DB backup to occur on a regular periodicity without human intervention?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Scheduling a SQl Server backup 1
- Thread starter DavidPike
- Start date
- Status
-
1
- #2
mrdenny
Programmer
- May 27, 2002
- 11,595
Setup a SQL Job with the BACKUP DATABASE command.
You can also use the database maintenance plan to backup the database which will also setup a SQL Job.
If you are using SQL Express you don't have maintenance plans or SQL Jobs so you have to use the Windows Task Scheduler to run sqlcmd passing it the BACKUP DATABASE Command.
Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)
My Blog
You can also use the database maintenance plan to backup the database which will also setup a SQL Job.
If you are using SQL Express you don't have maintenance plans or SQL Jobs so you have to use the Windows Task Scheduler to run sqlcmd passing it the BACKUP DATABASE Command.
Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)
My Blog
- Status
Similar threads
- Locked
- Question
