Hi All

I would like to know if there's a possibility to run a select query WITHOUT it using the log file... any suggestions (the server is not fit enough and every run ends up with multiple errors for log file space and stuff like that - I don't need it to keep the log for these queries)



Re: Running queries without the log file

Konstantin Kosinsky

Do you mean transaction log

You could change logging mode from Full to Simple. And trunsaction log will be used only for supporting active transaction.

Re: Running queries without the log file

Arnie Rowland

No, every data manipulation query will use the log file.

However, if you are not concerned about having the ability to do up to the second restores, you could change to 'SIMPLE' recovery model. The will minimize the size of the Transaction Log.

But be warned, very large queries will still use a log of Transaction Log space. You may need to execute large queries in a manner that handles a 'batch' of data at a time instead of trying to use the entire table.

Re: Running queries without the log file

Louis Davidson

Not sure what you mean. As far as I know, a SELECT query will never use the SQL Server log file. In 2005, if you are using snapshot isolation level it might read to tempdb, but not the log.

What log file are you talking about