Click here to Skip to main content
Click here to Skip to main content
Alternative Tip

Backup and Restore SQL Server database

, 29 Nov 2011
Rate this:
Please Sign up or sign in to vote.
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...

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 file name and restore it.

License

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

About the Author

vikas_panchal

United States United States
No Biography provided

Comments and Discussions

 
-- There are no messages in this forum --
| Advertise | Privacy | Mobile
Web04 | 2.8.140721.1 | Last Updated 29 Nov 2011
Article Copyright 2011 by vikas_panchal
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid