July 4, 2008 at 3:55 am
I have created a two maintainance plan for backup in my server. One is of full backup and another is for differential backup.In both the maintainance plan have I have checked the create subfolder for each db.The full backup of around 10 database works fine. But the problem is with the differential backup. Out of 10 only 5 databases the differential backup works rest of them it does not and in the job history I get a error.I did a work around and created a separate differential maintainance plan pointing to different folder and selecting only 5 db which had problem then it works fine. Why is the problem with these differential backup for only 5 db when others works fine? All these databases are in simple recovery and same compatibility.The differential backup of db which works fine is done to the same folder where full backup is allready present and it is not creating any seperate folder.
July 4, 2008 at 4:06 am
It would help a lot if you would post the exact error you got before.
Without that it we are guessing.
[font="Verdana"]Markus Bohse[/font]
July 4, 2008 at 4:30 am
When I checked the log file viewer I get the following message.
1>Database differential changes were backed up. Database: Guardian, creation date(time): 2008/06/20(01:32:30), pages dumped: 395, first LSN: 55917:5325:1, last LSN: 55917:5327:1.
This message is present for all the database which it has done
successfully.
then the following message is
2>Error: 3041, Severity: 16, State: 1.
Followed by
3>BACKUP failed to complete the command BACKUP DATABASE master WITH DIFFERENTIAL. Check the backup application log for detailed messages.
Another thing I have noticed is once we open the backup plan and
edit any details except the backup path folder then the backup path folder by its own changes to the below mentioned path.
E:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup.
I want the backup to happen to a different folder to another drive.
Why this happens any wrong in the database server settings.
July 4, 2008 at 3:30 pm
you have to/can define a path when you write a differential plan.
Also if i am reading correct are you trying to create backps of the master DB?
Maninder
www.dbanation.com
July 4, 2008 at 8:57 pm
First I have defined the path for differential plan but If I edit any of the features in differential plan without altering the path the path automatically resets to the path I written before.So every time if there is any edit in differential plan then once again I have define the path exclusivly.
Yes I am creating the backup of master db.
July 5, 2008 at 1:25 am
In my differential backup plan I unchecked the Master db. Now the differential backup of all the databases is going as scheduled. I wonder what the master db has to do with the differential backup plan for not backing up the few databases.
July 6, 2008 at 2:23 am
You can take only Full backups of master database..but you can take differential backups of model and msdb databases..FYI
[font="Verdana"]- Deepak[/font]
July 6, 2008 at 11:27 am
What version is the server running, and what version are your client tools on? If you are not on at least 9.0.3054 for both - then you will have some issues working with maintenance plans.
There were quite a few fixes in SP2 - and a post-hot fix to fix some problems introduced in SP2 that can really cause some weird behavior.
Most of the time, I see this happening when the client tools have not been upgraded to at least the same version level of the server.
Jeffrey Williams
Problems are opportunities brilliantly disguised as insurmountable obstacles.
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply