I have a copy of my prod database on a development server. I am using it to test a deployment script.
But when I run it, it says that the log file is full.
I checked and it is at 10 GB (Almost the size of the full database).
I don't need this database but for a few more hours (after that it is going to get dropped).
Is there any way to get rid of the log file gracefully? (It seems wrong to just go delete it.)
I have run this:
select log_reuse_wait, log_reuse_wait_desc, name from sys.databases where name = 'ProdCopyDatabase'
And the result is:
log_reuse_wait log_reuse_wait_desc name 2 LOG_BACKUP ProdCopyDatabase