Agent has a lock on the file due to jobs that are running when attempting to cycle the SQL Agent log. The error comes up most often when replication is...

If the server on VMWare, then you may want to check the following:

https://support.microsoft.com/en-us/kb/2519834

Sue

What is the definition for your format file? I think you probably need to use a format file in your case.

Did you try specifying the prefix length as 0...

In addition to working on managing the log files in general, you may want to take a look at the import process itself. You likely have some large transactions which...

As to this specific database and your current issue, it looks like the log just isn't being managed as well as it should. When you have a database in full...

I would guess that the difference would be in the server level permissions for public and a difference between those for the two environments, especially for the permissions VIEW ANY...