Tagged Questions

Transferring log records from a source database system to one or more destination systems.

learn more… | top users | synonyms

1
vote
1answer
41 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 ...
1
vote
2answers
50 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 ...
1
vote
0answers
24 views

Resuming log shipping, do I just restore the db over itself?

I have log shipping set up. I then bring all the databases online on the secondary machine, so log shipping can't restore anymore. A bit later on I want to resume log shipping. I was told before ...
1
vote
1answer
55 views

Sql Server 2008 R2 - Failed to send an environment change notification to a log shipping partner node

Login failed for user '*****'. Reason: Failed to send an environment change notification to a log shipping partner node while revalidating the login. I'm seeing a bunch of these errors on my ...
1
vote
1answer
30 views

What happens on the primary when log cannot be restored on the secondary on Log Shipping

I would like to setup a log shipping but I have a concern as to what would happen if the restore operation on the secondary would fail for some reason. I want the primary database keep working no ...
1
vote
0answers
35 views

Log shipping option not showing

I am using SQL Server 2008 R2 Standard Edition. I am trying to implement log shipping, but the log shipping option is not showing in the database properties window. The database recovery option is ...
1
vote
2answers
56 views

MS SQL Server 2012 Log Shipping Questions

I have a few questions regarding Log Shipping in SQL Server 2012. 1) If the primary database server dies, is it possible to allow users to connect to the secondary database so as to continue working ...
0
votes
1answer
33 views

How the xlogs files travels form Master to Slave

I have some doubts about how the workflow proccess in PostgreSQL replication using archiving logs. If I have this configuration in Master postgresql.conf: archive_command = 'test ! -f ...
1
vote
3answers
49 views

How can I sync databases to a secondary server for read-only usage?

I want to sync databases to a secondary server that will be used read-only for SQL Server Reporting Services. These syncs can be done once or twice nightly and mid morning; synced database sizes ...
3
votes
3answers
1k views

SQL Server: Log Shipping in “restoring” state: Can I temporarily take it out of restoring to check it?

I know it is normal for the target db to be in "restoring" state I also would like to do a few queries as a sanity check that the data is all up to date. Can I take it to a read only, non-restoring ...
1
vote
2answers
133 views

Transaction Log Shipping across multiple SQL Server versions

I'm lead to believe that TLS is only appropriate/supported across the same versions of SQL Server. What I'm trying to do is to maintain a reporting (read only) version of a production transactional ...
1
vote
1answer
41 views

How do I resume log shipping?

I was log shipping. I disabled the jobs, and restored the database on the secondary machine and used them for a bit. Now I want to undo this. I don't care about history or syncing, I simply want to ...
0
votes
2answers
39 views

How do I set a database back to 'Restoring…'?

Sorry if this is a noob question. I have transaction log shipping set up for a failover scenario. All the databases are in 'Restoring...' state until I do restore database x with recovery. At this ...
0
votes
1answer
52 views

Using existing SQL Server credentials for log shipping reporting purposes

I have set up log shipping, but I don't see how I can reset orphaned SQL Server credentials on the destination server as databases are in standby/read-only mode. I am getting push-back on ...
1
vote
1answer
86 views

After log shipping, I activate failover with a RESTORE. What happens when the next log shipping job runs?

I'm using log shipping for the first time. I've got it working between my primary and secondary server, on the secondary server the database is Restoring... which I understand basically means it is ...
1
vote
1answer
62 views

Log shipping - failed over to secondary, how to fail back

SQL 2012 I've been researching and testing Log Shipping as a DR solution. I got the two servers setup. Log shipping is in place and verified to be working correctly. I failed over by restoring the ...
1
vote
1answer
211 views

Transaction Log Shipping doesn't use the latest transaction log

I have setup transaction log shipping between two servers every 15 minutes, this is on SQL Server 2008 R2. The problem is that when the logs are being restored on the secondary server, it always uses ...
2
votes
2answers
460 views

How to do a one-time log shrink on a database with transactional replication

I have inherited a 10 GB database with an 80 GB log [only 3% in use according to DBCC SQLPERF(logspace)]. It seems safe to assume the extreme log growth was due to problems from long before I was ...
0
votes
1answer
555 views

Creating Users on secondary server in log shipping

I have a production Server say ServerA I have setup log shipping to ServerB which is left in read-only mode. The purpose of this log shipping is to lower the load on production server for some ...
0
votes
0answers
110 views

How to configure log shipping in SQL Server 2008 R2 Standard Edition

Could you please guide me on how to configure log shipping in SQL Server 2008 R2 Standard Edition for same hostname with two different IP's. (Primary and Secondary server) example: Primary machine ...
1
vote
2answers
399 views

Log shipping - switchover and failback

We are doing a planned failover and switch back from the primary to DR with mirroring. We do not have a separate monitor instance. Please help me with the following 1. Is it possible to switch back ...
1
vote
1answer
145 views

SSIS v/s Replication v/s logshipping

I have 2 SQL server instances, on different servers. One is Production instance and gets lots of reads and writes daily. Another one is for external applications to use a copy of few of the tables ...
3
votes
1answer
85 views

Log Shipping in lieu of replication

I have two SQL Server 2008 R2 systems that, due to network restrictions, cannot use SQL Server replication. However, data needs to be shared between these systems. It may be possible to send a file ...
1
vote
0answers
1k views

Issues with Log Shipping

