1. as Chris says, you have a job that truncates the log.

2. you have a maintenance plan truncating the log

3. you have an application that is truncating the log.

How was...

You can:

1. RESTORE the backup file to the new server.

or

2. Attach the .mdf and .ldf files.

Refer to the BOL for the syntax for RESTORE DATABASE and sp_attach_db.

-SQLBill

So you can't make any changes to the initial database where everything is checked?

Since the logins are unique, why do a 'initial database' at all? Create each login on the...

Ah, two backups going on. Possibly tried to backup at the same time? Maybe you can't log ship at the same time a backup is being performed.

-SQLBill

Maybe.....set up three views in the SDE database. Give permissions to the proper class for each view. Have the connection check one common table for authentication and then from there...

It could be lots of things....have you checked the SQL Server Error log for messages, how about the Windows Event Viewer logs on each box?

Also, right click on that job,...

I took a look at it once and DBCC LOG really doesn't provide much of anything usable.

-SQLBill

Glad to help.

-SQLBill

I apologize. But do you work with a Jerry Grant? He posted the exact same question, looks like the exact same wording.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=248510

-SQLBill

Please don't double post. You have posted this elsewhere on this site and I have started responding there.

-SQLBill

What do you use the SQL Server for? Applications? Stop the SQL Server services, stop any applications that connect to the databases. Restart the MSSQLServer service (not the SQLServerAgent...

Here is something else that might help.....

Copy the query from QA into a .txt file (Notepad). Then use find and replace. First replace all occurances of your first tablename with...

Which database? Is it a system or user database?

-SQLBill

Ah I think I mispoke and apologize for that. I think you are saying you DID replace the names and got that error and for our viewing you replaced...

Any help for that error?

YES. As I said:

YOU need to replace the table and column names with the REAL table and column names.

-SQLBill