Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

not using a log file?

Status
Not open for further replies.

smsinger3

Programmer
Oct 5, 2000
192
US
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
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top