InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 21:38:43 GMT20http://www.sqlservercentral.com/Forums/Topic1420638-1549-1.aspxWhile this will work, it is not a recommended configuration.Two reasons. - You can only restore WITH NORECOVERY, hence you can't use the logshipping secondary for reporting- If you ever fail over to the secondary (the primary fails), it's a one-way failover and you will NOT be able to fail back to the primary without upgrading that to SQL 2008 R2 first. Hence any DR usage is essentially a permanent move of the production DB.Since log shipping is usually used for reporting or failover in the case of a disaster, a up-version log shipping is a rather poor idea since it works for neither.Mon, 18 Feb 2013 02:32:35 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1420638-1549-1.aspxYou can restore a backup to a more recent version of SQL but you CANNOT go the other way. This means that any backup done on your secondary (SQL 2008) server CANNOT be restored to the SQL 2000 server. This is by design - there are significant differences between the versions of SQL Server and the restore process makes those changes on the fly as the restore is executing. Why are you wanting to implement log shipping between SQL 2000 and SQL 2008 ?Sun, 17 Feb 2013 20:20:20 GMThappycat59http://www.sqlservercentral.com/Forums/Topic1420638-1549-1.aspxnoFri, 15 Feb 2013 19:37:00 GMTSimha24http://www.sqlservercentral.com/Forums/Topic1420638-1549-1.aspxwhy do you want to log ship between 2000 and 2008, do you understand the ramifications of doing this?Fri, 15 Feb 2013 10:04:17 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic1420638-1549-1.aspxI didnt get you....They wanted to have backups of logshipping database aswell.Fri, 15 Feb 2013 09:57:10 GMTSimha24http://www.sqlservercentral.com/Forums/Topic1420638-1549-1.aspx[quote][b]Simha24 (2/15/2013)[/b][hr]I am going to implement log shipping between 2000 (primary ) and 2008 R2 (secondary).[/quote]Why???Fri, 15 Feb 2013 09:56:06 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic1420638-1549-1.aspxI am going to implement log shipping between 2000 (primary ) and 2008 R2 (secondary).I found there are regular backups are running in primary server .....I told them to stop regular backups when logshipping configured (beacuse when regaular backups are running on primary server secondary server will catchup proper logfiles ) but my customer asking bellow set off Questions to answers.1. Why they want to exclude the DB’s from the regular backups?2. How long will it take to complete the logshipping?3. When will this DB’s be included in the regular backups and when the backup’s for these database will be available.? I have a answers for Question 1 and 2....Can someone answer for Question 3....Is it possible to take backups in secondary server which is stanby modeFri, 15 Feb 2013 09:49:11 GMTSimha24