Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problem with maintenance plan
Message
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Maintenance bases de données
Titre:
Problem with maintenance plan
Divers
Thread ID:
00895627
Message ID:
00895627
Vues:
45
I am pretty sure that I have an issue with my maintenance plan. When the transaction log backup job is started it does not seem to stop. I used the database mainentnace place wizard to create the plan and all seemed to go well. Then we had to double the size of the table through a series of mass imports. This caused the drive with the transaction log to become to full. After resolving that issue (in process of getting new server) I had to point the backup jobs to an external HD for storage. Now three of the four parts of the plan work just fine, however, when the tlog portion starts it never seems to end even though there is no activity on the server or the external HD. Also, when I checked the drive I found the .trn file was actually there and was 13Gb in size, the size of the tlog file is only 600Mb in size. What could be going on here?

Thanks in advance
Kelly
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform