Search all PowerShell modules and cmdlets from Microsoft – just start clicking on it
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....
thank you it's really helpful...
ReplyDeleteI am always here for help
DeleteGreat
ReplyDelete