In SQL Server, the database can be stored in different files and filegroups. If your database is small (100 MB or less), you do not need to worry too much about files and filegroups. But if you have a ...

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

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

While SQL Server 2008 was little more than a service-pack level upgrade, the 2012 version of Microsoft’s database has a boatload of new features and delivers solid performance improvements.

On the eve of the launch of Microsoft SQL Server 2012 we are getting ready for the demand of training for the new features. I have been testing out the new VMs for the 5 new courses using Hyper-V. I ...

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