Thursday, February 16, 2012

Backup/copy of sql server 2000 DB

Hi people!!
I was wondering how u can copy a sql server database (to make a backup) on to either a CD or floppy(dunno if theres enough disk space for that)?
ThanksHi,
you can make a backup of the database to disk and copy that to a cd
Command : backup database name of database to disk='c:\backup.bak'
or you can copy the fysical database file's to cd
then you have to copy the MDF and LDF files to cd

Lambik

No comments:

Post a Comment