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.
Is it possible to set upLog shipping between 2 SQL server 2008 database servers without opening any ports?
There is already a backup job plan that runs every 15 minutes. I created transaction log shipping process but afte开发者_JS百科r 1 or two restored logs this job stops working (error: it can\'t find ma
We have implemented log shipping as a database disaster recovery solution and want开发者_C百科 to know if there is a way I can use T-SQL to script all the logins, users, roles permissions etc to the m
I\'m trying to limit the size of individual files that are transferred as part of log shipping (as I am using WebDAV for transport).
I have a physical Prod DB Server (SQL05) and now a VM DB Server.The idea is if the physical machine goes down, we repoint our router (via NAT) to the VM machine.I am thinking of using Log Shipping to
Is it possible to automate Log Shipping Failover and Recov开发者_如何转开发er Secondary Database in Log Shipping, something in Powershell where it checks for are there any more .trn files to be copied
My company\'s website uses a PostgreSQL database.In our data center we have a master DB and a few read-only slave DB\'s, and we use Londiste for continuous replication between them.
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:
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 wa