Use of database backup from lower version to higher version of sqlserver

20 pts.
Tags:
Microsoft SQL Server 2000
SQL Server 2008
SQL Server database
I am using sqlserver 2000, have a database of 2GB. I want to shift at higher version 2008. What I have to do TO upload my Old version-2000 database backup  into  sqlserver 2008

Software/Hardware used:
sqlserver2000 and 2008r2

Answer Wiki

Thanks. We'll let you know when a new response is added.

Just take the backup file, copy it to the SQL 2008 server and restore it. SQL Server will upgrade the database for you automatically.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    As far as I remember, you could use detach and attach to upgrade from 7 to 2005. Not sure if that holds true for 2008.
    69,475 pointsBadges:
    report
  • Vineet28
    [...] Mrdenny and Carlosdl help a member use a database backup from lower version to higher version of SQL Server. 6. Need to use ENDJRN all at once? CharlieBrowne submitted an answer that was [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following