Skip to main content

All Questions

Tagged with
Filter by
Sorted by
Tagged with
1 vote
1 answer
972 views

Transaction Log Backup fails with "Exclusive access could not be obtained because the database is in use"

I am attempting a Log Shipping failover test and the step which is intended to put the database into restoring mode is failing with the error "Exclusive access could not be obtained because the ...
Marathon_Nick's user avatar
0 votes
1 answer
895 views

Postgres HA - Warm standby server lagging

We have recently implemented high availability for our postgres (9.0.4) DB server, through the methods described as Log-Shipping Standby Servers in the Postgres documentation. Everything seems to be ...
markz's user avatar
  • 1,766
1 vote
1 answer
1k views

sql server log shipping to remote server in different network

I need to setup a Disaster Recovery. I need to setup Log shipping to remote server not in same network. I can transfer log shipping trc files to remote machine through internet. But how to import trc ...
Himanshu's user avatar
  • 909
5 votes
2 answers
11k views

Transaction log shipping together with backup job = conflict?

There is already a backup job plan that runs every 15 minutes. I created transaction log shipping process but after 1 or two restored logs this job stops working (error: it can't find matching log). ...
ilija veselica's user avatar
1 vote
1 answer
1k views

Initial configuration for log shipping of a large database in SQL Server 2008

We have a new filestream database that will be initially loaded with 65GB data, for which we'd like to configure log shipping to a remote (different continent) location. For the initial setup of log ...
Pero P.'s user avatar
  • 26.9k
4 votes
4 answers
575 views

Backing up SQL Database for Reports

I'm looking for some help/suggestions for backing up two large databases to one server dedicated to reports. The situation is; My company has two databases for its internal website. One for the UK ...
Phil's user avatar
  • 107