All databases have a log and that includes the TempDB. And any transactions on the TempDB are logged.

-SQLBill

Did you do any database maintenance, such as reindexing (DBCC DBREINDEX) or index defragging (DBCC INDEXDEFRAG)?

That will cause your tlog to grow to huge sizes (reindexing can cause your tlog...

I do a full backup every day, a diff 12 hours later and tlogs every 4 hours.

Since you use WITH INIT, your tlog backups are worthless. You need ALL the...

The SQL used for Access (Jet-SQL) is not the same as the SQL used for SQL Server (Transact SQL). They are similar but different. The differences might be causing your...

When you restore a database, normally you DON'T create it first. In your case, you have two options:

1. DROP the database and then do the restore, or

2. RESTORE the database...

Okay. But did it include WITH NORECOVERY or WITH STANDBY? It probably didn't. That means you can't add any more backup files.

RESTORE DATABASE mydb

FROM Blah

That defaults to WITH...

Couple of thoughts.....

1. Have you run the subquery by itself to ensure it returns something that matches c.mgr?

2. This portion of the WHERE could be a problem: and t.Mgr =...

You don't give table/column names nor data types. And you don't give sample data.......so......

SELECT *

FROM MyTable

WHERE MyDate = (SELECT MAX(MyDate)

...

Can you store the number as a DECIMAL instead of a VARCHAR?

VARCHAR, being a string, sorts alphabetically.

DECIMAL, being a number, will sort numbers propery.

-SQLBill

We can't tell you. We don't know all the facts. Like, what else will be happening on the database? The more transactions occuring, the longer it will take.

That said......I just...

Yes. Apply the same MDAC to the server with SQL Server.

-SQLBill

Are you doing backups on all your databases? Are you doing transaction log backups on any databases where the recovery mode is set to FULL?

I agree that's a lot of...

Query Analyzer

Enterprise Manager

SQL Profiler

Veritas Backup Exec

Crystal Reports

-SQLBill

The problem with Auto anything, is that SQL Server will do it 'when it feels like it'. It chooses when is the best time to run that command, so...

Without seeing the code, it's going to be almost impossible for us to help with this.

My guess would be what you say it can't be......somewhere in your script you have...