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 |
|
sqlxpert
Starting Member
11 Posts |
 Posted - 2002-04-01 : 22:37:26
|
| Can we implement a standby server from sql server 7.0 to sql server 2000. |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-04-01 : 22:44:47
|
| Short answer : YesLong answer : If you give some more information you will get a better answer.You should be able to replicate bewteen these servers fine, or use DTS. And your code should work as long as you haven't used SQL2000 exclusive features.Damian |
 |
|
|
sqlxpert
Starting Member
11 Posts |
Posted - 2002-04-02 : 16:26:10
|
| Hi MerkinFirst thing is that the source is sql 7.0 and destination is sql 2000 and the problem is that the database of version 7.0 cannot be restored onto sql 2000 in standby or no recovery mode, I need to have this restration in palce if some one can help.AB |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-04-02 : 23:03:16
|
| If you can not do replication on the servers, then I would suggest either upgrading your 7.0 to 2000 or bring your 2000 back to 7.0. You want to have them running on the same version if you want to be moving backups between them.Before you say "I can't upgrade", ask yourself this . how much is it worth to you ?If it is your mission critical system, then you will do what it takes.Damian |
|
|
|
sqlxpert
Starting Member
11 Posts |
Posted - 2002-04-03 : 18:41:32
|
| Hi Due to some constraints production server can not be upgraded to 2000 but the requirement is due to a fact that there is a report required hourly from production which takes around 9 min on SQL 7 sp3 and same takes 5 sec on 2000 , so to make the reports from 2000 and to make this in sync with production log shipping is required. Also this can be done as per microsoft by changing a db option but that is also of no use in my case do I wanna just confirm if this can be done.AB |
|
|
|
|
|
|
Standby Server from 7.0 to 2000