Backup and restore of SQL Server logs

----------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