Post reply

Restore a full database to new SQL server - issues

  • October 10, 2006 at 2:56 am

    #153224

    Hi,

    I have to do the following : Database X on server X needs to be restored to server Y, the database name also needs to change to Y.

    I have successfully restored the database this way because the directory structure between server X and Y are the same. I receive no errors during the restore and upon comparing the tables / stored procedures it seems like everything is there. I use the restore database procedure available by right clicking the Databases folder and selecting All tasks and then "Restore database..." inside Enterprise Manager.

    The problem : Even though the server reports a successful restore of the database my developers cannot execute a known good query once the database is imported in the new environment. The only difference here is that the source server is SQL Enterprise and the Destination is SQL Standard.

    What could be the issue ?

    Thank you.

  • October 10, 2006 at 3:22 am

    #664945

    i have figured it out

    the query is using a stored procedure. i checked the conent of the sp on the destination server and for some reason it's empty. during my testing i've restored this database to 4 different sql servers. this particular sp did not make it to the source server in any of the above instances.... very weird, i dont know why this is / was the case

    anyway i simply copied the sp from the source to the destination manually and viola !

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

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