Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Backup - Filegroup and Transaction Log Option Disabled

Status
Not open for further replies.

gharabed

Programmer
Sep 7, 2001
251
US
I am wondering why the options for "File and filegroup" and "Transaction Log" backups are disabled within the backup database capability in Enterprise Manager for one of my databases. Why would I be prevented from doing a transaction log or file based backup of one of my databases?
 
Check the recovery model of the database. It the recovery model is simple you can not backup the transaction log.

right click on the db and select properties --> options.

- Paul
- Database performance looks fine, it must be the Network!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top