SQL Server 2000 Administration in 15 Minutes a Week: Database Backups - Page 4

June 14, 2002

Making a backup

To make a backup manually, you have plenty of options. We are going to look at three ways you can create a backup.

First, right click the database you would like to backup in Enterprise Manager, select All Tasks, and then click Backup Database...

You can also use the Create Database Backup Wizard by selecting the Tools menu in Enterprise Manager, select Wizards..., expand Management, and select Backup Wizard.

The third way to backup your database is by using the BACKUP statement. For more information on the BACKUP statement, see the SQL Server books online.

We are going to talk more about backups next week, but if you would like to read more about this topic, have a look at this link: http://msdn.microsoft.com/library/en-us/adminsql/ad_bkprst_9zcj.asp.

That will do it for this week. Next week we will talk about creating a backup strategy as well as restoring backups.

As always, if you have any technical questions please post them on the SQL message board.Please send any non-technical questions, comments, and feedback to my email. I hope you are finding this series to be a useful one, and I'm looking forward to your feedback.


» See All Articles by Columnist Michael Aubert