Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    30

    Unanswered: 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)???

    Thanks

  2. #2
    Join Date
    Aug 2003
    Posts
    9
    Hi,
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •