August 31, 2007 at 4:45 am
I manually (or SQL transact) make a backup of my DB in 2000 and restore it in 2005 with the norecovery option.
I than make transaction logs in 2000 and ship them to 2005 where I apply the logs.
The problem is, that I can not read the data in 2005 and at the same time want to apply logs.
I only can set the database to recovery to read the data. But then I can not apply new logs.
Any idea how I both can apply the logs and after applying the logs setting the state of the database in 2005, so I can read from it?
Kind regards
Uwe
August 31, 2007 at 5:17 am
The system tables between 2000 and 2005 have changed quite a lot. The transaction log very much relies on these tables, so this difference prevents log shipping between 2000 and 2005. You can only log ship between the same versions.
Regards,
Andras
August 31, 2007 at 9:50 am
In addition to Andras comment, in the event of a failover the sql 2005 which is currently the secondary server will become the primary server and once everything is fine and the sql 2000(original primarry is up) you cannot restore the sql 2005 backup to sql 2000 as result log shipping cannot continue anymore............
fyi, http://sql-articles.com/articles.php for log shipping articles in sql 2005
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=146&messageid=281187 which deals with the same topic as discussed here
[font="Verdana"]- Deepak[/font]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply