Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2007
    Posts
    2

    Unanswered: An internal consistency error occurred..

    Hi all,
    i have copied out the database backup from development center to my local machine,it is having approx.8GB in size and when
    i m trying to restote this database backup in SQL Server 2000 it is showing me error.
    An internal consistency error occurred. Contact Technical Support for assistance.
    RESTORE DATABASE is terminating abnormally.

    Plz. anyone can help me..


    mukul

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Run RESTORE VERIFYONLY to ensure the backup is valid, and KBA http://support.microsoft.com/kb/268481 for further information. Try getting another set of backup to assure the source database server hardware is intact.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Jul 2007
    Posts
    2

    an internal consistency error occurred..

    Hi Satya,
    i have run RESTORE VERIFYONLY command and after this is showing following msg-
    Server: Msg 3242, Level 16, State 2, Line 1
    The file on device 'g:\backup\projectServer\ProjectServer_db_20070709 0000.bak' is not a valid Microsoft Tape Format backup set.Server: Msg 3013, Level 16, State 1, Line 1
    VERIFY DATABASE is terminating abnormally.
    then what is this mean?
    plz. help me out..

Posting Permissions

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