Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.


share|improve this question

migrated from Mar 21 '11 at 12:35

This question came from our site for professional and enthusiast programmers.

Voting to move this to - our site for Administrators. – Raj More Mar 21 '11 at 12:31
You should accept answers to some of your past questions. Not only will this show your appreciation for the people who spent their own time to help you, but it will improve your accept rate and the chances that they will answer any future questions you may have. – marc_s Mar 21 '11 at 12:34
up vote 3 down vote accepted

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!

share|improve this answer
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? – user75231 Mar 21 '11 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). – 3molo Mar 21 '11 at 13:10
user75231: no need to run anything, it will work as it is. – 3molo Mar 21 '11 at 13:10
One thing that I would normally do is to run sp_changedbowner to change dbo to an existing user. – Nils Magne Lunde Mar 21 '11 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? – user75231 Mar 21 '11 at 13:17

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.