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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-07-06 : 07:54:31
|
| alun writes "HiI hope you can provide me with a solution to my SQL Log Shipping problem.The company I have just joined has had log shipping in place for some time now, but for a few specific database tasks (the actual restore of the log), we are getting errors which I cannot seem to find a solution to. The error is:Executed as user: SKMCONSULTING\sqlservice. Line 1: Incorrect syntax near '*'. [SQLSTATE 42000] (Error 170) Deleting database file 'E:\SQL2000\MSSQL$MISC\backup\<db-name>-UNDO.ldf'. [SQLSTATE 01000] (Error 3738) RESTORE LOG successfully processed 0 pages in 0.350 seconds (0.000 MB/sec). [SQLSTATE 01000] (Error 3014). The step failed.Note here, that the actual restore of the log to the database does happen, but the error is still coming up. Additionally, this only occurs on an irregular basis, about 5 to 6 times daily (not at the same times either), where as the other times it works. I thought that it maybe due to an empty log file but this is not the case.I have checked the tasks for all the other databases and they are identical, with the exception of a specific id for the database. Additionally, I have gone through all the stored procedures and cannot find any reference to the char '*'. I have also tried a lot of websites to see if there is any reference to this error, but to no avail.Something tells me that this is simple, but I cannot for the life of me work this out.Your help would be greatly appreciated.King RegardsAlun GriffithsOps DBA - SKM ConsultingAustralia" |
|
|
|
|
|
SQL 2K Log Shipping