Export (0) Print
Expand All
1 out of 3 rated this helpful - Rate this topic

Creating a New Backup Device

Applies To: Windows Server 2003, Windows Server 2003 R2, Windows Server 2003 with SP1, Windows Server 2003 with SP2

Before you can create backups of your MIIS database, you must create a new backup device in SQL Server 2000 by using SQL Server Enterprise Manager. The physical backup device (a tape drive, for example) must already be installed and configured before you perform this procedure.

To create a new backup device by using SQL Server Enterprise Manager

  1. In Microsoft SQL Server, click Enterprise Manager.

  2. Expand SQL Server, and then expand Management.

  3. Right-click Backup, and then click New Backup Device.

  4. In the Name box, enter the name of the device, and then click OK.

noteNote
For more information about SQL Server 2000 backup devices, see “Backing Up and Restoring Databases” on the Microsoft MSDN Web site at http://go.microsoft.com/fwlink/?LinkID=10575.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.