Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Jun 14, 2002

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

By Michael Aubert

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

MS SQL Archives

Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM