delete the extra log file in a database in 2012

• Mac1986

  SSCertifiable

  Points: 6216

  More actions

  August 13, 2013 at 9:10 pm

  #144632

  hi ,

  I have database where i have 2 log files. I would like to delete one of the log file which is empty.

  when i'm trying to remove the log file using the GUID, i get the error that

  Could not locate file '18' for database Mydatabase in sys.database_files. The file either does not exist, or was dropped.

  then i saw that the LDF is OFFLINE. how can i trouble shoot more to get the file online.

• Snigdha Vartak

  Default port

  Points: 1486

  More actions

  August 28, 2013 at 5:15 pm

  #1645785

  I've few references for you:

  SQL 2005/ 2008,

  http://saveadba.blogspot.com/2012/02/remove-data-log-file.html

  SQL 2012,

  http://technet.microsoft.com/en-us/library/ms175574.aspx

  http://www.google.com/url?sa=t&rct=j&q=&esrc=s&frm=1&source=web&cd=3&cad=rja&ved=0CDcQFjAC&url=http%3A%2F%2Fsqlserverzest.com%2F2013%2F05%2F06%2Fhow-to-remove-extra-tempdb-data-files-and-log-files%2F&ei=ZIMeUv_GIeivsASw-IHQDQ&usg=AFQjCNG_enFBkxlzNed4WnQodJp8M8DUjA&sig2=R21ce0etPtxd0Sj8WQJKjw&bvm=bv.51156542,d.cWc

  I hope this helps you out.