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 |
|
rongrzywacz
Yak Posting Veteran
57 Posts |
 Posted - 2001-12-19 : 15:27:41
|
| We are planning to upgrade our servers to Sql Server 2000. However I am not sure that I can do the upgrades all in the same week. Is there a way to restore a backup from SQLserver 2000 db to a SqlServer 7.0 server Thanks for any assistance.Ron G.Ron Grzywacz |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2001-12-19 : 15:48:43
|
| No,But you can go the other way around. SQL 7.0 backups can be restored to SQL 2000.HTH-Chad |
 |
|
|
rongrzywacz
Yak Posting Veteran
57 Posts |
Posted - 2001-12-19 : 15:56:36
|
| Can I use replicaton to replicate the changes from SQL2000 to SSQL 7.0. Ron Grzywacz |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2001-12-19 : 16:00:34
|
| You can have a 7.0 subscriber to a 2000 DB. Or you can use DTS to copy the data back and forth.-Chad |
|
|
|
rongrzywacz
Yak Posting Veteran
57 Posts |
Posted - 2001-12-19 : 17:02:37
|
| What are the performance implications for doing replication on a 15 gig database. We have about 120 users hitting the db for mostly retrieval operations. Were adding about 10-20 meg of data a day. But it is a 24/7 operations. Would it be hard to manage with 2 different versions of SQL server. If I were to lose one of the databases, how would I get them back in sync. Tanks for any help!Ron Grzywacz |
|
|
|
|
|
|
Can I restore SqlS 2000 db backup to SQLS 7