log-shipping's questions - English 1answer

232 log-shipping questions.

I have created log shipping and the primary server is also used for transactional replication. Now after creating log shipping I have noticed the publisher shows up on the secondary and it wont let ...

I wish to implement log shipping from my current primary which is a SQL Server 2014 Enterprise database to a SQL Server 2017 Standard edition database. I also wish to implement table partitioning on ...

I have a problem with Transaction Log Shipping on the SQL Server 2014 edition. I have to log ship 4 databases, 2 of them are fine and the other 2 ALWAYS fail but not at first. When it fails, SQL ...

Have seen a couple of posts similar to my scenario, but nothing that actually resolves my issue. Scenario: Routine index rebuild happens, once a week, 2 AM Saturday morning. Log file grows about 15x ...

I am editing my previous question to be more precise as i am still unable to get the logic behind the log shipping restore job. May be there is something i am missing to explain but will try my best. ...

Configuration: LSPrimary01 - Log Shipping Primary LSSecondary01 - Log Shipping Secondary OddServer03 - This server is not part of the LS configuration, the odd man out Sean\LSServiceAccount - The ...

One basic question. We are using LS between 2 servers for reporting purpose. LS backup runs on primary every 15 minutes. On Secondary nightly restore via LS restore job is done daily at 10 PM. Since ...

I have three SQL Server instances (SQLInstance-1, SQLInstance-2, and SQLInstance-3).I want configure three (or more) servers: SQLServer-1 – primary SQLServer-2 – secondary SQLServer-3 – secondary I ...

I had a question on Log shipping Manual Fail over Let me explain about environment, Primary Server A (with Cluster setup A-P Mode) Secondary server B(DR server standalone). We had enabled Log ...

I have log shipping enabled on my database. I created a file, with let's say logical name 'AB' of 50 MB at location E:\Databases\AB.ndf. However, I later dropped this file and created another file ...

Is there is any way to set up Log Shipping with Data Domain. My thought process was to have data domain do the full back up and skip the Transaction Logs. I will have a separate job that does the T ...

I have set up the log shipping process and can see all 3 jobs running successfully. Primary server - LSBackup_DatabaseName Secondary server - LSCopy_SERVERNAME_DatabaseName & ...

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: ...

I am in a situation where I need to expand a data file by 750 Gb in order to get to 20% free space in the data files. This is a requirement by our third party application developer in order to ...

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 ...

I have a primary OLTP server on Server A and Log Shipping in Standby/Readonly mode on Server B. Log Shipping Server is refreshed every 4 hours, and utilized for BI Reporting Analysis, to reduce load ...

We use Log Shipping to allow Business Analysis users to query data. I would like to email the Log Shipping Status report to users to see last time data is refreshed. When I Right Click on Server--&...

The company I'm doing some work for is using log shipping to sync a production database with a secondary. Is there any way I can determine the rows that were inserted, updated or deleted after a ...

I was reading this article about SQL Server log shipping and the statement was made that log shipping supports limited read-only access to secondary databases (during the interval between restore jobs)...

I am configuring log shipping , In Pinal's site I try changing login to SA https://blog.sqlauthority.com/2017/12/23/sql-server-msg-32055-sp_refresh_log_shipping_monitor-error-configuring-remote-...

I have Log Shipping setup from Primary Server A to Destination B. Server B is both Destination and Monitoring server. Yesterday, we restarted both servers around the same time for patching. On the Log ...

I have a transaction log shipping configured. Job activity monitor shows that both Copy and Restore steps have failed, however, I see that backup files are in fact copied across to the secondary ...

I set my database to Full Recovery a few months ago (to allow point-in-time restores) and set up Transaction Log backups with Maintenance Plan. Now we want to conduct Log Shipping with the same ...

We plan to incorporate Log Shipping for basic disaster recovery with reporting needs. Server A Source Database will log ship to Server B database. We will conduct log shipping every four hours. ...

We plan to incorporate Log Shipping for basic disaster recovery with reporting needs. Server A Source Database will log ship to Server B database. We will conduct log shipping every few hours. ...

I setup Log Shipping. I have Secondary Destination Server as Monitoring server also. For some reason when running this system stored procedure or looking at Server-->Reports-->Transaction Log Shipping ...

