Transaction Log

[ram]

I am trying to create a backup for the transaction logs on one
of the databases I support in SQL Server2000. The problem is in EM, the only
options it gives me are a Full DB Backup or a Differential DB
Backup. I have other DB's with TL backup's, why can't I on this
particular one? Truncate log on checkpoint option not found in properties.

Thanks
Ram

[jason]

what logging mode is your database in? sounds to me like you have select into/bulk copy option set, and if that is set you can't backup the t log;.


------------
ram at 5/9/01 11:29:01 AM

I am trying to create a backup for the transaction logs on one
of the databases I support in SQL Server2000. The problem is in EM, the only
options it gives me are a Full DB Backup or a Differential DB
Backup. I have other DB's with TL backup's, why can't I on this
particular one? Truncate log on checkpoint option not found in properties.

Thanks
Ram

[Ram]

select into/bulk copy option is not found in SQL server2000(Database properties).Windows 2000 autentecation.
Ram

------------
jason at 5/9/01 11:36:38 AM

what logging mode is your database in? sounds to me like you have select into/bulk copy option set, and if that is set you can't backup the t log;.


------------
ram at 5/9/01 11:29:01 AM

I am trying to create a backup for the transaction logs on one
of the databases I support in SQL Server2000. The problem is in EM, the only
options it gives me are a Full DB Backup or a Differential DB
Backup. I have other DB's with TL backup's, why can't I on this
particular one? Truncate log on checkpoint option not found in properties.

Thanks
Ram

[Mike John]

Almost certainly you are in simple recovery model this is the SQL 2000 equivalent of truncate log on checkpoint, therefore no tloag backups are possible

Mike John


------------
Ram at 5/9/01 11:58:08 AM


select into/bulk copy option is not found in SQL server2000(Database properties).Windows 2000 autentecation.
Ram

------------
jason at 5/9/01 11:36:38 AM

what logging mode is your database in? sounds to me like you have select into/bulk copy option set, and if that is set you can't backup the t log;.


------------
ram at 5/9/01 11:29:01 AM

I am trying to create a backup for the transaction logs on one
of the databases I support in SQL Server2000. The problem is in EM, the only
options it gives me are a Full DB Backup or a Differential DB
Backup. I have other DB's with TL backup's, why can't I on this
particular one? Truncate log on checkpoint option not found in properties.

Thanks
Ram

[ram]

Thank you mike jhon

------------
Mike John at 5/9/01 12:03:53 PM

Almost certainly you are in simple recovery model this is the SQL 2000 equivalent of truncate log on checkpoint, therefore no tloag backups are possible

Mike John


------------
Ram at 5/9/01 11:58:08 AM


select into/bulk copy option is not found in SQL server2000(Database properties).Windows 2000 autentecation.
Ram

------------
jason at 5/9/01 11:36:38 AM

what logging mode is your database in? sounds to me like you have select into/bulk copy option set, and if that is set you can't backup the t log;.


------------
ram at 5/9/01 11:29:01 AM

I am trying to create a backup for the transaction logs on one
of the databases I support in SQL Server2000. The problem is in EM, the only
options it gives me are a Full DB Backup or a Differential DB
Backup. I have other DB's with TL backup's, why can't I on this
particular one? Truncate log on checkpoint option not found in properties.

Thanks
Ram