November 8, 2010 at 3:38 pm
Hi,
I created a plan for sql2008 db backup. which has 3 sub plans.
1. Full backup 9:00am every day, ends 8:59:59am
2.Diff backup starts 10:00am, ends 8:59:59am ---for enery one hour
3.TLog backup starts 9:05am ends 8:59:59am ---for enery 5 min.
problem: i getting email message about diffrential backup fail at 10:00pm, comming every hour
until 8:00am.
then for 9:00am full backup is successfull, and other backups sucessfull until 10:00pm
but exactly at 10:00pm my differential backup is failed, until 8:00am it continuous to fail
Is there any suggestions please.
Thank you
November 8, 2010 at 4:29 pm
Keep in mind you posted in a SQL2005 forum. Maybe ask SSC to shift it to a SQL2008 one.
- please post the actual backup error message (check your sqlserver logs)
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
November 8, 2010 at 4:39 pm
Hi, Thank you for replying.
i can see this message
Date9/11/2010 8:00:04 AM
LogWindows NT (Application)
SourceSQLAgent$SQLDEV2008
CategoryJob Engine
Event1073742032
ComputerFS-DEV
Message
SQL Server Scheduled Job 'New_kvr-backup.Differntial backup sub-plan' (0x0607E1EC7CE6B24F958DD1DBE7026090) - Status: Failed - Invoked on: 2010-11-09 08:00:00 - Message: The job failed. The Job was invoked by Schedule 16 (New_kvr-backup.Differntial backup sub-plan). The last step to run was step 1 (Differntial backup sub-plan).
Is this helpful to you.
November 8, 2010 at 5:43 pm
No, the message only states something is wrong.... which we already knew 😉
Can you check the maintenance plan log, or enable it ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
November 8, 2010 at 6:00 pm
This is from JOB History
Date9/11/2010 8:00:01 AM
LogJob History (New_kvr-backup.Differntial backup sub-plan)
Step ID1
ServerFS-DEV\SQLDEV2008
Job NameNew_kvr-backup.Differntial backup sub-plan
Step NameDifferntial backup sub-plan
Duration00:00:03
Sql Severity0
Sql Message ID0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted0
Message
Executed as user: NT AUTHORITY\NETWORK SERVICE. Microsoft (R) SQL Server Execute Package Utility Version 10.0.2531.0 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 8:00:01 AM Progress: 2010-11-09 08:00:02.21 Source: {A65FA7C7-437B-429A-8657-6212352FAC2C} Executing query "DECLARE @GUID UNIQUEIDENTIFIER EXECUTE msdb..sp...".: 100% complete End Progress Progress: 2010-11-09 08:00:02.88 Source: Back Up Database Task Executing query "EXECUTE master.dbo.xp_create_subdir N'E:\Database ...".: 100% complete End Progress Error: 2010-11-09 08:00:02.97 Code: 0xC002F210 Source: Back Up Database Task Execute SQL Task Description: Executing the query "BACKUP DATABASE [New_kvr] TO DISK = N'E:\Database..." failed with the following error: "Cannot perform a differential backup for database "New_kvr", because a current database backup does not exist. Perform a full database backup by reissuing BACKUP DATABASE, omitting the WITH DIFFERENTIAL option. BACKUP DATABASE is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 8:00:01 AM Finished: 8:00:03 AM Elapsed: 1.969 seconds. The package execution failed. The step failed.
Is there any problems that set start time and end time with backups?
i gave the details about how i set full, diff, lob backup timings.
Thank you.
November 8, 2010 at 6:10 pm
The part of that which matters:
Error: 2010-11-09 08:00:02.97 Code: 0xC002F210 Source: Back Up Database Task Execute SQL Task Description: Executing the query "BACKUP DATABASE [New_kvr] TO DISK = N'E:\Database..." failed with the following error: "Cannot perform a differential backup for database "New_kvr", because a current database backup does not exist. Perform a full database backup by reissuing BACKUP DATABASE, omitting the WITH DIFFERENTIAL option. BACKUP DATABASE is terminating abnormally."
Is something moving your backups offline at a certain time, or making the remote drive the backups sit on un-accessible at that time?
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 8, 2010 at 6:21 pm
Hi Craig, thank you for replying.
Sorry I really dont understand taht. my transaction log bacups are sucessfull without any interuption every 5 min, 24 hours. Only problem with diffretial backups. they are failing at 10:00pm first, and every hour until morning 8:00am, once the full backup -sub plan excecuted at 9:00am today, the diff backup at 10:00 am running succesfully. and it is successfull until 9:00pm and fails at 10:00 pm.
any thing is going wrong here?
Thank you.
November 8, 2010 at 6:32 pm
Find the drive your main backups are going to on the network, then contact your sysadmins and ask them to see if there's maintenance on those drives at that time.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 8, 2010 at 6:36 pm
Thanks Craig.
November 8, 2010 at 9:02 pm
I would also double check if there is no concurrent full database backup running at the same time. Although the errormsg doesn't state it explicitly ... I would just check it aniways.:Whistling:
Double check your full db backup plan to see you included the same dbs as you are trying to with the diff backup plan.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
November 8, 2010 at 10:09 pm
Just to be sure, only the hourly differential backups are failing; the t-log backups are still running as scheduled when the differential backups fail.
November 8, 2010 at 11:51 pm
Hi Lynn,
Yes while diff backups are faling, Tlog bacup plan is executing.
November 8, 2010 at 11:55 pm
Currently i couldn't see any kind of backup for this databse. Icreated this db recently and createda plan to take all kind of backups for this single db.
Thank you for replying.
November 9, 2010 at 5:12 am
This issue is mainly due to Differential backup does not recognize existence of full backup
Go thru the support article..
http://support.microsoft.com/kb/921106
Thanks
Ram
November 9, 2010 at 8:43 am
The kb addresses sql2005 having this issue.
OP stated his server is sql2008.
But it is indeed a good hint on posting the @@version info of this instance.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 15 posts - 1 through 14 (of 14 total)
You must be logged in to reply to this topic. Login to reply