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 |
|
franco
Constraint Violating Yak Guru
255 Posts |
 Posted - 2001-12-18 : 03:53:09
|
| SQL 2K sp2 on NT4 EE SP6a.During the DTS Import operation from the production Server (SQL 7.0 SP1) to the Test Server (SQL 2K SP2) I receive the following notification error on the NT application log:EVENT ID: 17055Source: MSSQLSERVERType: Errorcategory: BackupDescription:18278: Database log truncated: Database: XXXThe operation of Import succeed, but I have the "red error" on my NT application log.Some more informations:The package simply import a full database from one server to another server,tables, Views, Stored procedures, data,referential integrity constraints,security and indexes.It is a copy Sql Server objects Task.The error is showing on the 2K Server.The recovery model is set to full on the SQL 2K and the option "truncate log on checkpoint" is NOT set on the SQL 7.0 Server.The question is that this is the only activity on the Server during the night.I have scheduled a full backup DB at 6.00 in the morning while the import DB is scheduled at 4.00.It may be that for some reason DTS set the DB in simple recovery mode and that is why I receive this error?There is something interesting here:http://support.microsoft.com/directory/article.asp?ID=KB;EN-US;q308267This was a "known problem" with SP1 and it was supposedly fixed.Any Ideas?Regards.FrancoEdited by - franco on 12/18/2001 10:43:23 |
|
|
|
|
|
18278:Database log truncated:Database:XXX