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

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

MS SQL

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.

Mike
maubert@databasejournal.com
www.2000trainers.com


» See All Articles by Columnist Michael Aubert




MS SQL Archives

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




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


















Thanks for your registration, follow us on our social networks to keep up-to-date