November 14, 2007 at 3:51 am
HI,
How to back up the database in sqlserver2000
Regards.:kiss:
karthikeyan..
November 14, 2007 at 4:51 am
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 !!!**
November 14, 2007 at 5:01 am
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
November 14, 2007 at 7:27 pm
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
@kbriankelley
November 14, 2007 at 7:31 pm
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
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply