You are currently offline, waiting for your internet to reconnect

How to schedule a database backup operation by using SQL Server Management Studio in SQL Server 2005

Extended support for SQL Server 2005 ends on April 12, 2016

If you are still running SQL Server 2005 after April 12, 2016, you will no longer receive security updates and technical support. We recommend upgrading to SQL Server 2014 and Azure SQL Database to achieve breakthrough performance, maintain security and compliance, and optimize your data platform infrastructure. Learn more about the options for upgrading from SQL Server 2005 to a supported version here.

INTRODUCTION
This article describes how to schedule a database backup operation by using SQL Server Management Studio in Microsoft SQL Server 2005.
MORE INFORMATION
To schedule a database backup operation by using SQL Server Management Studio in SQL Server 2005, follow these steps:
  1. Start SQL Server Management Studio.
  2. In the Connect to Server dialog box, click the appropriate values in the Server type list, in the Server name list, and in the Authentication list.
  3. Click Connect.
  4. In Object Explorer, expand Databases.
  5. Right-click the database that you want to back up, click Tasks, and then click Back Up.
  6. In the Back Up Database - DatabaseName dialog box, type the name of the backup set in the Name box, and then click Add under Destination.
  7. In the Select Backup Destination dialog box, type a path and a file name in the Destinations on disk box, and then click OK.
  8. In the Script list, click Script Action to Job.
  9. In the New Job dialog box, click Steps under Select a page, and then click Edit if you want to change the job parameters.

    Note In the Job Step Properties - 1 dialog box, you can see the backup command.
  10. Under Select a page, click Schedules, and then click New.
  11. In the New Job Schedule dialog box, type the job name in the Name box, specify the job schedule, and then click OK.

    Note If you want to configure alerts or notifications, you can click Alerts or Notifications under Select a page.
  12. Click OK two times.

    You receive the following message:
    The backup of database 'DatabaseName' completed successfully.
Note To verify the backup job, expand SQL Server Agent, and then expand Jobs. When you do this, the SQL Server Agent service must be running.
Properties

Article ID: 930615 - Last Review: 11/20/2007 17:48:28 - Revision: 1.2

Microsoft SQL Server 2005 Developer Edition, Microsoft SQL Server 2005 Enterprise Edition, Microsoft SQL Server 2005 Enterprise X64 Edition, Microsoft SQL Server 2005 Standard Edition, Microsoft SQL Server 2005 Standard X64 Edition, Microsoft SQL Server 2005 Workgroup Edition

  • kbexpertiseadvanced kbsql2005engine kbhowto KB930615
Feedback
y>me='ms.dqp0';m.content='true';document.getElementsByTagName('head')[0].appendChild(m);" onload="var m=document.createElement('meta');m.name='ms.dqp0';m.content='false';document.getElementsByTagName('head')[0].appendChild(m);" src="http://c1.microsoft.com/c.gif?"> l>=">/html>