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 |
|
timanji
Starting Member
1 Post |
 Posted - 2007-03-05 : 20:31:28
|
| Hi all, I'm hoping someone can help me out. I'm totally new to SQL server.I wanted to upgrade this one server that was running SQL 8.0. I did an install of SQL2005 (9.0 right?) and it appeared to go well. But once it was completed I found out that the original installation of SQL was on a different drive. So instead of upgrading, I actually installed another instance of SQL? (Is that term correct?) So now when I open SQL2005, it shows the server name but with (SQL Server 8.0.2039) next to it.How can I now upgrade the databases themselves?Please help!thanks!-tim |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-03-06 : 06:16:58
|
| You should be able to restore Backups from SQL 2000 into SQL 2005.However, this will not transfer the logins or any scheduled or DTS jobs.You may be better to uninstall SQL 2005 and re-install it as an upgrade so that the databases are converted - including the bits mentioned above.Kristen |
 |
|
|
|
|
|
upgrading to 2005