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 ...

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 ...

Backing up SQL databases is essential for data protection and disaster recovery, and storing backups on a network share reduces the risk of data loss even more. Why Backup SQL Databases to a Network ...

Among many new features, Microsoft's new database management system is well-suited for applications that require uptime and portability. With the recent release of SQL Server 2012, Microsoft is ...

One of the major challenges that SQL Server admins face nowadays is corruption in MDF file. When a database is corrupted, it goes into the suspect state or you may fail to access the tables, stored ...

This article explains how to repair the MDF file using the native repair methods and how to use a Reliable MDF file Repair ...