|
Home > Archive > SQL server exams > November 2002 > Transaction Log backup problem
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Transaction Log backup problem
|
|
| getmycerts 2002-11-22, 12:14 pm |
| I can backup the database without a problem, but when I try to back the transaction log in Database Maintenace Plans i get this error in the history "Backup can not be performed on this database. The sub task is ignored". any help is greatly appreciated. | |
| mevdhulst 2002-11-26, 1:08 pm |
| What kind of recovery model does your database use? u cannot perform a backup on a transaction log on a database that is using the simply recovery model. If you are backing up the master database it only allows a full database backup.
perhaps this is of any help
gtz Mark | |
| necrophantasm 2002-11-27, 11:41 am |
| Right click the database, go to properties, go to options, If the recovery model is "simple" change it to "full". If the "auto shrink" option is check off, uncheck it. Both of these options will cause you to not be able to backup the transaction log. Change them both, then go back to backup (or your database maintenance plan) and give it a try again. |
|
|
|
|