I have multiple transaction log files. I don't need the transaction logs and intended to remove them. I have tried detaching the database, rename the logs and trying to re-attach the database without the logs but to no avail. The error message mentioned something like file activation failed and SQL couldn't rebuild the transaction logs.
Is there a way to get rid of the transaction log files?
you can use sp_attach_single_file_db but it works only on databases that have a single log file.
When sp_attach_single_file_db attaches the database to the server, it builds a new log file. If the database is read-only, the log file is built in its previous location.
OR by reading this thread attaching DB without .ldf file ???
There are lot of limitation with sp_attach_single_file_db. The database should not have morethan one LOG and Datafile and the database should be properly detached. So in your case this process will not do. You requirement is to remove the Secondary LOG File, if am correct. What you can do is, Remove the secondary log file first using
DBCC SHRINKFILE (,EMPTYFILE)
alter database test remove file .
Then you can trucate the primary log file to any size you want. Please take backup of the database before starting anything