----------full backup and restore----------
--Full backup database--
Backup database studb to disk= ' E:\stu.bak '
Backup log studb to disk= ' E:\stu_log.bak '
Use master
Go
--Restore Library--
Restore database Studb from disk= ' E:\stu.bak ' with Replace,norecovery
Restore log studb from disk= ' E:\stu_log.bak ' with replace
---------Differential Backup----------
Concept: A full backup of a previous database and now a differential backup to ensure data integrity
Backup database studb to disk= ' E:\stu.bak '--full backup--
Backup database studb to disk= ' E:\stu_diff.bak ' with differential--differential backup--
Use master
Go
Restore database Studb from disk= ' E:\stu.bak ' with replace,norecovery--restore full backup first--
Restore database Studb from disk= ' E:\stu_diff.bak ' with replace--then restore differential backup--
Note:
--replace Overwrite existing database
--recovery database is in a healthy state after restoring the database
--norecovery the database is in an unhealthy state after restoring the database, wait for the next restore
Problems encountered while restoring a database
database right → task → restore → database, select the source device when adding. bak, the following error occurred:
WORKAROUND: Execute with SQL command
RESTORE DATABASE xltebc from DISK = ' D:\XLTebc.bak ' with REPLACE, MOVE ' Pms_yujia (formerly MDF logical name) ' to ' D:\yjdb\pms_yujia.mdf (m DF restored path) ', MOVE ' Pms_yujia_log (once LDF logical name) ' to ' D:\yjdb\pms_yujia_log.ldf (LDF restored path) '
Backup and restore of SQL Server logs