I cant back up my log files

When I go into EM and choose backup, the option for
transaction logs are greyed out.
Does anyone know how to active this? Also what effect
would this change have on my DB's?
Thank you,
JoeLooks like your database is in 'Simple' recovery mode. You could verify this
in the Options tab of the 'Database Properties' dialog box in Enterprise
Manager.
If it is not in 'Simple' recovery mode, have you ever performed a full
database backup on this database?
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm
"JOE" <anonymous@.discussions.microsoft.com> wrote in message
news:086101c397f9$f6af99a0$a001280a@.phx.gbl...
When I go into EM and choose backup, the option for
transaction logs are greyed out.
Does anyone know how to active this? Also what effect
would this change have on my DB's?
Thank you,
Joe|||Should I change it to full?
Thanks,
Joe|||Yes, if you want to be able to backup transaction logs and perform
point-in-time restores. Do read up on recovery models in SQL Server Books
Online.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm
"JOE" <anonymous@.discussions.microsoft.com> wrote in message
news:088501c397fc$0a8336b0$a001280a@.phx.gbl...
Should I change it to full?
Thanks,
Joe|||If you need up to the minute recovery, and intend to back up the log files,
you must change to full recovery mode... Using simple recovery, SQL will
truncate the log files during each checkpoint, and you will not be able to
back up the log files.
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"JOE" <anonymous@.discussions.microsoft.com> wrote in message
news:088501c397fc$0a8336b0$a001280a@.phx.gbl...
> Should I change it to full?
> Thanks,
> Joe