Backup Transaction Log

We are running SQL Server 2000, SP 3. We want to backup the Transaction log
by backup to a backup device. However, the transaction log is greyed out.
What are we doing wrong?
Thanks.Have you done a full database backup yet? You cannot backup the log until
you have backed up the database. A restore operation always starts by
restoring the full database, and then applying each of the log backups. If
you don't have a full db backup, the log backups can't be used for anything.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Jill Johnson" <jjohnson362000@.yahoo.com> wrote in message
news:u6MXhIfZDHA.2668@.TK2MSFTNGP09.phx.gbl...
> We are running SQL Server 2000, SP 3. We want to backup the Transaction
log
> by backup to a backup device. However, the transaction log is greyed out.
> What are we doing wrong?
> Thanks.
>|||Thank you for your quick response, Kalen.
I backup each database (master, msdb, etc.) to each backup device. Then, I
back up those files to a tape drive. Do you consider that I have a full
database backup? I don't know what I am doing.
Thanks.
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:e1tG1MfZDHA.388@.TK2MSFTNGP10.phx.gbl...
> Have you done a full database backup yet? You cannot backup the log until
> you have backed up the database. A restore operation always starts by
> restoring the full database, and then applying each of the log backups. If
> you don't have a full db backup, the log backups can't be used for
anything.
> --
> HTH
> --
> Kalen Delaney
> SQL Server MVP
> www.SolidQualityLearning.com
>
> "Jill Johnson" <jjohnson362000@.yahoo.com> wrote in message
> news:u6MXhIfZDHA.2668@.TK2MSFTNGP09.phx.gbl...
> > We are running SQL Server 2000, SP 3. We want to backup the Transaction
> log
> > by backup to a backup device. However, the transaction log is greyed
out.
> > What are we doing wrong?
> >
> > Thanks.
> >
> >
>|||What is the recovery model of your database(s).
If 'simple' you don't have this option
>--Original Message--
>Thank you for your quick response, Kalen.
>I backup each database (master, msdb, etc.) to each
backup device. Then, I
>back up those files to a tape drive. Do you consider
that I have a full
>database backup? I don't know what I am doing.
>Thanks.
>"Kalen Delaney" <replies@.public_newsgroups.com> wrote in
message
>news:e1tG1MfZDHA.388@.TK2MSFTNGP10.phx.gbl...
>> Have you done a full database backup yet? You cannot
backup the log until
>> you have backed up the database. A restore operation
always starts by
>> restoring the full database, and then applying each of
the log backups. If
>> you don't have a full db backup, the log backups can't
be used for
>anything.
>> --
>> HTH
>> --
>> Kalen Delaney
>> SQL Server MVP
>> www.SolidQualityLearning.com
>>
>> "Jill Johnson" <jjohnson362000@.yahoo.com> wrote in
message
>> news:u6MXhIfZDHA.2668@.TK2MSFTNGP09.phx.gbl...
>> > We are running SQL Server 2000, SP 3. We want to
backup the Transaction
>> log
>> > by backup to a backup device. However, the
transaction log is greyed
>out.
>> > What are we doing wrong?
>> >
>> > Thanks.
>> >
>> >
>>
>
>.
>|||I don't know what my recovery model of my database(s). What are my
options?
Please explain to me that my thinking of recovery method is wrong. If I
need to do a recovery, first, I need to restore the file from the tape.
Then, I open the Enterprise Manager and select Restore.
Thanks.
"Rohan pitiya" <rpitiyar@.hotmail.com> wrote in message
news:091f01c365f7$a6074e50$a101280a@.phx.gbl...
> What is the recovery model of your database(s).
> If 'simple' you don't have this option
>
> >--Original Message--
> >Thank you for your quick response, Kalen.
> >
> >I backup each database (master, msdb, etc.) to each
> backup device. Then, I
> >back up those files to a tape drive. Do you consider
> that I have a full
> >database backup? I don't know what I am doing.
> >
> >Thanks.
> >
> >"Kalen Delaney" <replies@.public_newsgroups.com> wrote in
> message
> >news:e1tG1MfZDHA.388@.TK2MSFTNGP10.phx.gbl...
> >> Have you done a full database backup yet? You cannot
> backup the log until
> >> you have backed up the database. A restore operation
> always starts by
> >> restoring the full database, and then applying each of
> the log backups. If
> >> you don't have a full db backup, the log backups can't
> be used for
> >anything.
> >>
> >> --
> >> HTH
> >> --
> >> Kalen Delaney
> >> SQL Server MVP
> >> www.SolidQualityLearning.com
> >>
> >>
> >> "Jill Johnson" <jjohnson362000@.yahoo.com> wrote in
> message
> >> news:u6MXhIfZDHA.2668@.TK2MSFTNGP09.phx.gbl...
> >> > We are running SQL Server 2000, SP 3. We want to
> backup the Transaction
> >> log
> >> > by backup to a backup device. However, the
> transaction log is greyed
> >out.
> >> > What are we doing wrong?
> >> >
> >> > Thanks.
> >> >
> >> >
> >>
> >>
> >
> >
> >.
> >|||The other possibility is that your database is in SIMPLE recovery mode. In
that case, the log is automatically truncated at regular intervals, so there
will be nothing left to back up. Check the database property sheet in
Enterprise Manager.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Jill Johnson" <jjohnson362000@.yahoo.com> wrote in message
news:eSfnKRfZDHA.2932@.tk2msftngp13.phx.gbl...
> Thank you for your quick response, Kalen.
> I backup each database (master, msdb, etc.) to each backup device. Then,
I
> back up those files to a tape drive. Do you consider that I have a full
> database backup? I don't know what I am doing.
> Thanks.
> "Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
> news:e1tG1MfZDHA.388@.TK2MSFTNGP10.phx.gbl...
> > Have you done a full database backup yet? You cannot backup the log
until
> > you have backed up the database. A restore operation always starts by
> > restoring the full database, and then applying each of the log backups.
If
> > you don't have a full db backup, the log backups can't be used for
> anything.
> >
> > --
> > HTH
> > --
> > Kalen Delaney
> > SQL Server MVP
> > www.SolidQualityLearning.com
> >
> >
> > "Jill Johnson" <jjohnson362000@.yahoo.com> wrote in message
> > news:u6MXhIfZDHA.2668@.TK2MSFTNGP09.phx.gbl...
> > > We are running SQL Server 2000, SP 3. We want to backup the
Transaction
> > log
> > > by backup to a backup device. However, the transaction log is greyed
> out.
> > > What are we doing wrong?
> > >
> > > Thanks.
> > >
> > >
> >
> >
>|||Every database is set to one of three recovery models which affects how much
information is logged and how the transaction log is handled.
Please open up Books Online from your SQL Server Program Group and read
about Recovery Models before you start planning your backup and restore
strategy. There is also a lot of information in the Books Online about
backup and restore.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Jill Johnson" <jjohnson362000@.yahoo.com> wrote in message
news:e$MRbNgZDHA.2580@.TK2MSFTNGP09.phx.gbl...
> I don't know what my recovery model of my database(s). What are my
> options?
> Please explain to me that my thinking of recovery method is wrong. If I
> need to do a recovery, first, I need to restore the file from the tape.
> Then, I open the Enterprise Manager and select Restore.
> Thanks.
> "Rohan pitiya" <rpitiyar@.hotmail.com> wrote in message
> news:091f01c365f7$a6074e50$a101280a@.phx.gbl...
> > What is the recovery model of your database(s).
> > If 'simple' you don't have this option
> >
> >
> > >--Original Message--
> > >Thank you for your quick response, Kalen.
> > >
> > >I backup each database (master, msdb, etc.) to each
> > backup device. Then, I
> > >back up those files to a tape drive. Do you consider
> > that I have a full
> > >database backup? I don't know what I am doing.
> > >
> > >Thanks.
> > >
> > >"Kalen Delaney" <replies@.public_newsgroups.com> wrote in
> > message
> > >news:e1tG1MfZDHA.388@.TK2MSFTNGP10.phx.gbl...
> > >> Have you done a full database backup yet? You cannot
> > backup the log until
> > >> you have backed up the database. A restore operation
> > always starts by
> > >> restoring the full database, and then applying each of
> > the log backups. If
> > >> you don't have a full db backup, the log backups can't
> > be used for
> > >anything.
> > >>
> > >> --
> > >> HTH
> > >> --
> > >> Kalen Delaney
> > >> SQL Server MVP
> > >> www.SolidQualityLearning.com
> > >>
> > >>
> > >> "Jill Johnson" <jjohnson362000@.yahoo.com> wrote in
> > message
> > >> news:u6MXhIfZDHA.2668@.TK2MSFTNGP09.phx.gbl...
> > >> > We are running SQL Server 2000, SP 3. We want to
> > backup the Transaction
> > >> log
> > >> > by backup to a backup device. However, the
> > transaction log is greyed
> > >out.
> > >> > What are we doing wrong?
> > >> >
> > >> > Thanks.
> > >> >
> > >> >
> > >>
> > >>
> > >
> > >
> > >.
> > >
>