Post reply

Restore SQL 2000 db to SQL 2005

  • November 15, 2007 at 11:20 am

    #122446

    Hi All,

    I am getting the following error when I try to restore db with the script (Restore 2000 DB to 2005):

    Msg 3176, Level 16, State 1, Line 1

    File 'F:\0\1\27\147\1353473\meta\1451272\mssqlash' is claimed by 'nash_log'(2) and 'nash_dat'(1). The WITH MOVE clause can be used to relocate one or more files.

    Msg 3013, Level 16, State 1, Line 1

    RESTORE DATABASE is terminating abnormally.

    I did check and there is only one .mdf and one.ldf file before backup is performed.

    Interesting fact: the script restore some of the databases but not all them.

    Any help appritiated.

    Nash

  • November 16, 2007 at 12:33 pm

    #751954

    It sounds like a file conflict.

    Can you manually restore the file.

  • November 16, 2007 at 7:42 pm

    #752024

    This has been resolved thanks to David,

    Nash

    P.S. Thank you David!!! You are the best!

  • November 19, 2007 at 10:31 am

    #752409

    Hello Everyone,

    I am having the same problem:

    Can you post how you resolved it?

    Thanks

  • November 20, 2007 at 4:41 am

    #752594

    John,

    How are you trying to restore? Via the GUI or via T-SQL?

    Also, did you check the sys.files table on the database in question? See what files SQL Server thinks this db should have?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • July 14, 2008 at 11:24 pm

    #842807

    Hi all,

    I was facing same problem of "claimed by" error.

    There was a silly mistake which i saw very late.

    Actually what is happening is in sql sever 2000 when you restore a database the .mdf file names do not change whereas in sql server 2005 when you restore a database with other name in the same server the mdf file names become same as database name.

    Just check if multiple mdf's name are same in Options tab.

    Change it and you will be done through.

    Bhoomi.

Viewing 6 posts - 1 through 5 (of 5 total)

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