Post reply

backup and restoring after upgrade

  • March 26, 2007 at 7:18 pm

    #176892

    I used backup and restore to upgrade to sql 2005 from 2000. It went well but I didn't get the permissions change in time for the users to access the database today. The users were accessing the old server. I need to do another backup off the old server to the new server. Do I do a full backup to get the information for today's data or what? Will it restore a full backup override?

     

  • March 26, 2007 at 10:19 pm

    #697043

    Full backup is required if your dbs are recovered on sql 2005...

    You need to copy the logins also after restore...

    Check the following article for login transfer...

    How to transfer logins and passwords between instances of SQL Server

    http://support.microsoft.com/kb/246133

     

    MohammedU
    Microsoft SQL Server MVP

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

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