SQLUSA

Microsoft SQL Server 2000 Best Practices

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
 
SQLUSA.com Home Page