Questions tagged [log-shipping]
Transferring log records from a source database system to one or more destination systems.
319
questions
1
vote
1
answer
43
views
Is log shipping good for periodic synchronization?
I have Postgresql 9.3 server on both my laptop and my desktop at home. I keep identical data on both system. Sometimes I work on the database on my laptop while other times I work on the database on ...
- 181
9
votes
1
answer
1k
views
Log Shipping SQL Server 2012
I'm a developer at a small shop that doesn't have a DBA and i'm trying to get log shipping with sql server 2012 working. I'm trying to off load reporting from the transaction system to a new data ...
- 205
5
votes
4
answers
20k
views
Log Shipping "out of sync" but none of the jobs are failing
I've configured a log shipping from a server, to the same server, only with a different instance.
Primary server is configured this way:
LSBACKUP_MyDatabase - every 25min
Secondary server:
...
- 7,246
7
votes
1
answer
8k
views
Set "Encryption Enabled" to FALSE...what can go wrong?
I'm migrating a database from SQL Server 2012 to SQL Server 2014 on the same server.
I'm configuring LOG SHIPPING on a database that is apparently encrypted:
When setting the log shipping I got this ...
- 7,246
2
votes
0
answers
1k
views
What does 'Could not find a log backup file that could be applied' means on log shipping?
Skipped Log Backup File ..... Could not find a log backup file that
could be applied to secondary Database
What does this mean?
I've configured a log shipping. To test, I created 2 tables, put ...
- 7,246
1
vote
0
answers
2k
views
What Open Ports are Necessary for SQL Server Log Shipping to Secondary on the Internet
Our secondary server will be on the other end of an always on IPSEC tunnel. We need to instruct our customer's firewall/VPN/Server team (they are responsible for the primary).
What I've gathered so ...
- 159
4
votes
4
answers
2k
views
How do I fix an Orphaned User in Log Shipped version of a SQL Server 2008 database
Forgive my greenness.. but would appreciate some help on this...
We are doing development work on an instance of SQL Server 2008 and have multiple databases on that server that are core to our ...
- 159
3
votes
0
answers
343
views
VSS Writer : RESTORE VERIFYONLY FROM VIRTUAL_DEVICE breaks log shipping
Log shipping has been working for a very long time, but now and then it breaks. I found it sometimes breaks (causes the transaction log to become corrupt and I get the message : "media family on ...
- 1,335
1
vote
1
answer
147
views
Log shipping 2008 r2 SP2 server to a 2008 r2 SP3 CLUSTER
We have recently configured one database to be replicated with log shipping in production, using SQL Server 2008 R2.
We have up and running more than 150 database replicas without any problems. But ...
1
vote
0
answers
32
views
Log Shipping causes high context switches
MSSQL - I have setup log shipping on many databases being sent to 2 different servers in NORECOVERY mode.
This is causing crazy context switches on the main server.
Is this normal?
16 Cores without ...
- 319
0
votes
2
answers
5k
views
Change archivelog location in Oracle
Oracle instance I set up is using USE_DB_RECOVERY_FILE_DEST for archivelog location.
log_archive_dest_1 string
LOCATION=use_db_recovery_file_
dest, valid_for=(ALL_ROLES,ALL
...
- 71
2
votes
0
answers
110
views
SQL Server 2014 Log shipping - column error
I'm trying to set up log shipping between two instances of SQL Server 2014 Dev edition. Backup and copy jobs work flawless, but the restore one keep failing with the following error:
An error ...
- 121
2
votes
2
answers
98
views
Secondary reporting SQL Server
I have a SQL Server 2012 Std cluster that has a lot of writes going on. We'd like to offload some of the reporting to a separate (2012 Std) VM. It can be around 24 hours out of date.
I think log ...
- 669
3
votes
2
answers
7k
views
Can SQL Server database be changed from NoRecovery to Standby?
I'm receiving a log shipped database (and daily transaction logs) from an outside vendor -- to our FTP. No internal access allowed. No connection between the two databases.
I've restored the ...
- 31
8
votes
1
answer
8k
views
Remove the log shipping configuration on the secondary server, when the primary is no longer available
My primary server with SQL Server 2005 broke down, so I've started up the log-shipped database on the secondary server. The database is live on the secondary server, and I just need to remove the log ...
- 183
3
votes
1
answer
1k
views
Grant access on Secondary but not on primary in SQL Server logshipping [duplicate]
I have a strange situation wherein users need permission on log shipped DB on secondary server but not on primary. The problem is, the login has access on many other DBs on primary server apart from ...
- 1,810
3
votes
1
answer
645
views
Log Shipping Fails with CONTINUE_AFTER_ERROR
DR plan for primary database in a private hosted cloud environment. The primary is a hosted physical server. The secondary is on another network, same domain. Version is SQL Server 2008R2 (10.50.2550....
- 135
1
vote
2
answers
4k
views
Log Shipping copy job doesn't delete old files on a secondary node that is part of AlwaysOn configuration
I have the following setup, all servers are SQL 2014 Enterprise:
2 node AlwaysOn availability group;
third server for off-site DR.
Log backups are being taken on the primary node, copied to the ...
- 67
2
votes
0
answers
481
views
Log shipping restore delay of a minute between iterations
On a test database running Log Shipping jobs the initial Restores to catch up performed the first time I run the Restore job seem to have a 1 minute or so Wait time built in. I would have expected ...
- 121
0
votes
1
answer
1k
views
Replication from log shipping database
I have a secondary database on a standby and read only mode.
The question is .. Can I replicate this database ?
- 621
4
votes
3
answers
604
views
MS-SQL 2014 Log Shipping: Access permission question
Wonder if someone could provide some advice or point me in the right direction towards achieving the below objective please. Unfortunately I have not been very successful in finding a solution online.
...
0
votes
0
answers
50
views
SQL Server DR scenario
I have a SQL server A and B which is production databases. The DR of production 'A' is production db 'B' and DR of production db 'B' is production db 'A'. DR feature that is used is log shipping. All ...
- 1,824
8
votes
1
answer
1k
views
Log shipping large DBs - what about the log?
I'm currently setting up log shipping of a large DB (Approx 1.5TB) and am wondering what I can do about the log file.
As it stands, I want to do the following steps:
Change DB to FULL recovery
Take ...
- 3,796
3
votes
0
answers
157
views
Need a way to prevent log shipping from kicking users out
We have SQL Server 2012. A service we use requires us to use log shipping, however we are tired of having users being kicked offline every 15 minutes.
Are there any creative ways to get around this (...
- 131
5
votes
3
answers
2k
views
Hyper V replication - vs - sql replication solutions
I need to establish an offsite copy of a number of production servers, including SQL server.
Hyper V replication has been chosen as a simple solution (all servers are virtual). This is to supplement ...
- 266
1
vote
0
answers
55
views
Log shipped database server user SID is created automatically
We have a production server "prod" which has a user say 'test' that lets the users connect to the application and a logon trigger which stops them from connecting to the server through SSMS.
I ...
- 11
2
votes
1
answer
114
views
DR option for SharePoint databases? ideas and experiences
First let me clarify that I am not looking for thoughts in terms what is the best or the bad options for a DR for SQL Server. I am just looking for for inputs from experienced people.
We are running ...
1
vote
3
answers
4k
views
Unable to delete Log Shipping configuration
I need some help with my SQL 2005 server.
I am trying to setup log shipping, I've successfully done so for all user-databases, except one.
From the looks of it, it once had log shipping configured ...
- 193
0
votes
0
answers
82
views
Best method to implement HA and DR, replication via 1 PUB and 2 SUB or replication and LS both
I need a advise on one of our projects where:
We have 3 SQL database servers A, B and C:
A is the live production server with around 200 users with a database of size 1.5 TB hosted.
B is going to ...
- 7,069
1
vote
1
answer
350
views
LSCopy job fails on SQL Server 2005 - Insufficient space
I'm having some trouble getting my LSCopy job of Log-Shipping on my SQL Server 2005 server, to work.
The LSBackup job is configured so the backup is made locally (D: drive)
The LSCopy job is ...
- 193
3
votes
1
answer
3k
views
Can I backup (Full) the Log-Shipping Secondary Database?
I have a Highly pressured Production Environment with Database name DB1. And I want to run a weekly DBCC CHECKDB process on one of the databases there.
(You can understand,I can't do it on my ...
- 621
8
votes
3
answers
14k
views
Why is Full Recovery model a requirement for an Availability Group?
We have all our production databases in simple recovery model, and are very happy about it because it fully satisfies our RPOs and RTOs.
Now we want to implement AG DR solution for our databases and ...
- 97
2
votes
1
answer
93
views
Advice on transaction log based reporting server
I am in need of advice on setting up a remote read-only MSSQL 2008 reporting server using transaction logs.
From what I gather, true TLS setup requires both database servers to be aware of each other ...
- 21
2
votes
1
answer
465
views
Grant Windows logins to read a secondary database of log shipping?
The following link, Creating Users on secondary server in log shipping, shows how to create a database login on the secondary server. How to grant Windows logins on the secondary server to access the ...
- 1,505
1
vote
1
answer
1k
views
Log Shipping - Monitor Server Down - Copying happening but not restoring on secondary
I have set up a few log shipping instances, but I am not a DBA.
This weekend something happened for the first time - the log shipping Monitor Server went down temporarily due to electrical issues ...
- 1,335
0
votes
1
answer
3k
views
Is it possible to estimate the restore progress in SQL Server 2014 from pages read/written?
For context - SQL 2014 EE, we're doing tran log backups from our main production box and restoring to a R/O instance. The log is usually around 50GB.
So I'm familiar with the structure of SQL Server ...
- 41
4
votes
1
answer
4k
views
Log shipping and new NDF file
I have a log shipped database, and I want to create a new NDF file in another disk for moving historic tables to that NDF file. My goal is to free some space in the MDF file because the disk that the ...
- 287
0
votes
0
answers
248
views
Log shipping Readonly/Standby executes Queries slow for some users
I have a SQL Server database that is doing log shipping to another SQL Server instance, both servers have identical hardware. We have a reporting service that then runs reports against the readonly ...
- 177
6
votes
1
answer
355
views
Log shipping with a monthly archival process
We will be implementing log shipping in our production environment in the next weeks.
We perform a monthly "cleanup" of the database, whereby we set the database to the SIMPLE recovery model, copy ...
- 287
0
votes
1
answer
92
views
Restore databases from prod to test server with data over X days
We've got a list from app owners to restore say 20 databases from a total of 100 available production server databases onto a test server on weekly basis.
Moreover, they require it in a way that ...
- 7,069
4
votes
0
answers
401
views
How to copy SQL Server log shipping files to AWS EC2 instance
I am using SQL Server 2008 R2 and would like to log ship from my local data center SQL Server instance to a log shipping target SQL Server running in AWS EC2.
What is the best way to copy the log ...
- 141
1
vote
2
answers
623
views
Is it possible to set stand-by database to active, do changes and then continue restore chain?
Basically, I'm using a custom log shipping method on a sql 2012, where the transaction files are manually copied to an offsite location. The files are then restored using something similar:
RESTORE ...
26
votes
2
answers
18k
views
Best way to migrate a huge SQL Server database with low downtime over network
Problem definition
Our database server needs to be transferred to an other datacenter. It runs on Microsoft SQL Server 2012 Enterprise (64-bit) and contains two databases of about 2TB and 1TB.
...
- 363
5
votes
2
answers
18k
views
Database cannot be opened. It is in the middle of a restore?
I've set up log shipping using standby mode （The "Disconnect users in the database when restoring backups" is unchecked).
I tested running the following code on secondary server/database.
declare @a ...
- 1,505
8
votes
1
answer
4k
views
On Prem SQL Server: Log shipping via Azure Blob Storage: Possible?
This is about on premise, regular SQL Server 2014, Standard edition.
This is NOT about SQL Azure. The only part of Azure in this conversation is Azure Blog Storage, as a transport for some bits (SQL ...
-1
votes
0
answers
324
views
Tran Log file growing even after log backups and Log shipping configured
I have log shipping configured for a database in SQL server 2005 with below details:
A) Database X hosted on primary: Log backup every 1 hour as scheduled in LS Backup job:
Data file: 40 GB and Log ...
- 7,069
0
votes
2
answers
3k
views
How can i automate the process of log shipping monitoring
I have log shipping configured between my Prod SQL server 2005 and QA SQL server 2005. Per the requirement from Business we need to provide them with a report at the end of the day for the LOG ...
- 7,069
1
vote
0
answers
128
views
Please explain log-shipping delta
I am trying to understand how Delta is monitored in log-shipping. We have log-shipping monitoring in place and I am seeing delta increases sometimes for random instances and it drops once database is ...
- 326
2
votes
1
answer
5k
views
Combining log shipping and regular log file backups
Following on from my earlier question, I'm trying to set up a combination of Log Shipping and database backup. What I have in place is:
Log Shipping set up between my two servers, to run every 5 ...
- 303
1
vote
2
answers
985
views
Deciding on a replication strategy
We have several dozen small-medium (<1Gb) databases on our SQL Server 2008R2 (Standard Edition) server, with one or two more being created every month. The server itself is a fairly well spec'd box ...
- 303