Results 1 to 9 of 9
  1. #1
    Join Date
    Mar 2004
    Location
    bangalore, india
    Posts
    6

    Post Unanswered: MS SQL Server 2000... Error backing up database

    Hi

    I am getting an error while backing up a particular database named "asset" . The error says ........

    Server: Msg 3132, Level 16, State 1, Line 4
    The media set for database 'Asset' has 2 family members but only 1 are provided. All members must be provided.
    Server: Msg 3013, Level 16, State 1, Line 4
    BACKUP DATABASE is terminating abnormally.

    I have created two backup devices for this database ("asset") through enterprise manager.
    AssetDMP
    AssetLogDMP

    I have total 9 databases out of which only this database throws error. All other database backups going fine.

    Here is the query that I am using to backup the database and Log.

    USE master
    GO
    IF EXISTS (SELECT * FROM sysdatabases WHERE name = 'Asset')
    BACKUP DATABASE Asset TO AssetDMP WITH NOUNLOAD, STATS=10, INIT, SKIP
    GO
    IF EXISTS (SELECT * FROM sysdatabases WHERE name = 'Asset')
    BACKUP LOG Asset TO AssetLogDMP WITH NOUNLOAD, STATS=10, INIT, SKIP



    Please Help

    Thank You / Ssg

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    This error occurs if a member of the stripe set (the backup was performed to more than 1 backup file/device) that was originally used to create the backup, was not selected when you tried to perform the restore. The number that displays in the message shows the set or file number that is missing.

    You need to provide all the backup devices, files in your restore command
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Mar 2004
    Location
    bangalore, india
    Posts
    6
    Originally posted by Satya
    This error occurs if a member of the stripe set (the backup was performed to more than 1 backup file/device) that was originally used to create the backup, was not selected when you tried to perform the restore. The number that displays in the message shows the set or file number that is missing.

    You need to provide all the backup devices, files in your restore command
    Dear Satya,

    Thanks a lot for your quick response. This issue has been resolved by re creating the devices ; but somehow I could not understand the root cause of the problem . Anyway, I wanted to ask one more question here...

    I am using MS SQL 2000 Server. Can I move the dabases ( Master, Model , MSDB and tempdb) to a different drive location without re-installing SQL Server !!!

    Waiting for an early reply...

    Thanks again,
    Ssg

  4. #4
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Here you go with this KBA .
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  5. #5
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    BTW where abouts you're in Bangalore??
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  6. #6
    Join Date
    Mar 2004
    Location
    bangalore, india
    Posts
    6
    Originally posted by Satya
    BTW where abouts you're in Bangalore??
    Thanks Satya,

    My Question has been answered. Great help !!!

    I am in ShanthiNagar , Bangalore -27

    R U Familiar with BLR ?? I mean r u a bangalorean ?

    Tks / Ssg

  7. #7
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578

    Thumbs up

    Glad this works... I sent you private message as its ideal for personal chat.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  8. #8
    Join Date
    Mar 2004
    Location
    bangalore, india
    Posts
    6
    Originally posted by Satya
    Glad this works... I sent you private message as its ideal for personal chat.
    satya,

    I don't find any private mesg.. It shows empty..however you can mail me.

    Thanks
    Ssg

  9. #9
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    My PM tracking confirms an email sent to you about this Private message, check the email when you registered to this site.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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