Comments
Sort by recent activity
Thanks for reply,
but I found a pdf file where it is mention that sql backup pro should be installed on both server.
May be it is required because this red gate tool use compress version of backup file which should be uncompressed on secondary server. Prerequisites
To perform log shipping using the SQL Backup Log Shipping wizard:
•
You must have at least two SQL Server database engine servers or two database engine instances in your log shipping implementation.
Note that you cannot ship transaction logs from a SQL Server 2005 database to a SQL Server 2000 database, because of the differences in their structures (but you can ship from a SQL Server 2000 database to a SQL Server 2005 database if you use No Recovery Mode – see Choosing the Log Shipping Mode later in this article).
•
SQL Backup Pro must be installed on both of the SQL Servers.
•
The database must use the full or bulk-logged recovery model.
•
You must have a shared folder to copy the transaction log backups to.
The SQL Server Agent service account of the primary server must have read/write access either to the shared folder or to the local NTFS folder. The SQL Server Agent account of the standby server must have read and delete access to the shared folder.
•
The SQL Server Agent services must be running and configured with network credentials (such as a domain account) if you plan to use a network share as the shared folder.
You can configure log shipping with SQL Server Agent services stopped, but the process does not run until the agent is started. / comments
Thanks for reply,
but I found a pdf file where it is mention that sql backup pro should be installed on both server.
May be it is required because this red gate tool use compress version of backup ...
Yes , That was something urgent that's why i paste my query in forums also.
Thanks to reply, Its now resolved. / comments
Yes , That was something urgent that's why i paste my query in forums also.
Thanks to reply, Its now resolved.