Questions tagged [log-shipping]
Transferring log records from a source database system to one or more destination systems.
319
questions
2
votes
1
answer
3k
views
Logshipping alert emails are being sent out while there is no error
I have logshipping setup with a Primary and a Secondary, and this has been working fine for a long time. Yesterday I started reveiving these emails:
The log shipping primary database SERVER....
- 143
2
votes
2
answers
2k
views
SQL Log Shipping Firewall settings [closed]
I'm attempting to setup log shipping between two differnet domains. When I attempt to connect to the secondary server instance the primary server fails to connect. If I turn off the windows firewall ...
- 2,099
3
votes
1
answer
3k
views
Log shipping setup across domains
I'm running SQL Server 2008 R2 on a Windows machine.
I've been tasked with setting up log shipping between our production site (managed by a service provider) and our QA environment which is hosted ...
- 2,099
1
vote
3
answers
2k
views
Does Log-Shipping need Transaction Log Backup from Primary Server?
In this video tutorial it is explained that we should use the transaction log backup of the primary server database and restore it into the secondary server database for log shipping.
I was doing a ...
- 271
3
votes
1
answer
364
views
SQL Server 2008 log shipping via JungleDisk
Has anyone used Jungle Disk as a common location for SQL Server 2008 log shipping? We use it for backup already and I think it can be used for taking log backup to our off-site location.
It seems ...
- 401
1
vote
2
answers
709
views
Is Log Shipping or Mirroring a better solution for Disaster Recovery?
I am planning an index rebuild, however my logs are prone to huge overblown sizes.
In fact I was leaning towards doing an intelligent re-indexing, but since the fragmentation levels are greater than ...
- 13
2
votes
3
answers
1k
views
rebuilding indexes and logshipping?
We all know that index rebuilding creates lot of log growth..so what changes would you consider to your logshipping side to accomodate this log growth?
Do we increase the frequency of the logbackups? ...
- 21
6
votes
1
answer
1k
views
Can SQL Express be used as a Log Shipping monitor server?
I'm keen to setup a "Monitor Server".
We have SQL 2008 R2 Enterprise edition on both primary and secondary servers.
Can we use SQL Express in monitoring server setup for licencing purposes?
- 61
1
vote
0
answers
166
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
- 66
3
votes
1
answer
4k
views
Why is my postmaster process (sometimes) becoming unmanageable after a WAL base restore?
TL;DR: Un-stoppable, unusable postmaster is being spawned when Postgres is started right after restoring its data directory from a WAL base backup. Why?
Context:
We run postgresql 8.4, on CentOS 6, ...
- 526
2
votes
2
answers
2k
views
Log-shipping : Broken Chain
If a write on log shipping transaction backup gets corrupted on one of the transaction file due to network or media issue, and hence the log shipping chain gets broken, is there any other way to ...
- 447
3
votes
1
answer
1k
views
log shipping backup fails every so often on only one server
I was asked to change the DFS share for our log shipping on all our SQL servers (SQL 2008 on windows 2008) to point to the new share due to some IO issues on the previous one. But now, ocassionally, ...
- 447
2
votes
1
answer
4k
views
SQL Server Log shipping standby db stuck restoring
I have 2 servers on SQL Server 2005 SP4. When the secondary server catches up with the log files it is switches into standby mode, but after a while it seems to be 'stuck' in restoring.
There were ...
- 2,581
15
votes
2
answers
76k
views
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 ...
- 2,187
5
votes
2
answers
771
views
Reduce load off primary server by using log shipping, or mirroring, or something else?
I have previously asked the below question about LogShipping frequencies, but I think I might be approaching this problem incorrectly (LogShipping frequency)
Problem
I have a high volume site that I ...
- 197
2
votes
2
answers
2k
views
LogShipping frequency for backup/copy/restore
I wish to create a LogShipping job that runs every 5 minutes. What is the best way to do this so that the backup/copy/restore does not collide?
Maybe Sql server knows how to handle this, but I was ...
- 197
3
votes
1
answer
4k
views
SQL Backups - Full vs Differential vs Log Shipping
I'm looking to refine our SQL backups utilizing Full, Differential, and Log Shipping. Currently, I am only performing full backups once at night. This process is taking so long that it is running ...
- 163
3
votes
2
answers
289
views
Will removing a 2nd log file break log shipping?
We have a large database 200GB+ to which we added a second log file to cater for growth during an upgrade. This is now no longer needed so we want to remove it. Normally this would be a simple ALTER ...
- 56
4
votes
1
answer
5k
views
Disable SQL Server Log Shipping to nonexistent destination
I am administering a SQL Server 2008 instance in a dev environment. At some point before I became an administrator, someone enabled log shipping from one of the databases on this dev instance to ...
- 143