Yes, you are right "planoie". I have the same in place for automatic daily backup and clear all backups older than 3 days. This should be the one you are looking for.


-Vijay G

Hey Guys,

thanks for your replies. I'll try your suggestions today.

Greetings
Jan

you can restore the Northwind database to it's original state by running the script that SQL Server runs when it creates the Northwind database for the first time. the script can be found here (for a default instalation):

C:\Program Files\Microsoft SQL Server\MSSQL\Install\instnwnd.sql

the script deletes the Northwind database first, and then recreates it.

defiant.