September 4, 2009 at 8:02 am
Hello. I see a strange thing with one of our databases (SQL Server 2000).
When I do sp_helpdb it shows that this db has only one log file log01.ldf. But in the folder there is also log02.ldf that seems to be active. It is backed up when we run backup of this db, dbcc sqlperf(logspace) shows the total amount of log01 and log02. I also just in case checked other databases to see if it is attached to them but it isn't. Next week I will need to shrink log files and detach/reattach this db. I don't know if I need to add this log02 to attach script or not. Thank you in advance for your help.
September 4, 2009 at 8:55 am
I did some more queries in master.dbo.sysaltfiles and found this file there. how come it doesn't show up in db properties?
September 6, 2009 at 11:37 am
you are running which build of SQL ? SP4 or higher ?
September 7, 2009 at 7:09 pm
What do you see in output when you run the following query under the same database:
Select * From dbo.sysfiles
HTH!
MJ
September 8, 2009 at 7:47 am
Sql 2000, SP4
September 8, 2009 at 7:51 am
Hi, MJ.
When I run select * from sysfiles I see only one log file log01.
when I query sysaltfiles select * from master..sysaltfiles i see log02 file that belongs to this db.
Thank you,
LL
September 24, 2009 at 4:34 pm
Then you dont need that second log file for this database.
MJ
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply