SQL Server Log Shipping - Log Shipping is a basic level SQL Server high-availability technology that is part of SQL Server. It is an automated backup and restore process that allows you to create another copy of your database for failover. Log shipping involves copying a database backup and subsequent transaction log backups from the primary (source) server and restoring the database and transaction log backups on one or more secondary (Stand By / Destination) servers. The Target Database is in a standby or no-recovery mode on the secondary server(s) which allows subsequent transaction logs to be backed up on the primary and shipped (or copied) to the secondary servers and then applied (restored) there. Log Shipping Permissions Note:-To setup a log-shipping you must have sysadmin rights on the server. Log Shipping Minimum Requirements SQL Server 2005 or later Standard, Work group or Enterprise editions must be installed on all server instances involved in log shipping....
My Windows Server 2012 R2 Evaluation version is going to expire... Every IT guy should have testing environment, and things should not be tested in production. This is where Windows Server 2012 R2 Evaluation version is great help. I use Server 2012 R2 Evaluation versions in all of my LABs. here is useful info for Windows Server 2012 R2 Evaluation https://www.microsoft.com/en-us/evalcenter/evaluate-windows-server-2012-r2 I have trick to use Windows Server 2012 R2 Evaluation free of cost.Windows Server 2012 R2 evaluation is valid for 180 days. you can reset 180 Days countdown You can „rearm“ Windows Server 2012 R2 evaluation up to 5 times. Following command will „rearm“ your trial Windows Server 2012 R2. Run Command Prompt with Administrator Privileges and run following command: slmgr.vbs -rearm After that you need to restart your server for changes to take effect. Now days counter has been reset successfully . you can use this...