File of LOG

Somebody knows as removing the log file, because the same this occupying a
space.Frank,
Are you talking about transaction log, .ldf file?
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Frank Dulk" <fdulk@.bol.com.br> wrote in message
news:O2ThWl$aDHA.2476@.tk2msftngp13.phx.gbl...
>
>
> Somebody knows as removing the log file, because the same this occupying a
> space.
>|||Yes, because the same already this with 700M
"Dinesh.T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
news:um3qcr$aDHA.2436@.TK2MSFTNGP12.phx.gbl...
> Frank,
> Are you talking about transaction log, .ldf file?
> --
> Dinesh.
> SQL Server FAQ at
> http://www.tkdinesh.com
> "Frank Dulk" <fdulk@.bol.com.br> wrote in message
> news:O2ThWl$aDHA.2476@.tk2msftngp13.phx.gbl...
> >
> >
> >
> >
> >
> > Somebody knows as removing the log file, because the same this occupying
a
> > space.
> >
> >
>|||Frank,
You shouldnt remove the transaction log file.Instead take measures to
control its growth. There is no automatic shrinking inbuilt unless you
specify.If you care about log backups, then schedule a sql job which will
take log backups at regular intervals.If you dont care, then check the
option "truncate log on checkpoint" on database properties(sql7), "simple"
recovery model(sql2000) and BACKUP LOG <databasename> WITH TRUNCATE_ONLY
.These actions would only truncate ( or empty ) the log so that no further
space is extracted unless needed.In order to shrink (or reduce the physical
size of the file ), refer:
--SQL7
INF: How to Shrink the SQL Server 7.0 Transaction Log
http://support.microsoft.com/support/kb/Articles/q256/6/50.asp
and/or
www.sqlserverfaq.com and search for "sql7shrinklognowork.txt"
--SQL2000
INF: Shrinking the Transaction Log in SQL Server 2000 with DBCC SHRINKFILE
http://support.microsoft.com/support/kb/Articles/q272/3/18.asp
In case the log doesnt shrink even after DBCC SHRINKFILE, then do a
combination of...
Back up the Database (BACKUP DATABASE dbname...)
Back up the log (BACKUP LOG dbname...)
Truncate the log (BACKUP LOG dbname WITH TRUNCATE_ONLY)
Shrink the file (DBCC SHRINKFILE...)
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Frank Dulk" <fdulk@.bol.com.br> wrote in message
news:%23mg$wQKbDHA.2368@.TK2MSFTNGP09.phx.gbl...
> Yes, because the same already this with 700M
> "Dinesh.T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
> news:um3qcr$aDHA.2436@.TK2MSFTNGP12.phx.gbl...
> > Frank,
> >
> > Are you talking about transaction log, .ldf file?
> >
> > --
> > Dinesh.
> > SQL Server FAQ at
> > http://www.tkdinesh.com
> >
> > "Frank Dulk" <fdulk@.bol.com.br> wrote in message
> > news:O2ThWl$aDHA.2476@.tk2msftngp13.phx.gbl...
> > >
> > >
> > >
> > >
> > >
> > > Somebody knows as removing the log file, because the same this
occupying
> a
> > > space.
> > >
> > >
> >
> >
>