Page History

...

Refer to this article for an overview of backup operations in SQL Server. All databases have a configured Newtablinkaliasrecovery modelurlhttp://msdn.microsoft.com/en-us/library/ms189275.aspx, which dictates the kinds of backup and restore operations which are available. In all cases, a full backup should be taken of any database which has never been backed up. In the simple recovery model, regular full backups should be taken on an ongoing basis, while using the full or bulk logged recovery model, regular log and differential backups should be added to the full backup schedule.