Visual Studio .NET 2008 includes a built-in database management tool which will allow you to connect directly to the SQL Server and run a script to backup your database. The following functions are available with this tool: Retrieve and edit data Create tables, views, and stored procedures (Enterprise & Architect Version only) To connect to your SQL Server database with Visual Studio .NET, follow the steps listed below. Open Server Explorer (View -> Server Explorer); With VWD 2008 Express it will be Database Explorer. The Server Explorer should show up on the left side of the IDE Right click on "Data Connections" and select Add Connection. Enter the Server Name in the first textbox (do not use the dropdown box). MS SQL Server name can be found in the SQL Manager in your Site Info Manager in Control Panel. Check Use SQL Server Authentication Enter your SQL username & password Select your database from the dropdown list. Click Ok Once connected, you should see a new entry in the Data Connections Section. To generate the script that will create the backup of your database follow the steps listed below. Right click on your database and choose Publish to Provider. Click Next on the welcome screen of Publishing Wizard. Insure that your database is selected and check mark "Script all objects in the selected database" and click Next. Choose the "Script to file" option and type the name of the script you will be generating. Click Next. Leave the default Publishing Options and click Next. Click Finish. To run the script that will restore your database to your local SQL Server it will be much simpler to use SQL Server Management Studio Express or SQL Server 2008. Follow the steps listed below to restore the database to your local SQL Server. Open your database SQL Server Management Studio. Click on File/Open/File and navigate to the SQL script you just created from the SQL Server. Once the script is opened navigate to the very top of the page and type: USE [Local database name] GO (Insure that the bracket symbols are also deleted.) Click on the Execute button. Note: If you have SQL Server Management Studio and Visual Studio installed on your computer then Database Publishing Wizard will also be available. However, if you only have Visual Studio, you may need to go into Microsoft's website and download the "Database Publishing Wizard" component so that you can use it with Visual Studio.