Its a very common task to backup and restore SQL Server databases. SQL Server Management studio offers a GUI for performing backup and restore but following queries would be very useful for backup and restore if you are not having access to SQL Server Management Studio

Backup Script

BACKUP DATABASE  database_name  TO DISK = ‘C:\example.bak’ WITH FORMAT;

Restore Script

RESTORE DATABASE ‘DATABASE_NAME’ FROM DISK =’C:\EXAMPLE.BAK’

The Visual Studio 2010 and .NET Framework 4 Training Kit includes presentations, hands-on labs, and demos. This content is designed to help you learn how to utilize the Visual Studio 2010 features and a variety of framework technologies including:

• C# 4.0
• Visual Basic 10
• F#
• Parallel Extensions
• Windows Communication Foundation
• Windows Workflow
• Windows Presentation Foundation
• ASP.NET 4
• Windows 7
• Entity Framework
• ADO.NET Data Services
• Managed Extensibility Framework
• Visual Studio Team System

This version of the Training Kit works with Visual Studio 2010 RC and .NET Framework 4 RC.

• Supported Operating Systems: Windows 7; Windows Server 2008; Windows Vista

Visual Studio 2010 RC .NET Framework 4 RC.

Instructions

Download and launch the self-extracting package. The Training Kit will uncompress to the selected folder and launch a HTML browser for the content.

Download Visual Studio 2010 and .NET Framework 4 Training Kit – February Release