how to do backup sql 2000

[ccnet101]

i know this is a ongoing tread, but does anyone have any good documents regarding how-to backup sql 2000, or any simple instruction...Thanks in advance

 

[michaelkrauklis]

I work with SQL 2k on a regular basis at work. Whenever we populate from our Paradox database we make backups in three ways:
1) Right click on the database you wish to back up in the enterprise manager. Then go to all tasks. Then Backup Database. It's pretty simple. We make a backup of the database on the hard drive.
2) We then copy the back up file onto a CDRW.
3) We right click once again on the database we wish to backup. Then all tasks again. Then export. We then export all data and objects into another backup database existing on the same server.(you have to have the backup database already created)

That gives us with three backups. We also have another backup. Our production server. I work on the test server and then populate my work to the production server, so in essence when we do anything that might dammage data, we have four backups(five instances) of the database in existance. Two of which are on completely independant media.

good luck MYenigmaSELF
myenigmaself@yahoo.com

http://myenigmaself.gaiden.com

 

[tlbroadbent]

I suggest reading "Backing Up and Restoring Databases" in SQL Books Online. There are several related topics that should get you started. SQL BOL are also available at the Micsoft website.

http://msdn.microsoft.com/library/en-us/adminsql/ad_bkprst_9zcj.asp

http://msdn.microsoft.com/library/en-us/adminsql/ad_bkprst_63eh.asp

Other resources include:

http://www.dell.com/us/en/biz/topics/power_ps4q00-martin.htm

http://www.impetus-sql.co.uk/

http://gethelp.devx.com/techtips/thesqlpro/10min/10min1100/10min1100.asp

Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.