Post reply

Backup steps

  • May 1, 2006 at 6:34 am

    #366086

    Good morning all ,

     

    First of all, I introduce myself. Ina and I am newbie DBA. I have a problem with sql server backup , practically I would like to backup my database simply.

    I went to my database and I clicked with the right button of mouse and I choose the option backup databases then I choose the full backup and I add a location in E:/MsSQL/Backup/ (database) everything ok but when I pressed ok I had this error message:

     

    THE VOLUME ON DEVICE E:/MSSQL/BACKUP/20060501MYDATA/IS NOT PART OF MULTIPLE FAMILY MEDIA SET BACKUP WITH FORMAT CAN BE USED TO FORM NEW MEDIA SET. DATABASE IS TERMINATING ABNORMALLY.

    THIS IS THE SQL SCRIPT:

    BACKUP DATABASE [PORTFOLIO] TO [MYDATADISK] WITH  NOINIT ,  NOUNLOAD ,  NAME = N'MYDATA backup',  NOSKIP ,  STATS = 10,  NOFORMAT

    I do not know how to do ? Could someone help me in this topic ?

    Ina

  • May 1, 2006 at 11:53 am

    #635179

    The error message was pretty clear. You need to do the backup allowing it do FORMAT the file first.

    I suggest you read the BOL for information on doing backups and script them yourself. It will help you understand them better and improve your troubleshooting ability.

    Use the index tab in the Books OnLine and enter BACKUP DATABASE.

    -SQLBill

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply