MS SQL基礎(chǔ)教程:創(chuàng)建備份設(shè)備
Jun 07, 2016 pm 03:04 PM在進行 備份 以前首先必須 創(chuàng)建 備份 設(shè)備 。 備份 設(shè)備 是用來存儲數(shù)據(jù)庫、事務(wù)日志或文件和文件組 備份 的存儲介質(zhì)。 備份 設(shè)備 可以是硬盤、磁帶或管道。SQL Server 只支持將數(shù)據(jù)庫 備份 到本地磁帶機,而不是網(wǎng)絡(luò)上的遠程磁帶機。當使用磁盤時,SQL Serv
在進行備份以前首先必須創(chuàng)建備份設(shè)備。備份設(shè)備是用來存儲數(shù)據(jù)庫、事務(wù)日志或文件和文件組備份的存儲介質(zhì)。備份設(shè)備可以是硬盤、磁帶或管道。SQL Server 只支持將數(shù)據(jù)庫備份到本地磁帶機,而不是網(wǎng)絡(luò)上的遠程磁帶機。當使用磁盤時,SQL Server 允許將本地主機硬盤和遠程主機上的硬盤作為備份設(shè)備,備份設(shè)備在硬盤中是以文件的方式存儲的。
15.2.1 用SQL Server Enterprise Manager 管理備份設(shè)備
1 使用SQL Server Enterprise Manager 創(chuàng)建備份設(shè)備
(1)使用SQL Server Enterprise Manager, 創(chuàng)建備份設(shè)備的步驟為:
(2) 打開Management 文件夾,然后選擇Backup 圖標。
(3) 右擊Backup 在彈出菜單中選擇 New Backup Device 選項,然后彈出 BackupDevice Properties – New Device 對話框。如圖15-1 所示。
(4) 在Name 欄中輸入設(shè)備名稱該名稱是備份設(shè)備的邏輯名。
(5) 選擇備份設(shè)備類型,如果選擇File name 表示使用硬盤做備份,只有正在創(chuàng)建的設(shè)備是硬盤文件時,該選項才起作用。如果選擇Tape Drive name 表示使用磁帶設(shè)備。只有正在創(chuàng)建的備份設(shè)備是與本地服務(wù)器相連的磁帶設(shè)備時,該選項才起作用。
(6) 然后單擊確定創(chuàng)建備份設(shè)備。
2 使用SQL Server Enterprise Manager 刪除備份設(shè)備在創(chuàng)建備份設(shè)備的第二步,選中Backup 圖標后,在右格對話框中右擊要刪除的備份設(shè)備,在彈出菜單中選擇Delete 選項,則刪除該備份設(shè)備。
15.2.2 使用系統(tǒng)過程管理備份設(shè)備
1 sp_addumpdevice
在SQL Server 中,使用sp_addumpdevice 來創(chuàng)建備份設(shè)備。其語法格式為:
查看全套"MS SQL基礎(chǔ)教程"

Hot AI Tools

Undress AI Tool
Undress images for free

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

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

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.

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.

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.

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 "

In daily shooting, many people encounter this situation: the photos on the camera seem to be exposed normally, but after exporting the photos, they find that their true form is far from the camera's rendering, and there is obviously an exposure problem. Affected by environmental light, screen brightness and other factors, this situation is relatively normal, but it also brings us a revelation: when looking at photos and analyzing photos, you must learn to read histograms. So, what is a histogram? Simply understood, a histogram is a display form of the brightness distribution of photo pixels: horizontally, the histogram can be roughly divided into three parts, the left side is the shadow area, the middle is the midtone area, and the right side is the highlight area; On the left is the dead black area in the shadows, while on the far right is the spilled area in the highlights. The vertical axis represents the specific distribution of pixels

The expansion of the virtual market is inseparable from the circulation of virtual currency, and naturally it is also inseparable from the issue of virtual currency transfers. A common transfer error is the address copy error, and another error is the chain selection error. The transfer of virtual currency to the wrong chain is still a thorny problem, but due to the inexperience of transfer operations, novices often transfer the wrong chain. So how to recover the wrong chain of virtual currency? The wrong link can be retrieved through a third-party platform, but it may not be successful. Next, the editor will tell you in detail to help you better take care of your virtual assets. How to retrieve the wrong chain of virtual currency? The process of retrieving virtual currency transferred to the wrong chain may be complicated and challenging, but by confirming the transfer details, contacting the exchange or wallet provider, importing the private key to a compatible wallet, and using the cross-chain bridge tool

Recently, Samsung Display and Microsoft signed an important cooperation agreement. According to the agreement, Samsung Display will develop and supply hundreds of thousands of OLEDoS panels for mixed reality (MR) head-mounted devices to Microsoft. Microsoft is developing an MR device for multimedia content such as games and movies. This device is expected to It will be launched after the OLEDoS specifications are finalized, mainly serving the commercial field, and is expected to be delivered as early as 2026. OLEDoS (OLED on Silicon) technology OLEDoS is a new display technology that deposits OLED on a silicon substrate. Compared with traditional glass substrates, it is thinner and has higher pixels. OLEDoS display and ordinary display

Recently, "Black Myth: Wukong" has attracted huge attention around the world. The number of people online at the same time on each platform has reached a new high. This game has achieved great commercial success on multiple platforms. The Xbox version of "Black Myth: Wukong" has been postponed. Although "Black Myth: Wukong" has been released on PC and PS5 platforms, there has been no definite news about its Xbox version. It is understood that the official has confirmed that "Black Myth: Wukong" will be launched on the Xbox platform. However, the specific launch date has not yet been announced. It was recently reported that the Xbox version's delay was due to technical issues. According to a relevant blogger, he learned from communications with developers and "Xbox insiders" during Gamescom that the Xbox version of "Black Myth: Wukong" exists.
