Logshipping between ms-sql server 2005 to 2000 Box | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Logshipping between ms-sql server 2005 to 2000 Box

wanted to set up a logshipping between MS-SQL-Server 2005 to a box running under MS-SQL-Server 2000. any special inputs for this…?
may be any link providing some input …
You can’t do the log shipping from sql 2005 to sql 2000…
Only option would be transactional replication…
MohammedU.
Microsoft SQL Server MVP
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.
.. this is because you cannot restore or downgrade SQL 2005 to 2000 using native backup/restore methods. If you need to downgrade the upgraded db thenhttp://sqlserver-qa.net/blogs/tools…2005-database-to-sql-server-2000-version.aspx fyi. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
@http://www.askasqlguru.com/ This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
]]>