| How to
change the Recovery Model for backup purposes? |
|
The following
script changes the Recovery Model to FULL. Full backups, differential
backups and transaction log backups can be executed in this model.
ALTER DATABASE Northwind
SET RECOVERY FULL
GO
|
| The World Leader
in SQL Server Training |
|