Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

delete the extra log file in a database in 2012 Expand / Collapse
Author
Message
Posted Tuesday, August 13, 2013 9:10 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, September 14, 2014 1:28 AM
Points: 219, Visits: 693
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.
Post #1484058
Posted Wednesday, August 28, 2013 5:15 PM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, September 24, 2014 11:34 AM
Points: 522, Visits: 235
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.
Post #1489469
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse