AdventureWorks Sample 2012


To install the AdventureWorks databases, all that’s required is to attach them in SQL Server Management Studio 2012. Go to Start | All Programs | Microsoft SQL Server 2012, and click SQL Server Management Studio. Copy the MDF files to a folder where you want to store the attached databases. A recommended location is with…

Automatic SQL Server backup


Automatic SQL Server backup solution and also how to back it up online with SecureBackup. I am using Microsoft SQL Server 2008 Express but you should be able to use these instructions for all versions of Microsoft SQL Server 2005 and Microsoft SQL Server 2008. In my machine, the database files are located in the…