The tag has no wiki summary.

learn more… | top users | synonyms

6
votes
1answer
480 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?
1
vote
0answers
76 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
3
votes
1answer
2k 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, ...
2
votes
2answers
461 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 ...
2
votes
1answer
442 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, ...
1
vote
1answer
1k 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 ...
0
votes
1answer
7k 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 ...
3
votes
2answers
237 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 ...
2
votes
2answers
399 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 ...
3
votes
1answer
1k 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 ...
2
votes
2answers
200 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 ...