Where to find any information that is recorded during LogShipping activities?
1. Open SQL server via Enterprise Manager | select LiteSpeedLocal database | drop down to the tables below;
2. Right click | select open table(s) to display actual values.
a. In your LiteSpeedLocal, the following tables will register activities that belong to LogShipping;
1. LSBACKUPLOG
2. LSCOPYLOG
3. LSTRACKINGLOG
4. LSRESTORELOG
5. LSBASEOPTIONS (You can change the logging ON/OFF here, by change the flag to 1 for ON and 0 for OFF)
a. Field name ----> ErrorLogging = 0 for OFF.
example: use litespeedlocal
go
update LSBaseOptions
set errorlogging=1
where planid='planID'
go
select * from litespeedlocal..lstrackinglog
Order by logtimestamp, planid
SQL2K SP4.
OS2K.
LiteSpeed versions > 4.6.0.00279
