Ca alternativa:

USE master;
GO
ALTER DATABASE [MyDatabase] SET RECOVERY FULL
GO

Sau pentru a avea recovery model FULL pentru noile baze de date create:

USE master;
GO
ALTER DATABASE [model] SET RECOVERY FULL
GO

 

---

Cristian Andrei Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET,
MCTS, MCITP - Database Administrator SQL Server 2005
http://sqlserver.ro