With SQL Server 2000, there are myriad choices for backing up your database. Whether your database is small and changes infrequently or very large and changes rapidly, there is a backup strategy to ...

In addition, there isn’t a need for point-in-time or up-to-the-minute restores.For more information on recovery models review chapter 3, “Administering SQL Server 2005 Database Engine” on my SQL ...

SQL Server instances, even if equipped with provisions like automatic backup and recovery, are not sufficiently protected against sudden, disastrous situations like multi-site database failure, ...

No. The full <I>vs</I> simple recovery model only affects when transaction logs are truncated. In the simple model, the logs are truncated as soon as they are "clean" (that is, VLFs are truncated as ...

When the creation and configuration of a Recovery Services vault is complete, discovering databases and configuring backup is a two-step process. During the backup configuration, if the SQL VM and its ...

This article is a revised version of the original published January 3, 2005. See Editor’s Note for details. Two major factors drive database backups these days: compliance and disk space. Some ...

'AppAssure is honored to receive the Editor's Choice from SQL Server Magazine's editors,' said Najaf Husain, CEO of AppAssure. 'Recovering mission critical applications fast, with as little effort as ...