Post reply

Moving database from one computer to another using backup and restore

  • April 12, 2005 at 11:59 am

    #109466

    I moved a SQL Server 2000 database from a old computer to a new computer using backup and restore, but on the new computer none of the stored procedures I had previously written could be found.

    How could I get a full copy of the database including the stored procedures on the new computer.

    Thanks in advance

     

     

  • April 12, 2005 at 11:48 pm

    #552294

    If you backed up the entire database and logs, it should restore all the objects in the database, including your stored procedures.

    However, your logins may be screwed (as the Sql server internal UserID on one machine is probably different to the next).

    Try running

    EXEC sp_change_users_login 'Auto_Fix', 'username'

    for each of the users in your database, changing username

    then see if you can see your sprocs again.

    Julian Kuiters
    juliankuiters.id.au

  • April 13, 2005 at 4:15 pm

    #552552

    Thanks, I got it done.

    You were correct that all objects in the database should have been restored if the restore was done correctly.

    As it turned out, I restored the database again, and the problem went away.

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

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