Home > IT Answers > SQL Server > Use of database backup from lower version to higher version of sqlserver
Vineet28
20 pts.
 Use of database backup from lower version to higher version of sqlserver
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
ASKED: September 23, 2011  6:18 AM
UPDATED: March 31, 2012  1:15 AM
RELATED QUESTIONS
Answer Wiki:
Just take the backup file, copy it to the SQL 2008 server and restore it. SQL Server will upgrade the database for you automatically.
Last Wiki Answer Submitted:  September 26, 2011  2:05 am  by  Denny Cherry   64,550 pts.
All Answer Wiki Contributors:  Denny Cherry   64,550 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

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.

carlosdl
 63,580 pts.