InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 04:25:29 GMT20http://www.sqlservercentral.com/Forums/Topic422013-8-1.aspxHi,Check this link you will have almost all info. about backup and restore.http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlbackuprest.mspxRegards,AhmedWed, 14 Nov 2007 19:31:45 GMTSQL_ABDhttp://www.sqlservercentral.com/Forums/Topic422013-8-1.aspxAlternately, 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.Wed, 14 Nov 2007 19:27:49 GMTK. Brian Kelleyhttp://www.sqlservercentral.com/Forums/Topic422013-8-1.aspxBackup 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 devicesWed, 14 Nov 2007 05:01:23 GMTNeil Gelder-472367http://www.sqlservercentral.com/Forums/Topic422013-8-1.aspxKarthikeyan - 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...:)Wed, 14 Nov 2007 04:51:03 GMTsushilahttp://www.sqlservercentral.com/Forums/Topic422013-8-1.aspxHI, How to back up the database in sqlserver2000 Regards.:kiss: karthikeyan..Wed, 14 Nov 2007 03:51:00 GMTkarthikeyan-507706