Stack Overflow
Stack Overflow

Questions tagged [log-shipping]

Log shipping is a process in various SQL server implementations that creates periodic log files of your primary database that can be applied to other (secondary) copies of the database. This secondary database can then be used for failover or reporting.

Log shipping is a process in various SQL server implementations that creates periodic log files of your primary database that can be applied to other (secondary) copies of the database. This secondary database can then be used for failover or reporting.

114 questions
0
votes
1 answer

Log shipping setup

Log shipping fails with the below error. Sql agent on secondary server has access to the folder and files in security. It is not a firewall issue. I created the jobs using the LS scripts as it fails through GUI. I have done it before on a different…
knahs
  • 65
  • 6
  • 12
0
votes
1 answer

SP 2010 Log Shipping Configuration

I have searched the web and found little to no answers for this kind of question... I am setting up our new Disaster Recovery server and have the server all ready to go. I discovered that our temporary DBA had set up log shipping to the SQL DR…
Matt.Engel_TMTI
  • 73
  • 1
  • 7
0
votes
1 answer

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 fine and working, the WAL files are shipping and…
markz
  • 1,766
  • 2
  • 14
  • 15
0
votes
1 answer

Log shipping - high IO and 30GB MSDB

We've been log shipping a handful of databases for around 6 months now, currently between 20-60GB in size. We are log shipping every 5 minutes, with a 3 day retention. These logs vary from around 18KB to 5MB every 5 minutes (more at the smaller…
James Crowley
  • 3,911
  • 5
  • 36
  • 65
0
votes
1 answer

How mirror two SQL Servers Express with different versions using the Log Shipping method?

I have a desktop application accessing a SQL Server database. I have a web application, running on a remote computer (Amazon EC2). I tried mirroring between two SQL Servers using Log Shipping method, but due the different SQL Server versions, the…
user2616409
  • 1
  • 1
0
votes
3 answers

How can I put a trigger on a system table to gather historical data?

I'm able to implement trigger on user define table but not on system table (log_shipping_primaries and log_shipping_secondaries), it store info about when the backup .bak file was generated and when the transaction log ship file .trn file was copied…
saurabh sharma
  • 23
  • 6
0
votes
2 answers

Log shipping for few tables in SQL Server 2012

Is it possible to log shipping for few tables only in SQL Server 2012? Thanks
Rajan
  • 198
  • 1
  • 2
  • 10
-1
votes
1 answer

Log shipping plan creating readonly standby

I created a maintenance plan for log shipping from main server to secondary server in standby mode. It is creating the standby database in read-only mode. When I change the database to read-write by running restore with recovery, the log shipping…
Codesmith
  • 85
  • 1
  • 11
-2
votes
1 answer

Move azure VPN Gateway between two azure subscriptions

I want to move my two SQL VM which is under Log Shipping. How can i move these VM to another azure subscription? What things to be considered before moving it.
Sarvesh Pandey
  • 31
  • 4
1 2 3 4 5 6 7
8