Results 1 to 8 of 8
  1. #1
    Join Date
    Mar 2005
    Posts
    2

    Unanswered: restoring the database

    Hi,

    Two of my hard drives went down yesterday. and with it went the Sql server database.The data recovery guys recovered the back up database (.bak) file.I have since reinstalled SQL Server 2000 and now when i try and restore the .bak file it says the Microsoft tape back up file set is not valid when i try and open the .bak file.

    Whats the right way to add my databse to the SQl Server2000 using my .bak file and if anyone has come across the error they could help.


    Thanks

    L

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Did you apply all SPs that your old server used to have?
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  3. #3
    Join Date
    Mar 2005
    Posts
    2
    what do u mean by sps

  4. #4
    Join Date
    Oct 2003
    Posts
    357
    Quote Originally Posted by lohit
    what do u mean by sps
    Stored Procedure
    Madhivanan

    Failing to plan is Planning to fail

  5. #5
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    It's "Service Packs", not stored procedures...how do you apply a stored procedure anyway?
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  6. #6
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734
    Restore the databases...which she can't do. DOH!!!

    You should always verify your backups, especially if writing directly to tape. Any luck though after applying the service packs? Don't you guys have a DBA who can help with this?
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

  7. #7
    Join Date
    Oct 2003
    Posts
    357
    Quote Originally Posted by rdjabarov
    It's "Service Packs", not stored procedures...how do you apply a stored procedure anyway?
    Yes. It should be Service Packs
    Madhivanan

    Failing to plan is Planning to fail

  8. #8
    Join Date
    Mar 2005
    Location
    Philippines, Makati
    Posts
    11
    Hi Lohit,

    hows was your process of restoring the backup?

Posting Permissions

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