Hei,
Log file is growing very fast (Log file size is now more then 3GB and data
file size is not more then 1GB) and i want to shrink log file using this
command
use modbt
go
DBCC SHRINKFILE (modbt, 20)
go
OR
DBCC SHRINKFILE (modbt_Log, 20)
but getting error
Server: Msg 8985, Level 16, State 1, Line 1
Could not locate file 'modbt_log' in sysfiles.
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
I run sp_helpfile and get result
Name fileid Filename Filegroup Size Maxzie
growth usege
1 Axc_Data 1 D:\....\Modbt.mdf Primary 850688KB unlimited 10%
data
2 Axc_log 2 E:\....\Modbt.mdf Null 3575936KB unlimited
10% log
I run DBCC LOGINFO('modbt') and get STATUS '2' for 40 line but no one using
database that time. STATUS '0' for more then 300 line.
When i run DBCC SHRINKFILE (Axc_log, 20) then got
DbId Field CurrentSize MinimumSize Used Pages EstimatedPages
1: 7 2 446992 63 446992 56
Can any one help me what will be problem? I have backup plan full but i did
not check and it was not working so this happened with my database. Now it is
working please help me.
Nina PaulPaul
BACKUP LOG file and then DBCC SHRINKFILE command
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:9FBC8F5E-38B8-4115-8760-E7A334E62A06@.microsoft.com...
> Hei,
> Log file is growing very fast (Log file size is now more then 3GB and data
> file size is not more then 1GB) and i want to shrink log file using this
> command
> use modbt
> go
> DBCC SHRINKFILE (modbt, 20)
> go
> OR
> DBCC SHRINKFILE (modbt_Log, 20)
> but getting error
> Server: Msg 8985, Level 16, State 1, Line 1
> Could not locate file 'modbt_log' in sysfiles.
> DBCC execution completed. If DBCC printed error messages, contact your
> system administrator.
> I run sp_helpfile and get result
> Name fileid Filename Filegroup Size Maxzie
> growth usege
> 1 Axc_Data 1 D:\....\Modbt.mdf Primary 850688KB unlimited
> 10%
> data
> 2 Axc_log 2 E:\....\Modbt.mdf Null 3575936KB unlimited
> 10% log
> I run DBCC LOGINFO('modbt') and get STATUS '2' for 40 line but no one
> using
> database that time. STATUS '0' for more then 300 line.
> When i run DBCC SHRINKFILE (Axc_log, 20) then got
> DbId Field CurrentSize MinimumSize Used Pages
> EstimatedPages
> 1: 7 2 446992 63 446992
> 56
>
> Can any one help me what will be problem? I have backup plan full but i
> did
> not check and it was not working so this happened with my database. Now it
> is
> working please help me.
> Nina Paul
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment