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.
Mike
maubert@databasejournal.com
www.2000trainers.com
»
See All Articles by Columnist Michael Aubert
» 
Comment and Contribute
