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 |
|
sassaidi
Starting Member
7 Posts |
 Posted - 2004-09-29 : 13:23:33
|
| Hi,I am having a problem with my custom Log Shipping from a sql 7 to a sql 2000 box. SQL Server will not let me restore the database with the "NORECOVERY" option so I can apply transaction logs to it. I guess it needs to convert the database to a sql 2000 DB.1. Any suggestions on how I can do log shipping between the 2 servers?2. Can I just install SQL 7 on the SQL 2000 box (have both versions running)?Thanks for you help! |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2004-09-29 : 16:01:33
|
| You can install bot on 1 machine (7.0 has to be the default instance). I'm not sure how that helps you though.-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-09-29 : 18:11:24
|
| Why are you log shipping from SQL Server 7.0 to 2000? And yes it will upgrade it from 7.0 to 2000 upon restore.Tara |
|
|
|
|
|
|
Custom log shipping from SQL 7 to SQL 2000