why are 'transaction log' and 'file and file group' dimmed (not available)
on the general tab of the backup window? (right-click on database, all
tasks, backup database)
I am backing up to a file device and need to set a schedule of 1 daily full
backup and backup of the transaction logs every 1/2 hour.
any help is appreciated.Because the database is in simple recovery mode.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"djc" <noone@.nowhere.com> wrote in message news:ucbsl59UEHA.3420@.TK2MSFTNGP12.phx.gbl...
> why are 'transaction log' and 'file and file group' dimmed (not available)
> on the general tab of the backup window? (right-click on database, all
> tasks, backup database)
> I am backing up to a file device and need to set a schedule of 1 daily full
> backup and backup of the transaction logs every 1/2 hour.
> any help is appreciated.
>|||Thank you!
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uWjcUB%23UEHA.1048@.tk2msftngp13.phx.gbl...
> Because the database is in simple recovery mode.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "djc" <noone@.nowhere.com> wrote in message
news:ucbsl59UEHA.3420@.TK2MSFTNGP12.phx.gbl...
> > why are 'transaction log' and 'file and file group' dimmed (not
available)
> > on the general tab of the backup window? (right-click on database, all
> > tasks, backup database)
> >
> > I am backing up to a file device and need to set a schedule of 1 daily
full
> > backup and backup of the transaction logs every 1/2 hour.
> >
> > any help is appreciated.
> >
> >
>
No comments:
Post a Comment