Detailed steps for restoring a database from SQLServer

Welcome to the Windows community forum and interact with the 3 million technical staff. Go to the detailed steps to solve the problem of restoring the database directory incorrectly: 1. method in Enterprise Manager: -- Right-click Database -- all tasks -- Restore database -- restore to database and enter the restored database name -- Restore select from device -- select device -- add you

Welcome to the Windows community forum and interact with 3 million technical staff> go to the detailed steps to solve the problem of restoring the database directory incorrectly: 1. methods in Enterprise Manager: -- Right-click "Database" -- all tasks -- Restore database -- "Restore to Database" and enter the restored database name -- Restore and select "from device" -- select device -- add you

Welcome to the Windows community forum and interact with 3 million technicians>

-- Detailed steps to solve the problem of restoring database directories:

1. Methods in Enterprise Manager:

-- Right-click "Database"

-- All tasks

-- Restore database

-- Enter the restored database name in "Restore to Database"

-- Restore select "from device" -- select device -- add your backup file -- OK, and return to the database restoration page.

-- Backup number -- Select Content -- select the backup content you want to restore

-- Option -- change the physical file name in "move to physical file name" to the name of the data file to be stored.

-- If the database to be restored already exists, select "qz restore on the existing database "-

-OK

2. Use the SQL statement (assume that your backup file name is c: \ xx. bak

-- List logical file names in backup files

Restore filelistonly from disk = 'C: \ xx. Bak'

-- Restore with the Statement. Use the move option based on the Logical file name listed above.

Name of the database after the restore database is restored

From disk = 'C: \ xx. Bak'

With move 'logical data file name 1' to 'C: \ physical data file name 1'

, Move 'logical data file name 2' to 'C: \ physical data file name 2'

...

, Move 'logical data file name n' to 'C: \ physical data file name N'

There is nothing to pay special attention to, and the backup/restoration between the Enterprise Edition should pay attention to the same thing:

1. Pay attention to the Backup Settings. do not specify multiple backup files. Otherwise, you must specify multiple backup files during restoration.

2. Pay attention to the backup media processing method. Rewrite it instead of append it. Otherwise, you must specify the backup number during restoration.

3. Pay attention to the backup method. Use full backup instead of other backup methods. Otherwise, other backup files will be supported during restoration.

[1] [2]