use master; go select name, case recovery_model when 1 then 'Full' when 2 then ' Bulk_logged ' when 3 then 'Simple' end model from sys.databases where name not in ('master','tempdb','model','msdb'); go
Note: The restoring mode of the database must be Full.
alter database [dbname] set recovery full; go
Repeat Step 1 to confirm that the database restoring mode has been successfully modified.
Taking a backup file named testdb.bak as an example:
use master; go backup database [dbname] to disk ='z:\Backup\testdb.bak' with compression,init,stats=5; go
use master; go restore filelistonly from disk = 'z:\backup\testdb.bak'; go
alter database [dbname] set recovery [model]; go
Finally, create an empty database on the cloud database for importing backup files. Users can also use the JCS for SQL Server Management Studio client tool to make a full backup of the database, and, at the same time, ensure that the database recovery mode is "Complete".