Windows 7 includes an ODBC manager that lets you connect from your desktop to a SQL server. You create a data source name (DSN) to save database setup information, so you can open a connection to ...

The Connection Properties dialog opens. For my sample ITworld application, I changed the data source to Microsoft SQL Server (SQLClient), and entered the necessary Server, Log On, and database values.

In the Restore Database window, select the database and the backup sets to restore, and press OK. How to Restore a Backup Using T-SQL Alternatively, you can use the T-SQL commands to restore a ...