Company may implement Log Shipping with Snapshot. This provides basic Disaster Recovery with Reporting area. Server A OLTP contains database which log ships to Server B (ReadOnly-Standby), Snapshot is ...

Which is easier to maintain as Disaster Recovery on a remote site for a 2-node SQL Server Cluster Log Shipping Single Instance of Always on Availability Group Instance. Any suggestion will be ...

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 then I set up the log ...

Log Shipping Failover I have set up log Shipping with Cluster. In this scenario I want to simulate a situation when the whole cluster becomes inaccessible. My Steps for failover will be 1) Copy ...

If I have SQL Log Shipping scheduled as follows: Primary Server (VM): Backup Job Schedule - Every 5 Minutes (To LogCopyTo) Secondary Server (VM): Copy Job - Every 15 Minutes (To LogCopyFrom) ...

Looking for the fastest way of restoring multiple SQL Server standby databases that got out of sync. Server A is a production server, has 50 databases configured with LSBACKUP jobs. Server B is a ...

After adding: expire_logs_days=7 is it necessary to change reset the master's position and file? I had modified the my.cnf figuring that would delete the no longer needed binary logs older than 7 ...

I have configured Log Shipping where the primary server database has snapshot_isolation_state_desc reported as off. I tried to turn it off on the secondary which is a standby read only by using the ...

In Our environment, Log log shipping is configured and working good. Transaction logs are Backed-up on Primary Server. Copy to Backup DB Restore on Backup DB. Background: We are in process of ...

Failover Over Cluster 2 Node - 6 Cores- Enterprise Edition 2014 Log Shipping with Cluster with 4 Core License- Enterprise Edition 2014 My question is if I need to log ship do I need to match the ...

I am doing log shipping failover and failback configuration in SQL Server 2008 R2 environment. During the Failover, I am taking the tail log backup of primary database with query: Script to backup ...

We use transaction replication to replicate our production database to another server(server 1) for reporting purpose. For a standby copy, we also logship the main database to another server (server 2)...

We recently suffered a power/connectivity outage at a data center housing two PostgreSQL 8.4 secondary servers, that remotely back up our two primaries via log-shipping replication. Backup power kept ...

I am trying to log ship from server A to B. I have done everything to configure log shipping but when I try to run the job at Server B while copying a backup from server A, ikt gives me an error: ...

Below is my current cluster set up Node 1 - Active Node 2 - Passive While doing Log SHipping can I save the back ups to a network share instead of a clustered file share? The service account ...

We have a need where we need to set up LS for the servers where we use NAS for backups. As NAS is shared between Primary and Secondary there will not be a need to use LS COpy job as backups will be ...

Current Set up- Clustered Instance Active/Passive Node -1 Node -2 Current Back ups goes to Network Drive Cluster Drive E drive Virtual Name ABC Shared Folder - e\Share New instance- for Log ...

I am trying to get sp_AllNightLog running on an existing server that had regular SQL log shipping (now removed) and Ola Hallengren's backup utility for nightly backups. I have the procs and jobs ...

The Configuration Primary DB SQL Server 2008 R2 SP3 Web Edition running in windows Server 2012 R2 x64 on a local RAID 10 SAS 10k disk array co-located in an enterprise grade datacentre Secondary DB ...

Need some Guidance/steps or any reference to link on how safety and quickly can I switch from Log-shipping to Mirroring as we have very small downtime to complete the activity [5-10 mins]. Also how ...

i logged into a client's server today(which had log shipping for all of its db's), and found that someone changed all the databases recovery models to simple. so now i need to reconfigure the log ...

We have set up LS to do cutover from standalone SQL server 2012 to clustered 2012 servers. The primary database where we have set up LS is also involved in database mirroring and is about 1.8 TB in ...

Am log shipping a large, busy DB from server A (primary) to server B (secondary). Nightly backups are taken, as well as diffs every X hours, and transaction logs are shipped and restored every 15 ...

We have a heavily used database server (SQL 2012 Web edition) which is currently a single point of failure (nightly backups and no additional hardware provisioned!) The server has a constant stream ...

Related tags

Hot questions

Language

Popular Tags