not using a log file?

[smsinger3]

Hello.

I am copying a "production" database to my test server using backup/restore. I don't have much room on my test server, so I would like to either remove the use of the log file, or use it as little as possible (i.e., not have any inserts/deletes/updates logged). Does anyone know how to do this?

Thanks in advance,

Steve S.
sms@hmbnet.com

 

[Tim1]

Hi Steve,

I am not aware that you can turn the transaction log off. All that you can do is ensure that you use very small batch sizes and commit frequently to keep the amount of data stored to a minimum.

The alternative maybe to log onto another device? Can the server that you are putting the system onto see another server, in which case you could temporarily put the transaction log onto that system.

Finally, don't forget to leave enough space for tempdb, otherwise if that crashes, it will bring your whole system down.

Good luck,

Tim

 

[foxdev]

You could turn on the truncate log on checkpoint option; this would eliminate the log, but will cause it to be dynamically truncated and won't grow very large. Robert Bradley

http://www.agrainofhope.org

http://www.lowcostprints.com

http://www.foxdev.com