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
1
vote
2 answers

Shell Script to extract logs for last 24 hrs

We are trying to extract logs from a file, we need all entries which meets a pattern and the time stamp is within last 24 hrs. my log looks like this: 2014-07-01 01:15:59,486 WARN 86c9c59c-c362-48d5-bd8c-fb4c8b616f5a 169.179.101.7 CITIKYC_164283…
HackSparrow
  • 27
  • 2
  • 6
1
vote
1 answer

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 shipping, is there any threshold for the time…
Pero P.
  • 25,813
  • 9
  • 61
  • 85
1
vote
0 answers

How to keep log-shipping up after failover (mirroring) in sql server

In SQL Server 2008,I have three instances which are LOG-SHIP, PROD, and MIRROR and I keep my transaction logs on different disks. For instance my PROD transaction file is located under C:\MSSQL10.PROD\MSSQL\TRAN_PROD. , MIRROR transaction file is…
user3149645
  • 11
  • 1
1
vote
1 answer

Best Solution to have a Live copy of a Database when replication is not an Option

Recently I had to implement transactional replication to have a live copy of that database on another server for reporting purposes. While configuring replication I realized that a lot of tables didn't have a primary key, so I could not publish all…
M.Ali
  • 67,945
  • 13
  • 101
  • 127
1
vote
1 answer

SQL Server full copy of database for read operations

Please advise what suits my problem better. I have a highload web app hosted on the same server where SQL server is hosted. I also have SQL Service reporting running on the same server, generating user reports. So my server basically works on top of…
Johnny_D
  • 4,592
  • 3
  • 33
  • 63
1
vote
1 answer

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 files to secondary server. Actually i am trying…
Himanshu
  • 909
  • 3
  • 9
  • 13
1
vote
1 answer

Copy data from local production SQL Server database to remote read only SQL Server database

I'll start by explaining what the current set up is and then go onto where it needs to be. Currently we have a local SQL Server database for a CMS. The database is updated from other servers on site to update product information to display on the…
Andrew
  • 13
  • 3
1
vote
2 answers

Could not retrieve backup settings for primary ID in Log shipping

I am doing log shipping between two amazon ec2 instances running windows server 2008 R2. The sql server version is Sql server 2008 R2 standard edition Both the instances are in the same domain and i can access the shared folders between the…
Vijayasarathy
  • 43
  • 1
  • 7
0
votes
0 answers

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.log_shipping_monitor_history_detail where agent_id…
raja mangubat
  • 1
0
votes
2 answers

Mix transactional replication and log shipping?

I've replicated a large database (close to 1TB) to three remote servers using pushing transactional replication. The subscribers are read-only. A lot of data is inserted and updated (from other sources) in one day every month. It always fail the…
ca9163d9
  • 27,283
  • 64
  • 210
  • 413
0
votes
0 answers

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 Server Instance
Terrence McGinnis
  • 136
  • 4
  • 15
0
votes
1 answer

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 a day or so and then just gets stuck in a…
user197505
  • 163
  • 3
  • 13
0
votes
1 answer

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 using Get-SPLogEvent, until i noticed that using the cmdlet in…
Dennis
  • 871
  • 9
  • 29
0
votes
1 answer

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" state. I want to change it to have a read access to the target db…
ZedZip
  • 5,794
  • 15
  • 66
  • 119
0
votes
0 answers

sql server pretends to do a log shipping to himself

I have a sql server 2017 config: 2 nodes on a lan synced in an AG: zsbe-eve-db-01/02, 1 node in a remote site: zsbe-rui-db-01 (standby/readonly), one database named "Primary" (it is stupid, I know, I didn't create it). Master node zsbe-eve-db-02…
Alain Bourgeois
  • 59
  • 4
1 2 3
4
5 6 7 8