An easy way is:

Set the autonumber (Identity) in off.

save the table

Set the autonumber (Identity) in on.

Save the table.

Hi JP

I have cretae a sql profiler trace, but nothing appears to populate the database so big, in order to increase the log size.

Looking a the log size (the big...

Hi JP de Jong

Thanks for the answer, but:

-NO large amounts of data are written.

(this changes even occurs when no user is connected)

-I do not make any  index defrag.

-Each...

Thanks Ray

Your comments have helped.

Greets.

NTFS fragmentation can cause all sorts of problems - do you have sufficient free contiguous disk space for your backup - Is your data/log drive fragmented.

That was the problem!!!!!!!!

Disk fragmentation....

Nothing has change in the Database.

just the normal load of every day.

Jason:

Thanks for the answer.

Yes... I have checked the Event Log, and there were no Hardware errors.

Any ideas?

Thanks in advance.