Post reply

Restore sql server 2005 databse to 2008 cant excute procedure

  • January 2, 2011 at 6:05 am

    #232566

    Hi all

    Why the old server name conflicts any solutions to avoid refernce to old server name.i am in fact a developer not a db admin

    • This topic was modified 5 years, 1 month ago by master.

  • January 2, 2011 at 8:33 am

    #1268297

    Did you backup and restore using T-SQL or SSMS Wizard? If using the wizard, then during restore ensure on 'Options' tab, in 'Restore As' grid, the name of the .mdf and .ldf files are updated to the new database name. You can manually edit the names.

  • January 2, 2011 at 8:40 am

    #1268299

    i dont want to change the database name,i want to avoid the server name reference in the backed up databse,and resore it to a new server with various name

  • January 2, 2011 at 12:18 pm

    #1268319

    Or are you missing a linked server that existed on the old server?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • January 2, 2011 at 8:58 pm

    #1268353

  • January 2, 2011 at 9:19 pm

    #1268355

    hi

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

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