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 i
s
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