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 |
|
cleech
Starting Member
2 Posts |
 Posted - 2007-06-07 : 09:33:52
|
| Hello All:From my previous post it seems that the general consensus is for me to use backup and Restore to upgrade a dB from SQL2K to SQL2K5.Could anyone refer me to some explicit instructions for doing this? I have SQL2K5 and SQL2K on separate servers and I cannot back the dB up to SQL2K5. I also can't access the drives for SQL2K from SQL2K5. I'm hoping it's a simple mistake. Any advice or guidance is greatly appreciated.Thanks,Cleech |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-06-07 : 12:10:34
|
| Backup the DB, copy the files over to the new server and restore from there.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-06-07 : 12:20:24
|
You need to make a backup file on the SQL2000 box.Somehow you need to transfer that file to the SQL 2005 box. Obviously network cable is the fastest route! But sticking in on a USB stick is good too  Then you can restore the file once it is on the SQL 2005 box.The SQL 2005 Server can directly restore from a file on anything that it can "see" across the network, so the backup files doesn't actually have to be ON the SQL 2005 box. But getting the Backup file onto the SQL 2005 box is DEFINITELY the easiest option - there are all sorts of pitfalls that you may fall into trying to Backup, or Restore, ACROSS the networkKristen |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-08 : 01:02:45
|
| If you start sql service with domain account for sql2k, should be able to backup db to sql2k5 server as long as they are in same domain. |
|
|
|
|
|
|
Upgrade to SQL2K5 using Backup/Restore