Search
| Login
corner corner
Relevant Links
corner corner
corner corner
Subscribe To Feed
corner corner
corner corner
Search Articles
corner corner
corner corner
Topics
corner corner
corner corner
Article List
corner corner
corner corner
Article Archive
corner corner
corner corner
Survey
Which platform does your company use?



Submit Survey  View Results
corner corner
corner corner
Relevant Links
corner corner
corner corner
Easy Upgrade SQL Server 2000/2005 to SQL Server 2008
Location: BlogsCubicZoneSQL    
Posted by: cubiczone 10/31/2008 8:26 AM

SQL Server 2008 is 100% backward compatible with SQL Server 2005. Simply take a full backup in SQL Server 2000\2005. Copy the backup files to the new server and restore from the backup. Change the compatibility level to 100.0 and run sp_updatestats. Everything should run as normal.

Permalink |  Trackback

Your name:
Title:
Comment:
Add Comment   Cancel 
corner corner