First time at posting a question on here, so please bear with me and I'll try and detail all the information. Currently, I'm log shipping from SQL 2012 Standard Edition (11.0.3000) (lets call it ...
3
votes
1answer
52 views

Implement Log Shipping in prod env

We have a 3.5 TB DB which is already involved in log shipping to two different servers, as one will be in restore sate only and one will be in stand by mode which helps for reporting needs. All three ...
2
votes
1answer
636 views

This backup cannot be restored using WITH STANDBY because a database upgrade is needed. Reissue the RESTORE without WITH STANDBY

I am creating log shipping for two databases, db1 and db2. It will be from SQL Server 2008 r2 to newer version, SQL Server 2012 On the SQL 2008R2, they are both dbi_version = 661: DBCC TRACEON ...
1
vote
0answers
262 views

Log shipping on secondary server

Log shipping fails with the below error. Sql agent on secondary server has access to the folder and files in security. It is not a firewall issue. I created the jobs using the LS scripts as it fails ...
0
votes
2answers
231 views

Resume log shipping from a specific transaction

Is it possible to force SQL Log Shipping to run from a given .trn file onward? I have two databases, where one ships to another this was working fine. However I had to restore the primary database ...
1
vote
1answer
339 views

Approaches for Real time copy of database on same SQL Server instance

I have a draft of requirements that look like this: Production database should be copied in real-time to "Pre-prod" database The Pre-prod database should be available to read and update It should be ...
4
votes
1answer
237 views

How do I monitor PostgreSQL WAL shipping if I'm not using streaming replication?

We have a fairly simple setup to replicate from our on-premise master PostgreSQL database to our presentation tier in AWS. We're using WAL shipping using the archive_command setting. Basically the ...
2
votes
5answers
3k views

Mirroring vs. Log Shipping

The software company I work for is planning to migrating our infrastructure into the cloud. Our current focus is to find the best database replication method. Current Servers: SQL Server 2008 SE - ...
3
votes
1answer
1k views

How does Log shipping knows to keep track

I have set up log shipping between 2 SQL Servers (SQL Server 2008 and SQL Server 2012). At first i took a full backup of the first one and restored it on the other one and than i set up the log ...
0
votes
2answers
217 views

How does Log shipping knows to keep track [duplicate]

I have set up log shipping between 2 SQL Servers (SQL Server 2008 and SQL Server 2012), At first i took a full backup of the first one and restored it on the other one and than i set up the log ...
3
votes
1answer
523 views

Why does Log Shipping .TRN file copy just stop

I apologize in advance for a long post but I have had it up to here with this error of having to delete LS configuration and starting it over for any DB thats got this error. I have LS setup on 3 ...
-2
votes
1answer
401 views

Restore to last transaction log restore

We have a log shipping setup where we replicate from our primary database to a secondary. Now that database is, by the way of log shipping, in standby and thus read-only. We set it up so we could ...
0
votes
1answer
341 views

Create Log Shipping Step Failed After ServerName Changed

I was doing some test on server name change and encounter some errors. Here is the original setup: Server name - ServerA, SQL Server default instance - ServerA Changes: Server name - ServerB Before ...
0
votes
0answers
61 views

Copy tables from a stand-by database

I want to explain the following. I have a database that is a recovery db from our main environment. This database is kept up-to-date through log shipping. However, I want to copy all tables from this ...
-1
votes
1answer
610 views

Directory lookup failed during log shipping

I have configured log shipping for all our SharePoint 2010 databases. All worked well since Friday and today Monday I ran this query: SELECT * FROM [msdb].[dbo].[sysjobhistory] WHERE [message] like ...
1
vote
1answer
60 views

Inhibit Sql Server Log Shipping Alerts during certain times

There are batch jobs that occur in the middle of the night, which cause log shipping backups to be delayed such that they exceed the alert threshold, and alerts are then emailed. How can I disable ...
0
votes
2answers
215 views

which sql server edition is good for practice [closed]

Which SQL Server (free/trail) would be good to install, which requires minimum resource and have maximum features. I mean, I can practice mirroring,logshipping and replication. I found this link, but ...
0
votes
1answer
267 views

Can I deactivate log shipping jobs without raising errors?

I've set up log shipping from Server A to Server B. I then set it up from B to A when B was the primary. I've reverted back to A being primary and disabled the backup, copy and restore jobs ...
2
votes
2answers
509 views

Bandwidth comparison between log shipping and transactional replication

Which technique uses more network bandwidth: Log shipping Transactional Replication Can some one share any benchmarks for the same ? What would be the Memory and I/O impact on the Primary server ...
0
votes
2answers
2k views

Resume Logshipping after Primary database restored

We have Database (D1) as a primary database and Log shipping setup to the secondary database called (LS_D1). Now what we are doing is taking backup of D1 database and restore it on D2 database. We do ...
0
votes
1answer
827 views

Getting timeouts and backup errors after mirroring and log shipping is setup

OS is Windows Server 2003 32 bit. SQL Server is SQL Server 2008 SP3 32 bit Today I finished configuring database mirroring and log shipping for 3 databases on this SQL instance and started receiving ...
3
votes
2answers
1k views

Migrate SQL Server database to multiple files (shrinkfile emptyfile vs log shipping)

I have a SQL Server 2008 database in production that we are moving onto a new server. The current database has a single ~400GB .MDF file. The new server will be running SQL Server 2012, and we are ...
2
votes
0answers
111 views

Can the same database be log-shipping secondary and primary at the same time?

Here is my scenario: Database DB1 on Server1 is log shipping primary in data center. Database DB1 on Server2 is log shipping secondary; Server2 is in remote location. Logs are shipped from data ...
6
votes
2answers
4k views

Log Shipping - RESTORE WITH STANDBY - on SQL Server 2012 keeps breaking

We are using log shipping and RESTORE WITH STANDBY on SQL Server 2012 in order to restore the database in read-only mode for reporting purposes. However, the log shipping setup keeps breaking after ...
3
votes
0answers
447 views

SQL Server Database Hot Backups: Which Technique(s) to Use for Multi-Level Replication?

I'm reading the many other posts here about mirroring vs. replication, but I'd still appreciate it if someone with some experience would weigh in. My small development team needs to have local ...
1
vote
1answer
183 views

Can I run a Report Server and a Mirror server from a working Log Shipping secondary instance? [closed]

Our setup: City A - Primary server for logshipping City B - Secondary server for logshipping Now there is a lot of data being updated from A - B. And the server in City B is underutilized, and it ...
4
votes
1answer
286 views

What are the advantages of a monitor server for log shipping

I'm researching and implementing log shipping as part of disaster recovery for our SQL server. I've seen that a monitor server is recommended (but not required) for monitoring the log shipping ...