Post reply

Backup not working.

  • May 19, 2004 at 8:47 am

    #161338

    Hello,

    I am not a SQL person - just the lucky one that has to manage an application that uses a SQL db.  I know just enough to be dangerous.  So, I have been able to do a back up of my database in the past - and I even scheduled one to run weekly - but I have to do an application upgrade and I need to back up my db.  This is the error I am getting - can someone please assist me ?

     

    Microsoft SQL-DMO (ODBC SQLState: 42000)

    The media set for database ‘intranet’ has 2 family members but only 1 are provided.  All members must be provided.

    BACKUP DATABASE is terminating abnormally.

     

    Thanks in advance for your help!

  • May 19, 2004 at 9:55 am

    #506972

    1st.  I am not sure what type of backup you are doing.  Let's get you going by creating a new backup device.

    USE masterEXEC sp_addumpdevice 'disk', 'mydiskdump', 'c:\dump\dump1.bak'
    after you create the backup device, issue a backup command:
    BACKUP DATABASE intranet TO mydiskdump with init
    This will backup your intranet database to mydisdump device with initialize(over write).
    After you finish your backup, you need to copy your backup file to different location or backup it to tape.
     
    I would advise that you backup your database and log at a minimum once a day and copy it off site as a good practice.
    I usually set up a sql agent job to backup database a log so that it doesn't take up more of your time, and maybe have it send notification to you if the job failed.
    Good luck.
     
    mom

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

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