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.