Versions Compared

Old Version 2

changes.mady.by.user Vijayganesh Sivaprakasam

Saved on

compared with

New Version 3

changes.mady.by.user Vijayganesh Sivaprakasam

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Note

For SQL Server, the user databases which are part of Dbvisit, the recovery model must be set to FULL. In the below example for databases NEW and AdventureWorks, the recovery model has been set to FULL .

Database Name Recovery Model
master SIMPLE
tempdb SIMPLE
model FULL
msdb SIMPLE
NEW FULL
AdventureWorks FULL

as pointed out in below figure.

You can also refer to the below Microsoft documentation link on how to view the recovery model and change the recovery model from SIMPLE to FULL.

https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/view-or-change-the-recovery-model-of-a-database-sql-server?view=sql-server-ver15

...