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 |
|
barrygt30
Starting Member
2 Posts |
 Posted - 2004-02-16 : 10:23:30
|
| I am adding a new server to the network. It is SBS 2003 (yes, I've got to migrate everything from 4.0). All that aside, I have SQL 7 running on a NT server with a financial application. On the new SBS box I have SQL 2000 running. I have a new version of the financial app that I have installed on the SBS box and and now I need to move the data from SQL 7 to the SQL 2000. Can I just use a backup tape to copy the data from old to new? I know it seems a broad question, but any suggestions would be helpful to me. THanks.Barry |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2004-02-16 : 11:31:46
|
| Backup/restore from v7 -> 2k will work fine.....If the data drives are accessible from both servers across a lan...then a detach on one server/attach on the other server could also work....but that'd leave you with no backup....which probably isn't the wisest. |
 |
|
|
barrygt30
Starting Member
2 Posts |
Posted - 2004-02-16 : 11:42:37
|
| Thanks for the reply. As the SQL 7 is in one domain and the SBS SQL 2000 is in another (and they cannot talk to one another), I'm planning on backing up the SQL 7 and then restoring to SQL 2000. Thanks again.Barry |
|
|
|
|
|
|
SQL 7 to SBS SQL 2000