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
20
votes
1 answer

Log-Shipping: Why would you choose No Recovery mode?

When configuring LogShipping for SQL Server, you can choose for the secondary database to be in No Recovery mode or Standby mode. No Recovery means you have no access to the database while log shipping is going on. Standby gives you read-only…
LondonPhantom
  • 1,867
  • 3
  • 19
  • 26
10
votes
1 answer

T-SQL copy Logins, Users, roles, permissions etc

We have implemented log shipping as a database disaster recovery solution and want to know if there is a way I can use T-SQL to script all the logins, users, roles permissions etc to the master database on the secondary server so that the T-SQL can…
user394721
7
votes
3 answers

Fluentd to Logstash output plugin

I am trying to read from the scribe server using flunetd and output those logs to be stored in logstash for now. I know it's very stupid to log the scribe_central logs to another central logger, but we need this to be done in our current…
user3195649
  • 437
  • 1
  • 6
  • 11
5
votes
2 answers

Transaction log shipping together with backup job = conflict?

There is already a backup job plan that runs every 15 minutes. I created transaction log shipping process but after 1 or two restored logs this job stops working (error: it can't find matching log). Obviously, there are logs created by two…
ilija veselica
  • 9,414
  • 39
  • 93
  • 147
5
votes
1 answer

Scripting Log Shipping Automation

Is it possible to script All of the Log Shipping configuration? For example: I need to write a job that initiates Log Shipping from two databases from server A to server B. The job will run on Server A. By the way both are SQL 2008 R2…
Gabriel Guimarães
  • 2,724
  • 3
  • 27
  • 41
5
votes
2 answers

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 that has any bearing on it but it the only thing that…
Jason Wragg
  • 589
  • 2
  • 5
  • 19
5
votes
3 answers

Mirroring vs. Log Shipping in Sql Server 2005

I'm interested in hearing people's thoughts about the pros and cons of database mirroring vs. log shipping in this scenario: we need to setup a database backup situation wherein there is exactly one secondary server that need not automatically pick…
Karim
  • 18,347
  • 13
  • 61
  • 70
5
votes
1 answer

Help on choosing which SQL Server 2008 scale-out solution to pick (replication, ...)

I am currently crossing the jungle of SQL Server scale-out technologies like replication, log-shipping, mirroring... I have the following constraints on my choice: I want the read-only load to be spread accross the primary and the secondary…
usr
  • 168,620
  • 35
  • 240
  • 369
5
votes
6 answers

Is it possible to have secondary server available read-only in a log shipping scenario?

I am looking into using log shipping in a SQL Server 2005 environment. The idea was to set up frequent log shipping to a secondary server. The intent: Use the secondary server to serve report queries, thereby offloading the primary db server. I came…
codeape
  • 97,830
  • 24
  • 159
  • 188
4
votes
4 answers

Backing up SQL Database for Reports

I'm looking for some help/suggestions for backing up two large databases to one server dedicated to reports. The situation is; My company has two databases for its internal website. One for the UK and one for Europe. Both are mirrored for DR. I have…
Phil
  • 107
  • 1
  • 8
4
votes
2 answers

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 virtual machines and some running inside a Kubernetes…
Larry Lustig
  • 49,320
  • 14
  • 110
  • 160
4
votes
3 answers

hundreds of databases sql server log shipping

SQL Server 2005 Standard 64x, with 300+ tiny databases currently (5MB each), user base adds databases as needed. Want to implement log shipping for warm standby, but not via the wizard, since that looks like it adds 3 jobs (1 on primary, 2 on…
Oliver
  • 668
  • 2
  • 7
  • 19
3
votes
2 answers

When we configure log shipping do we have to open a firewall from the destination server to the source server too?

When we configure log shipping do we have to open a firewall from the destination server to the source server too?
user87810
  • 91
  • 1
  • 2
3
votes
2 answers

log shipping bandwith estimation

We have a lot of sql server databases in Simple Recovery Mode. We need to move these databases on a different datacenter. These databases can not be closed (they are serving 24x7 mission critical services). We are thinking to use log shipping to…
Giova
  • 1,137
  • 1
  • 9
  • 17
2
votes
1 answer

Log Shipping - Ignore deletions on a specific table

I've got a scenario where I have a database with one table that gets tons of inserts, and it's vital that the performance is excellent for those inserts. I also have a lot of reports, some of which hit that table. Thus, I want to create a reporting…
Jerod Venema
  • 44,124
  • 5
  • 66
  • 109
1
2 3 4 5 6 7 8