Transferring log records from a source database system to one or more destination systems.
Questions tagged [log-shipping]
331 questions
26
votes
2 answers
Best way to migrate a huge SQL Server database with low downtime over network
Problem definition
Our database server needs to be transferred to an other datacenter. It runs on Microsoft SQL Server 2012 Enterprise (64-bit) and contains two databases of about 2TB and 1TB.
Having little to no downtime for this would be…
Val F.
- 363
- 1
- 3
- 6
15
votes
2 answers
How to Delete Restoring Database
I am running log shipping with SQL server 2008 R2.
I have a situation where the secondary database drive ran out of space and was not applying log shipping transaction logs.
The way I want to fix this is delete the databases at the secondary and…
peter
- 2,187
- 5
- 19
- 39
11
votes
1 answer
This backup cannot be restored using WITH STANDBY because a database upgrade is needed. Reissue the RESTORE without WITH STANDBY
I am creating log shipping for two databases, db1 and db2.
It will be from SQL Server 2008 R2 to a newer version, SQL Server 2012.
On SQL Server 2008R2, they are both dbi_version = 661:
DBCC TRACEON (3604);
GO
DBCC PAGE (db1, 1, 9, 3);
GO
DBCC…
ob213
- 654
- 1
- 9
- 19
11
votes
2 answers
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 completing a restore of one or two log backups. …
Mendel
- 111
- 1
- 1
- 5
9
votes
1 answer
Log Shipping SQL Server 2012
I'm a developer at a small shop that doesn't have a DBA and i'm trying to get log shipping with sql server 2012 working. I'm trying to off load reporting from the transaction system to a new data warehouse and will use this db as a staging area.
I …
William
- 205
- 1
- 5
8
votes
3 answers
Why is Full Recovery model a requirement for an Availability Group?
We have all our production databases in simple recovery model, and are very happy about it because it fully satisfies our RPOs and RTOs.
Now we want to implement AG DR solution for our databases and we found out that full recovery model is a…
Bit Cat
- 97
- 1
- 1
- 3
8
votes
1 answer
On Prem SQL Server: Log shipping via Azure Blob Storage: Possible?
This is about on premise, regular SQL Server 2014, Standard edition.
This is NOT about SQL Azure. The only part of Azure in this conversation is Azure Blog Storage, as a transport for some bits (SQL backups and logs)
Scenario:
Primary SQL Server is…
Jonesome Reinstate Monica
- 3,489
- 10
- 40
- 57
8
votes
1 answer
Remove the log shipping configuration on the secondary server, when the primary is no longer available
My primary server with SQL Server 2005 broke down, so I've started up the log-shipped database on the secondary server. The database is live on the secondary server, and I just need to remove the log shipping settings for it, while the primary…
treaschf
- 183
- 1
- 1
- 4
8
votes
1 answer
Log shipping large DBs - what about the log?
I'm currently setting up log shipping of a large DB (Approx 1.5TB) and am wondering what I can do about the log file.
As it stands, I want to do the following steps:
Change DB to FULL recovery
Take FULL backup (5-6 hours) on primary
Restore FULL…
Kris Gruttemeyer
- 3,879
- 2
- 23
- 43
7
votes
2 answers
Creating Users on secondary server in log shipping
I have a production Server say ServerA I have setup log shipping to ServerB which is left in read-only mode. The purpose of this log shipping is to lower the load on production server for some expensive queries (painful reports).
Now if I have to…
M.Ali
- 1,970
- 10
- 27
- 38
7
votes
1 answer
How do I monitor PostgreSQL WAL shipping if I'm not using streaming replication?
We have a fairly simple setup to replicate from our on-premise master PostgreSQL database to our presentation tier in AWS. We're using WAL shipping using the archive_command setting. Basically the setup looks like this:
+-------------+
| …
gregsymons
- 171
- 3
7
votes
1 answer
After Restoring Log Shipping to Secondary Server, First Stored Procedure Execution is Slow
We've set up log shipping to a secondary SQL server on Standby/ Read-Only to offload all SSRS report generation.
This works fine within the restrictions imposed by:
Kicking out the user during the transaction log restore (we got around this by…
RIanGillis
- 105
- 6
7
votes
1 answer
Snapshot_isolation_state_desc on a Read only/Stand by Database
I have configured Log Shipping where the primary server database has snapshot_isolation_state_desc reported as off. I tried to turn it off on the secondary which is a standby read only by using the GUI and by using the T-SQL statement to…
SQL_NoExpert
- 1,107
- 1
- 21
- 37
7
votes
1 answer
Set "Encryption Enabled" to FALSE...what can go wrong?
I'm migrating a database from SQL Server 2012 to SQL Server 2014 on the same server.
I'm configuring LOG SHIPPING on a database that is apparently encrypted:
When setting the log shipping I got this message (when it started to restore the database…
Racer SQL
- 7,546
- 16
- 77
- 140
6
votes
1 answer
Log shipping with a monthly archival process
We will be implementing log shipping in our production environment in the next weeks.
We perform a monthly "cleanup" of the database, whereby we set the database to the SIMPLE recovery model, copy records to an historic database, then delete from…
Luis de Haro
- 287
- 1
- 3
- 9