DotNetShoutout - Stories tagged with Daily
4
Shouts

Schedule database backup for sql server 2005 using maintenance plan

posted by kcherupakcherupa 1171 days, 9 hours, 49 minutes ago
Friday, March 05, 2010 5:16:55 AM GMT
Scheduling a daily backup of sql server 2005 database using sql agent is very easy. By following below steps anyone can do that. Open sql server 2005 Management Studio and connect a serverExpand the tree (left navigation) ”Management->Maintenance Plans”Right click on node Maintenance Plans and Click “Maintenance Plan Wizard” (As shown in figure below) which causes to open a wizard. Follow the wizard In 2nd step of the wizard, You can schedule the task as clicking the Button “Change” as shown i... (more)
category: Data | clicked: 0 | comment | | source: cherupally.blogspot.com
tags: sql agent, recurrent, backup, Database, SQL Server 2005, Daily