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
Posted Tuesday, August 13, 2013 9:10 PM


Group: General Forum Members
Last Login: Saturday, February 01, 2014 5:00 PM
Points: 193, Visits: 621
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, January 29, 2014 12:46 PM
Points: 522, Visits: 229
I've few references for you:

SQL 2005/ 2008,

SQL 2012,,d.cWc

I hope this helps you out.
Post #1489469
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse