Clearing Transaction Log automatically...

I know this question has been asked before but I've found no answers that
seem to work.
I want to automatically clear my database transaction log to 10mb or so. My
current method is to detach the database. Rename the tlog file. Single file
attach the database. Then delete the tlog file.
I've tried DBCC SHRINKFILE (MYDB, 10) but this doesn't work. And I have
yet to get BACKUP LOG to work. Can someone offer any advise?
Thanks in advance for any help you can offer.What errors do you get when you try the backup log statement?
--
Ray Higdon MCSE, MCDBA, CCNA
--
"Mike" <mschultz@.doitsmarter.com> wrote in message
news:O1ZPqJtuDHA.2360@.TK2MSFTNGP10.phx.gbl...
> I know this question has been asked before but I've found no answers that
> seem to work.
> I want to automatically clear my database transaction log to 10mb or so.
My
> current method is to detach the database. Rename the tlog file. Single
file
> attach the database. Then delete the tlog file.
> I've tried DBCC SHRINKFILE (MYDB, 10) but this doesn't work. And I have
> yet to get BACKUP LOG to work. Can someone offer any advise?
> Thanks in advance for any help you can offer.
>
>|||1. To backup the log you must be in FUll recovery mode.
2. To backup the log you must have first backed up the entire database at
least once.
After backing up the log, then try shrinkfile..
"Mike" <mschultz@.doitsmarter.com> wrote in message
news:O1ZPqJtuDHA.2360@.TK2MSFTNGP10.phx.gbl...
> I know this question has been asked before but I've found no answers that
> seem to work.
> I want to automatically clear my database transaction log to 10mb or so.
My
> current method is to detach the database. Rename the tlog file. Single
file
> attach the database. Then delete the tlog file.
> I've tried DBCC SHRINKFILE (MYDB, 10) but this doesn't work. And I have
> yet to get BACKUP LOG to work. Can someone offer any advise?
> Thanks in advance for any help you can offer.
>
>|||Thank you for the suggestions. Will give them a shot.
Mike
"Wayne Snyder" <wsnyder@.computeredservices.com> wrote in message
news:e1FNUGzuDHA.1512@.TK2MSFTNGP10.phx.gbl...
> 1. To backup the log you must be in FUll recovery mode.
> 2. To backup the log you must have first backed up the entire database at
> least once.
> After backing up the log, then try shrinkfile..
> "Mike" <mschultz@.doitsmarter.com> wrote in message
> news:O1ZPqJtuDHA.2360@.TK2MSFTNGP10.phx.gbl...
> > I know this question has been asked before but I've found no answers
that
> > seem to work.
> >
> > I want to automatically clear my database transaction log to 10mb or
so.
> My
> > current method is to detach the database. Rename the tlog file. Single
> file
> > attach the database. Then delete the tlog file.
> >
> > I've tried DBCC SHRINKFILE (MYDB, 10) but this doesn't work. And I
have
> > yet to get BACKUP LOG to work. Can someone offer any advise?
> >
> > Thanks in advance for any help you can offer.
> >
> >
> >
>