Transferring log records from a source database system to one or more destination systems.
Questions tagged [log-shipping]
330 questions
1
vote
1 answer
Sql logshipping Last_restored,last_copied file null in sysjobhistory
I have started log shipping for few dbs from production to DR recently, but it seems like the jobs just keep running and sometimes the copy job copies few files, sometimes it says the files already exists, the restore job sometimes says skipping…
user107077
- 11
- 3
1
vote
1 answer
Transaction Log file of the secondary database in Log Shipping grows fast and fills up disk space
I have a log shipping setup for DR. The transaction log file of one of the secondary databases, which is in restoring mode, is 7 times larger than the data file and is filling up the disk space. What are the possible causes and fixes?
Note that it…
Mesfin
- 11
- 2
0
votes
1 answer
How to do log shipping when SQL server versions are different?
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…
Merve
- 55
- 3
0
votes
2 answers
Log shipping to fix unintended deletion?
I am reading the book 'Pro SQL Server 2019 Administration' from Carter:
In a scenario in which a user accidentaly deletes data; he mentions that we can recover the data (from the DR server) and then "repopulate the production server".
Then he adds…
Chicago1988
- 261
- 1
- 8