2

I am not a DBA. I will be doing this for the first time. So I am not sure what all I am supposed to do?

I will be restoring sql server 2000 database to sql server 2008. Are there anywhere step by step instructions to do this?

I know I am supposed to change compatibility mode, rebuild indexes on all the tables.

It will really help me if there are step by step instructions.

Thanks!!!

Improve this question
1
  • 1
    Voting to move this to ServerFault.com - our site for Administrators. Commented Mar 21, 2011 at 12:31

1 Answer 1

Reset to default
3

You can use SQL Server Management Studio to do this.

  1. Right-click on the Databases node
  2. Select "Restore Database"
  3. Enter the name of the database to restore
  4. Select "From device" and add the backup file in the next dialog
  5. When returning to previous dialog, make sure to check the Restore check-box at the left side of the database name
  6. Click "OK" to restore the database
  7. Right-click the newly imported database and select properties
  8. Select Options in the menu and on the right side you will get the option of changing the compatibility level.
  9. Select the compability level required for your applications

Hope it helps!

Improve this answer
9
  • I know these basic stepd but can you tell me what other scripts I am supposed to run after upgrade? like rebuild indexes on all tables or anything else? Commented Mar 21, 2011 at 13:10
  • User643062: Remember that logins are not imported, even thou users are (as you can't restore the old master db over the new master db, given the sql versions, iirc). Commented Mar 21, 2011 at 13:10
  • user75231: no need to run anything, it will work as it is. Commented Mar 21, 2011 at 13:10
  • One thing that I would normally do is to run sp_changedbowner to change dbo to an existing user. Commented Mar 21, 2011 at 13:16
  • user 3molo thanks for your quick reply. I know about logins not getting imported. When I ran test of restore last week and some of crystal reports were running very slow on this restore somebody asked me did you rebuild all indexes? update statcis? So I was not sure What all I need to do after upgrade? Commented Mar 21, 2011 at 13:17

You must log in to answer this question.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.