Certified ASP.NET Programmer Learning Resources Copy a SQL Express Database

Learning Resources

Copy a SQL Express Database

Just open SQL Server Management Studio Express, right-click on your database and choose Tasks->Back Up…
You can leave the default settings or, for instance, save a backup in a different location.

After doing a copy step it is a about the time to do a paste step.

Right Click on the Database node and choose Restore.

Select your source database in the From database drop-down box and choose a destination in the To database, you can also type a name of a database you would like to create and it will be created automatically containing all the data from the source database.

And voila, your database including all its data is copied.

 For Support