Prerequisite for LiteSpeed LogShipping (4354450)

Several requirements must be met for  LiteSpeed LogShipping to run successfully.

 Prerequisite for LiteSpeed LogShipping:

1) SQL Server is started with a domain user account having local administrator privileges on the  servers (OS Level) and sysadmin rights on both SQL Servers.

2) If the SQL Servers are in a workgroup, both SQL Servers should be started with Windows user account having same user id and password. Again, they have to have local system administrator privileges on the server(OS Level) and sysadmin right on both SQL Servers.

3) Both servers should be able to see each other. (ping from one server should be able to reach the other server and vice versa)

4) The name of the SQL Server using in connection string should be exactly the same as result returned from 'select @@servername' from Query Analyzer.

5) SQL Server Agent is turned on.

6) Same version of LiteSpeed Engine has to be Installed on both SQL Server. (use 'exec xp_sqllitespeed_version' from master in query analyzer to get the version)

7) Same version of LiteSpeedLocal Database is installed on both servers with same name. (run 'select * from LiteSpeedVersion' in your Local database)

8) There should be a share folder either on the publisher, subscriber or on the network that can be fully manipulated by both SQL Servers (UNC path will be used to access it)