Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2016
    Posts
    1

    Unanswered: Error While Attaching Database on SQL Server 2008R2

    Hi there,

    I am getting an error while attaching database. This database is designed in SQL Server 2008R2 and was working perfectly.

    Please help me out.

    Thanks
    Shahbaz Ladak
    Attached Thumbnails Attached Thumbnails AttachFileError.JPG  

  2. #2
    Join Date
    Mar 2015
    Posts
    61
    Provided Answers: 4
    Try doing a restore verify only. Also what did the error log say was the problem?

    RESTORE VERIFYONLY
    FROM <backup_device> [ ,...n ]
    [ WITH
    {
    LOADHISTORY

  3. #3
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,862
    Provided Answers: 17
    I am not sure that will work with just an MDF file.

    Are you certain that the server this MDF file came from was running SQL 2008 R2? Do you have a later edition of SQL Server to try attaching it to?

    Also, was the database detached using the detach command? Or was it copied while the server (and database) were both online?

Posting Permissions

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