Post reply

Log Shipping

  • October 21, 2008 at 11:56 am

    #154830

    Hello there,

    I ran into problem with Log Shipping. Whenever I try to configure logshipping this is the error I get

    An exception occurred while executing a Transact-SQL statement or batch. (SqlManagerUI)

    The media family on device '\\SERVERNAME\backup\Adventure.bak' is incorrectly formed. SQL Server cannot process this media family.

    RESTORE FILELIST is terminating abnormally. (.Net SqlClient Data Provider)

    I have Microsoft SQL Server 2008 (CTP) - 10.0.1442.32 (Intel X86) May 30 2008 00:02:15 Copyright (c) 1988-2007 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2) as primary server and

    Microsoft SQL Server 2005 - 9.00.3073.00 (Intel X86) Aug 5 2008 12:31:12 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2) as secondary server. Both instances are on the same machine.

    Can any one please help. I also tried to change compatibility level to 90 and tried, and logs are shipping from the 2008 to 2005 instance, so I guess that won't be a problem.

    Thanks all.

  • October 21, 2008 at 12:02 pm

    #887768

    I am suspecting how can you restore SQL Server 2008 database on SQL Server 2005 coz reverse compatibility is not what SQL Server supports.

  • October 21, 2008 at 12:05 pm

    #887771

    I thought by changing compatibility level you can but i might be wrong. So is it possible to do logshipping between 2 different editions of the SQL Server?

  • October 21, 2008 at 12:08 pm

    #887773

    From 2005->2008 Yes , but not 100% vice versa

  • October 21, 2008 at 12:14 pm

    #887775

    Thank you very much nary. It just worked out fine.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply