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 database recovery mode must be Full
The user can use SQL Server Management Studio client tool to make full backup for the database. Please ensure the database recovery mode is "Full"
alter database [dbname] set recovery full;
go
Repeat the step 1 and confirm if the database recovery mode is modified or not
Taking the following backup file in the name of testdb.bak for 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
At last, create a null library in the Cloud Database for importing backup files. The user can use SQL Server Management Studio client tool to make full backup for the database. Please ensure the database recovery mode is "Full"