How to do log shipping when SQL server versions are different?
0
votes
2
answers
1301
views
I have SQL2014 version database on my Windows12 server. I want to add the databases in SQL2014 to SQL 2022 on my Windows2016 server using the Log Shipping method. Since the versions are different, I think I had to select No Recovery Mode instead of Standby Mode in the "Restore Transaction Log" section. I also selected No recovery mode, but I could not access the database added from SQL 2022 on my Windows 2016 server. How can I access SQL2014 databases from SQL2022 database with Log Shipping?
Asked by Merve
(57 rep)
Feb 6, 2024, 03:15 PM
Last activity: Sep 17, 2024, 02:29 PM
Last activity: Sep 17, 2024, 02:29 PM