Copy a SQL Express Database

Certify and Increase Opportunity.
Govt. Certified ASP.NET Programmer

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.

Get industry recognized certification – Contact us