Log file

[edwardturner]

Can anyone tell me the SQL command to stop the log file being written to (assuming there is one!)?

The SQL script I am trying to run increases the log file to about 11Gb and it is at that point my HDD gets full so the script does not finish. Therefore I need a way to switch off the log file while this script is running.

Any ideas?

 

[SQLBI]

edward,

By setting your DB recovery model to "Simple" you will stop the log being written to.

Enterprise Manager > Right Click DB > Properties > Options > Change Model to Simple.

Hope this helps,


Cheers,
Leigh

"Give a man a fish and he can feed himself for a day..."
Give him the means to catch his own fish and he can really annoy his girlfriend by spending all his spare time fishing!

Join the PAC -

http://www.pacgb.co.uk/

 

[SQLBI]

Also in T-SQL:

alter database db_name
set recovery simple

Cheers,
Leigh

"Give a man a fish and he can feed himself for a day..."
Give him the means to catch his own fish and he can really annoy his girlfriend by spending all his spare time fishing!

Join the PAC -

http://www.pacgb.co.uk/

 

[SQLBI]

And to put it back to full when you've finished...

alter database db_name
set recovery full

Cheers,
Leigh

"Give a man a fish and he can feed himself for a day..."
Give him the means to catch his own fish and he can really annoy his girlfriend by spending all his spare time fishing!

Join the PAC -

http://www.pacgb.co.uk/