I DONT HAVE MORE WORKING EXPERIENCE IN SQL SERVER
I had done some time before to reduce log file size in sql server; detached the database and rename the big log file and attached database using Enterprise Manager. It was created new log file without any issue.
In my current company we have three log files in one database (I could not understand why they created 3 log files) Now one of the transaction log file is big. I did the same steps what I done before (rename all 3 log files), but I received the following error message.
Error 1813: Could not open new database. CREATE DATABASE is aborted.
Please find attached snap shot Transaction log setup and error message.
Is it possible can I make one log file instead of three log file?