cancel
Showing results for 
Search instead for 
Did you mean: 

SQL Server backing up with exceptions

BElearner
Level 4

I am backing up a Microsoft SQL Server instances that's running on Hyper V. The backups were running fine till couple of days back, but for some reason it is backing up with exceptions. 

1 ACCEPTED SOLUTION

Accepted Solutions

pkh
Moderator
Moderator
   VIP    Certified

You should exclude these databases from this SQL backup job and set up another job which only backs up these databases, but without log backups.

View solution in original post

4 REPLIES 4

pkh
Moderator
Moderator
   VIP    Certified

You got to post the error messages.

BElearner
Level 4

 

exception_0.JPG

pkh
Moderator
Moderator
   VIP    Certified

You should exclude these databases from this SQL backup job and set up another job which only backs up these databases, but without log backups.

VJware
Level 6
Employee Accredited Certified

Separate your SQL backups in such a manner:-

1) Full backup and Log backup of SQL DBs which have the recovery model as Full / Bulk-Logged

2) Only Full backup of SQL DBs which have the recovery model as Simple.