Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
1sqlover
Yak Posting Veteran
56 Posts |
 Posted - 2007-11-30 : 14:02:04
|
| Hello everyone, I am upgrading from SQL Server 2000 to SQL Server 2005. Any caveats? Can I just detach the db's and attach them into 2005. Or is there any conversion I should run or import first?Thanks, |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-11-30 : 14:10:27
|
| There is a checklist of steps or best practices you have to follow. Search in these forums and you will find discussions regarding the upgrade.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-11-30 : 14:10:34
|
| If you intend to use 2005 features, then you need to change the recovery model to 90 for each of the user databases.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
1sqlover
Yak Posting Veteran
56 Posts |
Posted - 2007-11-30 : 14:51:53
|
| Well I have looked and have not found what I am looking for.I want to upgrade databases from an old server to a new server. All I have found is references to upgrading the server not the dbs.Thanks, |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-11-30 : 15:32:36
|
| http://www.sqlteam.com/article/notes-from-an-upgrade-to-sql-server-2005Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
Upgrading to SQL 2005 from 2000 - seeking advice