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

Why is log shipped database invisible over linked server?

We have a lot of linked servers in our SQL Server 2012 instances. While browsing one of those linked servers, I noticed that a log-shipped database is unavailable there. The database itself is "Standby / Read-Only." Is it normal for log-shipped…
Eric B
  • 75
  • 6
0
votes
1 answer

SQLServer log shipping file size limit

I'm trying to limit the size of individual files that are transferred as part of log shipping (as I am using WebDAV for transport). I want to ensure that no trn files are created that are more than a certain size (e.g. 16MB) as it seems to choke…
Andy Joiner
  • 5,932
  • 3
  • 45
  • 72
0
votes
0 answers

Apache Derby Database Log Permissions

Log shipping transferring the log files under /database/log from the primary server to the secondary server was working fine. Someday the log files permission was changed and only Administrator had the rights now, causing the process to fail to copy…
J.Doe
  • 1
  • 2
0
votes
1 answer

Simple SQL Failover Plan? Log shipping? Mirroring?

I have a physical Prod DB Server (SQL05) and now a VM DB Server. The idea is if the physical machine goes down, we repoint our router (via NAT) to the VM machine. I am thinking of using Log Shipping to keep the VM DB basically current. Is this…
Keith Barrows
  • 24,802
  • 26
  • 88
  • 134
0
votes
1 answer

Log Shipping LSN in backup too recent to apply

Log shipped has been working. I get the message: Error: The log in this backup set begins at LSN 193489000090302900001, which is too recent to apply to the database. An earlier log backup that includes LSN 192973000046320700001 can be restored. …
Kevin T
  • 45
  • 1
  • 7
0
votes
2 answers

SQL Server 2008 R2 database stuck in Restore

I have two SQL Server 2008 R2 servers one for PROD and the other for DR. I am trying to add log shipping for a database called School. Steps so far Back up School database Restore with database using the UI or using the following SQL statement…
user1339913
  • 1,017
  • 3
  • 15
  • 36
0
votes
1 answer

SQL transaction log shipping after differential backup

I'm facing a scenario: Full backup of production database is created Full backup is restored to DR database A differential backup of production database is created, BUT accidentally deleted Start transaction log backup on production database The…
Brian Pham
  • 551
  • 9
  • 23
0
votes
0 answers

Implement TDE and log shipping on different domains

I have two instances of SQL Server 2016 Enterprise, each running on a different server. They are standalone servers. There is a shared drive on ServerA which can be accessed from ServerB. I have set up log shipping from a database (TESTDB) on…
alan murphy
  • 11
  • 2
0
votes
1 answer

Replicating a SQL Server database for reporting purposes

I am trying to determine the best way to replicate a SQL Server database from its production environment to another server for reporting purposes. A cloud-based software application we use is based upon a SQL Server database. The vendor has given…
wildermind
  • 13
  • 1
  • 4
0
votes
1 answer

SQL to SQL data replication

I have a 300 GB MSSQL 2016 production database on a server and i will need to make a copy of this database on another server for reporting purposes. On the production database, there are normal clustered/non-clustered indexes and daily read-write…
Yasin Bilir
  • 194
  • 3
  • 17
0
votes
1 answer

Configuring log shipping from on premises to Azure IaaS SQL

I am trying to configure log shipping from on premises server to azure Iaas SQL VM. Please let me know the method and limitations. Mainly i wanted to know how we will configure network shared path between on prem , azure and how backup and restore…
v.p.naveenkumar
  • 1
  • 2
0
votes
1 answer

Log Shipping from Synchronous Automatic Failover AlwaysOn Availability Group AAG

I have an AlwaysOn Availability Group which is running with Synchronous Commit & Automatic Failover. For example, connected to as SQL01 with nodes SQL01A or SQL01B. I want to make this data available for Warehousing on another server SQL02, due to…
Ryan
  • 43
  • 1
  • 7
0
votes
1 answer

How to log ship from SQL Server 2008 to SQL Server 2014

I need to log ship from SQL Server 2008 to SQL Server 2014 but server is not allowing me do it in stand by mode. I have done googling also but still did not get correct answer please explain if this is possible and how or not ?
sachin kalra
  • 43
  • 4
0
votes
0 answers

TRN file is very big

We had a maintenance plan on our SQL server 2000 database with log shipping from main server to standby server. We had to disable the plan due to disk space issues. After resolving that we did a log backup and enabled the plan, but now the initial…
Codesmith
  • 85
  • 1
  • 11
0
votes
0 answers

log shipping issue copy and restore jobs failed error access to the path is denied (mscorlib)

I have given access permission(sqlserveragent and mine) to the secondary folder but still I am getting this error. sql server : Ntservice\msssqlserver sql agent: domain\test Message 2016-04-21 12:00:31.48 Starting transaction log copy. …
surya teja
  • 143
  • 1
  • 2
  • 9
1 2 3 4 5
6
7 8