Thanks for the reply.

I reviewed your suggestion, would you please let me know how can I use the function run time in a SQL insert statement.

Thanks.

Yes, I need to track changes to actual server and collect statistics like # users sessions/hour, locks/hour, SELECT/hour, time outs/hour, update/hour, adding new users, database growth/day, etc.,

Please suggest me a...

On our server, we faced the same problem and the database size was 7+ GB. In order to resolve the issue, I have taken the backup to multiple files... backup...

Can someone explain it.

A table was accidentally deleted at 11:55 pm.  NEED TO CHANGE TO 11:55 am, then your answer was right. If not D is correct.

How about adding some log space and try your backup process again.