116 questions
0
votes
0
answers
17
views
Log shipping via Transact-SQL failed
I wanted to set SQL Server Log shipping via T-SQL. So I set it up in GUI firstly and it was succesfull, replicated database on slave server occurred.
I did this step again for another database and ...
- 49
0
votes
0
answers
38
views
SQL Server Log shipping do not work for multiple databases inside T-SQL loop
I want to set SQL Server log shipping for all databases on a server. When I configure database (on master side) one by one, there is no problem.
Problem occurs when put configuration ( for master side ...
- 49
0
votes
2
answers
345
views
Filebeat | how to define a unique index for different log paths?
I am collecting logs from two different paths:
/var/log/containers/*.log
/var/log/agents/*.log
I wanted a that files from each of the paths will be sent to different indexes in elasticsearch.
I ...
- 309
0
votes
0
answers
91
views
Having blocking on logshipping msdb.dbo.log_shipping_monitor_history_detail, when I am looking where it is initiated I only see SQL Server log shippin
I having blocking on logshipping msdb.dbo.log_shipping_monitor_history_detail, when I am looking where it is initiated I only see SQL Server log shipping.
The complete query is
delete from msdb.dbo....
0
votes
0
answers
62
views
Is it possible to sync real-time 2 Database on 1 SQL Server?
I want to clone my Database1 to Database2 and sync it in real-time, just like mirroring but only using 1 SQL Server Instance
I tried Log Shipping and Mirroring but it's not possible to use only 1 SQL ...
0
votes
1
answer
777
views
Transaction log shipping - Standby/Readonly database keeps getting stuck 'Restoring'
I am shipping transaction logs to another database that we will be using for certain reports that don't need real-time data. This works fine until we start directing traffic to it, then it lasts for ...
- 173
0
votes
1
answer
58
views
How do I ship logs from SharePoint in almost real time to a fileshare using PowerShell?
I've got a SharePoint farm where I'm trying to ship the log files in "real time" to a server that is available for the monitoring team using PowerShell.
I first had it going pretty well ...
- 1,684
0
votes
1
answer
2k
views
SQL Server Log Shipping: how to change a target database to stand by?
I have added Log Shippig to SQL Server:
SQL server1\source_database->SQL server2\target_database
As I see from SSMs Report it works ok. But the target database always in "Restoring" ...
- 6,422
0
votes
0
answers
124
views
Log shipping, logs are copied to the second server folder but not uploaded to the database
I am doing log shipping, but the second server is not uploading the logs to the secondary database.
I try to get the error but it doesn't reflect any. The jobs run without problems.
Any possible ...
0
votes
1
answer
1k
views
The database is already fully recovered. RESTORE DATABASE is terminating abnormally
I've recently inherited the responsibilities of a DBA without the benefit of having any DBA training. We have a database (omitted name for security reasons) that is essentially setup to run in ...
0
votes
0
answers
260
views
Log Shipping, secondary server error. Error 5 - Error 3201
I am making the configuration to make a Log Shipping, but when I click ok after filling in all the fields of the necessary configuration, the following error appears:
Restoring backup to secondary ...
1
vote
2
answers
2k
views
Azure AKS in-container logs to Azure Logs/Azure Sentinel
Is there an dynamic way to pull log data from inside my containers?
All of my searches are returning that Azure Logs/Azure Sentinel can read data about AKS relative to the containers as they exist in ...
- 2,935
0
votes
0
answers
36
views
Is uncompressed transaction log file restore process faster then compressed in SQL SERVER
I am writing process to ship transaction log files from production SQL server to Read Only SQL Server. I am compressing transaction log in source DB, coping file to destination and restoring into Read ...
0
votes
0
answers
19
views
Can you SQL replicate tables from a logged-shipped secondary DB to a separate third DB?
Can you SQL replicate tables from a logged-shipped secondary DB to a separate third DB?
The idea is to offload some long running scripts from those tables, and if possible avoiding touching the ...
- 1
0
votes
0
answers
967
views
Log shipping restore job failing after a couple successful runs
I have log shipping on several databases that are working good and I have three that fail. They are all going from the same primary to the same secondary. I have mimicked the settings of the working ...
- 1
1
vote
0
answers
493
views
Setting up PostgreSQL 13 log-shipping replication between 2 CentOS 8 vagrant boxes,
I've been trying to set up log-shipping replication between 2 CentOS 8 vagrant boxes, but I have two problems I just can't seem to find the answer for:
1.,I've followed the official pgsql ...
- 11
6
votes
1
answer
3k
views
How to get Serilog json-formatted logs to appear correctly in Datadog
I have been asked to implement a centralized monitoring and logging system using DataDog that will receive information from various services and applications, some running as Windows Services on ...
- 50.8k
0
votes
0
answers
657
views
Error in Restoring backup to secondary database using log shipping
I'm trying log shipping between two SQL VMs. The backup is getting generated properly but its not getting restore on secondary database. The error says that the restore job is not able to open the ....
-2
votes
1
answer
940
views
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.
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 ...
1
vote
2
answers
2k
views
How to ship Airflow logs to Azure Blob Store
I'm having trouble following this guide section 3.6.5.3 "Writing Logs to Azure Blob Storage"
The documentation states you need an active hook to Azure Blob storage. I'm not sure how to create this. ...
- 199
0
votes
1
answer
620
views
Restoring the secondary server in log shipping
I am currently setting up log shipping for a client and have a question.
The process of setting up the log shipping is pretty straight forward but I do not see much information about failing over to ...
0
votes
1
answer
152
views
Logstash XML file parsing - awkward event Splitting Problem on Conf Reload
I'm working with ELK 6.7.0 on docker with official images. This is my conf file:
input {
file {
path => "/usr/share/logstash/logs/*.xml"
type => "xml"
sincedb_path => "/dev/...
- 583
0
votes
1
answer
364
views
Log shipping a large database
I have Question on log shipping:
I am migrating a VLDB (12TB) SQL database from a physical environment (server A) to virtual environment (server B), and from version SQL 2008 R2 to SQL 2014. The high-...
0
votes
1
answer
314
views
SQL Server 2016 reset recovery mode from 'Full' to 'Simple'
Can anyone help me diagnose why this may have happened? We've got log shipping configured and so the database is in 'Full' recovery mode. This has been working fine for ages, and then randomly it ...
- 3,114
0
votes
2
answers
172
views
Temporal Tables and Log shipping
We are building a system in our company which will need temporal tables in sql server and might need log shipping as well. I wanted to know if there are any unexpected impacts of log shipping on a ...
0
votes
1
answer
369
views
Any impact of changing SQL Server log shipping restore job schedule
On the SQL Server log shipping secondary database server, I have 2 jobs LS_Copy and LS_Restore.
Current schedule: both jobs run every 30 minutes (all day)
New schedule: I want to change the restore ...
- 137
0
votes
2
answers
156
views
Does my master server crash using Log-Shipping Synchronous Replication in Postgresql when the replica is down?
I'm searching for HA solutions without load balancing in the master-slave model, using postgresql. My favorite solution so far is log shipping synchronous replication. But I have one main concern, and ...
1
vote
0
answers
56
views
Issues with LogShipping in SQL Server 2008 R2 SP3
I've got two SQL instances in two separate servers,
The first one has two databases, A and B for that purpose, that I'm logshipping to the secondary server; in database A it works like a charm, ...
- 31
0
votes
1
answer
107
views
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 "...
- 75
0
votes
0
answers
131
views
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 ...
- 1
1
vote
0
answers
47
views
How to removed crashed node in SQL Server 2012 Log Shipping?
My DR site server crashed and they built a new one with a new IP. I added the new node but I am unable to remove the old one (since it is no longer there). The log shipping to my new node is working ...
- 45
0
votes
1
answer
4k
views
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 ...
- 45
0
votes
2
answers
2k
views
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 ...
- 1,027
0
votes
1
answer
931
views
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 ...
- 561
0
votes
0
answers
543
views
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 ...
- 11
0
votes
1
answer
3k
views
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 ...
- 13
0
votes
1
answer
412
views
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 ...
- 304
1
vote
1
answer
80
views
log ship wizard in SQL 2012 Std not showing compression option
I cannot find the compression option in the log shipping setting page. the version of the SQL is Microsoft SQL 2012 Std.
- 575
0
votes
1
answer
2k
views
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 ...
0
votes
1
answer
390
views
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 ...
- 43
-1
votes
1
answer
346
views
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 ...
- 101
0
votes
1
answer
78
views
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 ...
- 43
0
votes
0
answers
720
views
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 ...
- 101
5
votes
2
answers
3k
views
SQL Transaction Log Shipping fails to restore database to standby
I have set up transaction log shipping between 2 SQL 2014 Servers, everything seems to setup correctly but when the restore happens it seems to fail if the .trn is really small eg 7k.
Not sure if ...
- 589
0
votes
1
answer
4k
views
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:...
- 173
0
votes
1
answer
269
views
sql log shipping
Our log shipping routine failed and was 3 days out of date, so I manually restored the transaction log from the primary database into the secondary database.
The database seemed to restore all ok but ...
- 1,423
0
votes
0
answers
451
views
Why my Log Shipping not break due to LSN mismatch?
I configured log shipping from SQL Server 2008R2 to 2012 Server, secondary Server database recovery state is restoring and log shipping works good.
One day I take log backup manually through query ‘...
- 1,415
1
vote
0
answers
492
views
how to rename a secondary database in log shipping?
I want to rename secondary log shipping database in SQL Server 2008. Can anyone help me how to do this?
Thanks in advance
- 45
0
votes
1
answer
600
views
SQL Server log shipping : any way to skip some transactions without breaking LSN?
I was able to set up log shipping from Primary to Secondary database. I need then to cleanup some old data from Primary database but I need that data in Secondary for reporting.
So my idea was to ...
- 21