The log-shipping tag has no wiki summary.
0
votes
1answer
42 views
Copy tables from a stand-by database
I want to explain the following. I have a database that is a recovery db from our main environment. This database is kept up-to-date through log shipping. However, I want to copy all tables from this ...
2
votes
0answers
57 views
Can the same database be log-shipping secondary and primary at the same time?
Here is my scenario:
Database DB1 on Server1 is log shipping primary in data center.
Database DB1 on Server2 is log shipping secondary; Server2 is in remote location. Logs are shipped from data ...
2
votes
0answers
351 views
Log Shipping - RESTORE WITH STANDBY - on SQL Server 2012 keeps breaking
We are using log shipping and RESTORE WITH STANDBY on SQL Server 2012 in order to restore the database in read-only mode for reporting purposes. However, the log shipping setup keeps breaking after ...
2
votes
0answers
119 views
SQL Server Database Hot Backups: Which Technique(s) to Use for Multi-Level Replication?
I'm reading the many other posts here about mirroring vs. replication, but I'd still appreciate it if someone with some experience would weigh in.
My small development team needs to have local ...
1
vote
0answers
42 views
Log Shipping Monitor Stored Procedure returning Null
I have log shipping setup. When I EXEC sp_log_shipping _monitor it returns all null values
even though log shipping appears to be working fine.
last_restored_file
NULL
last_copied_file
NULL
