MS SQL基础教程：创建备份设备
在进行 备份 以前首先必须 创建 备份 设备 。 备份 设备 是用来存储数据库、事务日志或文件和文件组 备份 的存储介质。 备份 设备 可以是硬盘、磁带或管道。SQL Server 只支持将数据库 备份 到本地磁带机，而不是网络上的远程磁带机。当使用磁盘时，SQL Serv
在进行备份以前首先必须创建备份设备。备份设备是用来存储数据库、事务日志或文件和文件组备份的存储介质。备份设备可以是硬盘、磁带或管道。SQL Server 只支持将数据库备份到本地磁带机，而不是网络上的远程磁带机。当使用磁盘时，SQL Server 允许将本地主机硬盘和远程主机上的硬盘作为备份设备，备份设备在硬盘中是以文件的方式存储的。
15.2.1 用SQL Server Enterprise Manager 管理备份设备
1 使用SQL Server Enterprise Manager 创建备份设备
（1）使用SQL Server Enterprise Manager， 创建备份设备的步骤为：
（2） 打开Management 文件夹，然后选择Backup 图标。
（3） 右击Backup 在弹出菜单中选择 New Backup Device 选项，然后弹出 BackupDevice Properties – New Device 对话框。如图15-1 所示。
（4） 在Name 栏中输入设备名称该名称是备份设备的逻辑名。
（5） 选择备份设备类型，如果选择File name 表示使用硬盘做备份，只有正在创建的设备是硬盘文件时，该选项才起作用。如果选择Tape Drive name 表示使用磁带设备。只有正在创建的备份设备是与本地服务器相连的磁带设备时，该选项才起作用。
（6） 然后单击确定创建备份设备。
2 使用SQL Server Enterprise Manager 删除备份设备在创建备份设备的第二步，选中Backup 图标后，在右格对话框中右击要删除的备份设备，在弹出菜单中选择Delete 选项，则删除该备份设备。
15.2.2 使用系统过程管理备份设备
1 sp_addumpdevice
在SQL Server 中，使用sp_addumpdevice 来创建备份设备。其语法格式为：
查看全套"MS SQL基础教程"
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
What is the difference between HQL and SQL in Hibernate framework?
Apr 17, 2024 pm 02:57 PM
HQL and SQL are compared in the Hibernate framework: HQL (1. Object-oriented syntax, 2. Database-independent queries, 3. Type safety), while SQL directly operates the database (1. Database-independent standards, 2. Complex executable queries and data manipulation).
How to use MySQL backup and restore in PHP?
Jun 03, 2024 pm 12:19 PM
Backing up and restoring a MySQL database in PHP can be achieved by following these steps: Back up the database: Use the mysqldump command to dump the database into a SQL file. Restore database: Use the mysql command to restore the database from SQL files.
In summer, you must try shooting a rainbow
Jul 21, 2024 pm 05:16 PM
After rain in summer, you can often see a beautiful and magical special weather scene - rainbow. This is also a rare scene that can be encountered in photography, and it is very photogenic. There are several conditions for a rainbow to appear: first, there are enough water droplets in the air, and second, the sun shines at a low angle. Therefore, it is easiest to see a rainbow in the afternoon after the rain has cleared up. However, the formation of a rainbow is greatly affected by weather, light and other conditions, so it generally only lasts for a short period of time, and the best viewing and shooting time is even shorter. So when you encounter a rainbow, how can you properly record it and photograph it with quality? 1. Look for rainbows. In addition to the conditions mentioned above, rainbows usually appear in the direction of sunlight, that is, if the sun shines from west to east, rainbows are more likely to appear in the east.
Tutorial on how to turn off the payment sound on WeChat
Mar 26, 2024 am 08:30 AM
1. First open WeChat. 2. Click [+] in the upper right corner. 3. Click the QR code to collect payment. 4. Click the three small dots in the upper right corner. 5. Click to close the voice reminder for payment arrival.
What should I do if there is no sound in the system after win11 update? How to solve the problem of no sound in win11 device
Jun 25, 2024 pm 05:19 PM
After some users have updated and upgraded the win11 system, the computer has no sound. The problem of loving you is usually caused by no device, missing sound card driver, or unknown error. So how should we solve these problems? , this issue of win11 tutorial is here to answer everyone’s questions. Next, let’s take a look at the detailed steps. Solution to no sound after win11 upgrade: 1. No device 1. If we are using a desktop computer, it is probably because there is no device. 2. Because ordinary desktop computers do not come with built-in speakers, we need to plug in speakers or headphones to have sound. 2. The sound card driver is missing 1. After we update the Win11 system, the original sound card or audio device driver may not be available.
PHP Tutorial: How to convert int type to string
Mar 27, 2024 pm 06:03 PM
PHP Tutorial: How to Convert Int Type to String In PHP, converting integer data to string is a common operation. This tutorial will introduce how to use PHP's built-in functions to convert the int type to a string, while providing specific code examples. Use cast: In PHP, you can use cast to convert integer data into a string. This method is very simple. You only need to add (string) before the integer data to convert it into a string. Below is a simple sample code
Apple Vision Pro receives major update, visionOS 1.3 RC version released
Jul 25, 2024 pm 04:25 PM
According to news on July 24, Apple recently pushed the highly anticipated visionOS1.3RC version update to VisionPro headset users. This update marks Apple’s continued innovation and progress in the field of virtual reality. Although the official did not clearly disclose the specific content of this update, users generally expect it to include performance optimization, functional improvements, and bug fixes. The internal version number of this update is 21O771, 141 days have passed since the last update. However, due to caching issues with node server configurations in Apple's various regions, some users may experience delays in upgrades and updates. Apple recommends users to back up their data before installing updates to ensure information security. 1.VisionPro users can use the "
A simple tutorial on converting full-width English letters to half-width letters
Mar 25, 2024 pm 09:21 PM
When using a computer to input English, sometimes we encounter the difference between full-width English letters and half-width English letters. Full-width English letters refer to the characters input by pressing the Shift key and the English letter key combination when the input method is Chinese mode. They occupy a full-width character width. Half-width English letters refer to characters input directly when the input method is English mode, and they occupy half a character width. In some cases, we may need to convert full-width English letters to half-width letters. Here is a simple tutorial: First, open a text editor or any
