Click here to Skip to main content

Go to Tip/Trick

Backup and Restore SQL Server database

vikas_panchal

Rate me:

5.00/5 (1 vote)

29 Nov 2011CPOL

7.9K

If you use SQL Server 2005, then do this:Go to your database and right click on the database name.Go to Task and choose Backup and Enter, your backup is created.Then if you want to restore it:Make a new database and right click.Choose Restore database and choose Backfile.Select...

Alternatives

Members may post updates or alternatives to this current article in order to show different approaches or add new features.

1. Backup and Restore SQL Server database

22 Nov 2011Ahmed Naqibul Arefin

1 alternative

How to backup and restore SQL Server database schema

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

vikas_panchal

United States

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Comments and Discussions

Go to top