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 up when the primary fails. Recovering and starting with the secondary should not have to ...
I have setup both mirroring and and log shipping on 8 databases of about 10 GB each size on same instance, but now when I want to mirror another database it very long to display the Database Properties page. Any suggestion for this problem. ...
Hi Can any one please, tell me that when we configure log shipping do we have to open a firewall from the destination server to the source server too. Thanks ...
Hi all! 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 a server based in Europe which is dedicated to Microsoft Reporting Services, w...
Hi, I'm in the process of upgrading from SQL 2000 - SQL 2008 Would it be possible (or feasable) to set up log shipping from Server A - that has the sql 2000 database on, to Server B - that has the SQL 2008 instance on Or is there a better way of upgrading? I need to obviously test my application using the new SQL 2008 instance.... ...
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 across this on a sqlservercentral forum thread: When you create the log shipping you ...
Hi. I'm hoping someone can help me a WAL-shipping and warm standby issue. My standby system runs happily for weeks, then all of a sudden it starts looking for .history files that don't exist. It then craps out and I can't successfully restart it without rebuilding the standby. Both systems are running CentOS 4.5 and postgres 8.4.1. The...
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 between the backup of the primary and it's restore onto the secondary? The new database will ...
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 secondary) for each log-shipped database. Do I try to write my own or use something like Quest...
I need to set up log shipping for about 10 databases. The primary server is accessed by our website and the secondary server is a BI server. What I am struggling to figure out at moment is the best way to handle a “failback” situation once a failover has occurred. How do I get the primary server back to being the main server for the webs...
I need a consistent way to monitor databases that are read-only log shipped copies of production databases. In the past I have relied on the following methods: Set the job that restores logs to the database kick off another job as its last step. Set the job that restores logs to the database to insert a record in a control table as it...
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 (mirror, subscriber) server Write load can be sent directly to the primary server The solution ...
I'm currently taking the MS SQL 2K5 Admin course at a local college and ran into a problem with the Log Shipping part. My setup is the following: Windows 7 x64 SQL 2005 SP3 2 SQL server instances on the same machine Log Shipping settings: Performed full then log back up of Primary Manually restore on Secondary in STANDBY MODE Insert...
We have two SQL 2008 servers on different networks that will soon have a VPN connecting them. Soon is 2-3 weeks. If that were in place now we could easily setup Transaction Log Shipping (or other method) of keeping the destination (Standby / Read-Only) database up to date. How do we setup the LSRestore_ job on that destination database w...
Hello, I am tasked with setting up a disaster recovery for one of our system. The primary server is in FL and the secondary is in Germany. The application is a global application within my company. I am not sure if I should use Log shipping or Mirroring. What I have read is that mirroring will have an adverse effect on the performance ...
I have a working WAL shipping setup with a warm standby slave server applying the WAL files. When I create the pg_standby trigger file, it detects this at once, but it takes about 10-15 minutes to actually be ready for accepting connections. Most of the time is spent waiting for .history files. The trigger file is empty, so a "smart" f...