Transaction Log backup help please. 
Author Message
 Transaction Log backup help please.
On one of my databases when I go to backup the transaction log that
option along with the filegroup option is greyed out.
I can only do a full or differential backup.
I did not create this one, it was there when I took over as Admin.
My other databases are fine though.
What would cause this problem?

Thanks,
Erick



Sun, 09 Nov 2003 03:36:59 GMT
 Transaction Log backup help please.

Right-click in the database in question and go to properties.  Go to Options
and clear the check from TRUNCATE LOG ON CHECKPOINT.


Quote:
> On one of my databases when I go to backup the transaction log that
> option along with the filegroup option is greyed out.
> I can only do a full or differential backup.
> I did not create this one, it was there when I took over as Admin.
> My other databases are fine though.
> What would cause this problem?

> Thanks,
> Erick



Sun, 09 Nov 2003 03:49:39 GMT
 Transaction Log backup help please.
Do you have the "truncate log on checkpoint" set to true on this database?


Quote:
> On one of my databases when I go to backup the transaction log that
> option along with the filegroup option is greyed out.
> I can only do a full or differential backup.
> I did not create this one, it was there when I took over as Admin.
> My other databases are fine though.
> What would cause this problem?

> Thanks,
> Erick



Sun, 09 Nov 2003 03:49:45 GMT
 Transaction Log backup help please.
SQL2000?

Check the properties of the DB, options tab...recovery model, if 'simple', change
to full.

hth

Quote:
-----Original Message-----

On one of my databases when I go to backup the transaction log that
option along with the filegroup option is greyed out.
I can only do a full or differential backup.
I did not create this one, it was there when I took over as Admin.
My other databases are fine though.
What would cause this problem?

Thanks,
Erick

.



Sun, 09 Nov 2003 03:59:52 GMT
 Transaction Log backup help please.
Thanks for all yor help.
That was it. The truncate option was set to true.

Erick

Quote:

> SQL2000?

> Check the properties of the DB, options tab...recovery model, if 'simple', change
> to full.

> hth

> -----Original Message-----
> On one of my databases when I go to backup the transaction log that
> option along with the filegroup option is greyed out.
> I can only do a full or differential backup.
> I did not create this one, it was there when I took over as Admin.
> My other databases are fine though.
> What would cause this problem?

> Thanks,
> Erick

> .



Sun, 09 Nov 2003 04:11:40 GMT
 
 [ 5 post ] 

 Relevant Pages 

1. Applying Transaction Log Backups, Help please !!

2. Please help...Backup vs Transaction log vs Restore is so important

3. Please help...Backup vs Transaction log vs Restore is so important

4. Transaction Log backup Error. Please help

5. Help needed !Locking transaction log backup process

6. Need Help with Backup - Transaction logs - Newbie

7. transaction log backup failure HELP!

8. Backup from filegroup without transaction log backups

9. Full backups and transaction log backups

10. diffrential backup and transaction log backup

11. SQL DB Backup - transaction log backup?

12. Question about Transaction log backup with Backup Exec


 
Powered by phpBB® Forum Software