Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kkk514
Starting Member
8 Posts |
 Posted - 2010-05-01 : 02:26:24
|
| I am getting the following error in my Lite speed maintenance plan to take log backup of db which runs every 15 times. This error is not continuous or there is no specific time when the job fails but completes successfully in next run. It fails randomly 2-3 times a day.Description: Executing the query "execute master..xp_slssqlmaint N'-D "MIO_Database" -BkUpMedia DISK -DelBkUps 2DAYS -BkUpLog "E:\mssql\backup" -CrBkSubDir -BkExt "trn" -NOOPTOLR -Throttle 100 -BufferCount 20 -MaxTransferSize 1048576 -CompressionLevel 1 -Priority 0 -Logging 0 -Affinity 0 -NO_OUTPUT ' " failed with the following error: "slssqlmaint failed". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. End Er... The package execution fa... The step failed.We are using - Microsoft SQL Server 2005 - 9.00.4211.00 (X64)Lite speed version : 5.2.0.1240Retention Period: 2 daysAlso, noticed that at times the physical .trn backup files is present in the backup folder when job fails. Any configuration is the maintenance plan need to be changed.Any help please.. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
kkk514
Starting Member
8 Posts |
Posted - 2010-05-03 : 03:19:43
|
| Hi Tara,I believe, we are running on latest Lite speed version.Lite speed version : 5.2.0.1240Thanks |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2010-05-03 : 23:52:20
|
| Have you reviewed the windows event logs for any errors around the time you get this error? There should be another error that will give you more information about the problem. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2010-05-04 : 22:54:00
|
| I have seen event log errors where there were network related issues, storage issues - access issues, etc...Litespeed doesn't report those errors and refers you to the event logs, which is why I asked the question. |
|
|
|
ap76
Starting Member
1 Post |
Posted - 2010-09-06 : 10:35:14
|
| I think u need to check the latest Litespeed registration. Had same issue faced but got it resolved by registrating again. |
|
|
|
|
|
|
Lite speed tlog backup error