database backup

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » T-SQL » database backup

database backup

Rate Topic

Display Mode

Topic Options

Author

Message

karthikeyan-507706

Posted Wednesday, November 14, 2007 3:51 AM

SSC Veteran

Group: General Forum Members
Last Login: Friday, September 12, 2008 2:36 AM
Points: 230, Visits: 31

HI,

How to back up the database in sqlserver2000

Regards. Kiss

karthikeyan..

Post #422013

sushila

Posted Wednesday, November 14, 2007 4:51 AM

SSCrazy

Group: General Forum Members
Last Login: Friday, May 17, 2013 6:44 AM
Points: 2,553, Visits: 513

Karthikeyan - your first stop should be Books Online - it has a wealth of information - you will be backing up databases in no time at all with a 5 minute dekko...:)

**ASCII stupid question, get a stupid ANSI !!!**

Post #422037

Neil Gelder-472367

Posted Wednesday, November 14, 2007 5:01 AM

SSC Veteran

Group: General Forum Members
Last Login: Thursday, October 20, 2011 8:59 AM
Points: 269, Visits: 108

Backup database 'dbname' to disk = 'C:\pathname'

is the basic why but I would look on BOL for the extras like the different type of backups, adding backup devices

Post #422040

K. Brian Kelley

Posted Wednesday, November 14, 2007 7:27 PM

Keeper of the Duck

Group: Moderators
Last Login: Wednesday, May 08, 2013 5:14 AM
Points: 6,583, Visits: 1,787

Alternately, if you are in a rush and have to get the job done, Enterprise Manager can walk you through taking a backup using a GUI. However, if you're going to be doing this even somewhat frequently, you should learn the BACKUP command, the various options, and also, how to restore from backup and how to recover as much data as possible in case of a failure.

K. Brian Kelley, CISA, MCSE, Security+, MVP - SQL Server
Regular Columnist (Security), SQLServerCentral.com
Author of Introduction to SQL Server: Basic Skills for Any SQL Server User
| Professional Development blog | Technical Blog |

LinkedIn | Twitter

Post #422416

SQL_ABD

Posted Wednesday, November 14, 2007 7:31 PM

Ten Centuries

Group: General Forum Members
Last Login: Friday, February 15, 2013 6:29 PM
Points: 1,326, Visits: 1,265

Hi,
Check this link you will have almost all info. about backup and restore.
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlbackuprest.mspx

Regards,
Ahmed

Post #422418

« Prev Topic | Next Topic »

Permissions