June 21, 2011 at 9:06 am
did you check if a disk/tape backup product is using volume shadow copy to backup your databases while online ?
often this is called "backup open files" in backup software.
using the sql writer service (which is put on automatic with sp2) applications outside of sql server can backup up your database files while sql server is live and active on those files. sql writer service is a volume shadow copy agent to facilitate this.
if you dont know you can test this by putting the sql writer file on disabled and stop the service. if you dont have the message anymore then you have a clue where to look further.
be aware that this may influence backup scenarios in place you may not be aware off.
July 8, 2011 at 12:51 am
Hi ...
As suggested, I have changed recovery model to simple but still the problem exists whenever I take Diff backup. its giving same error as below ...
Msg 3035, Level 16, State 1, Line 1
Cannot perform a differential backup for database "ABC", because a current database backup does not exist. Perform a full database backup by reissuing BACKUP DATABASE, omitting the WITH DIFFERENTIAL option.
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.
can you pls suggest what and where to check which is causing this issue.
Thanks in advance.
-Shashi Bhushan.
July 8, 2011 at 3:32 am
Can you post me the results.
select create_date,name from sys.databases where name='abc'
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
July 8, 2011 at 6:08 am
sounds to me like someone or something is possibly restoring the database
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 8, 2011 at 7:29 am
By chance is there a third party application running a backup that you are not aware of - something like Tivoli or Symantec (both with SQL snap-in).
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
July 8, 2011 at 11:24 am
polasabhushan (7/8/2011)
Msg 3035, Level 16, State 1, Line 1Cannot perform a differential backup for database "ABC", because a current database backup does not exist. Perform a full database backup by reissuing BACKUP DATABASE, omitting the WITH DIFFERENTIAL option.
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.
Try performing a FULL backup. Then a differential. See what happens.
July 8, 2011 at 2:12 pm
There are only a few processes that will break the differential backup chain. This has nothing to do with the log chain at all - specifically, this is some process that causes SQL Server to clear the backup chain which prevents further differential backups from being taken.
The two that I know of are:
1) NTBackup - see this article: http://support.microsoft.com/kb/903643
2) Volume Shadow Copy Service: http://technet.microsoft.com/en-us/library/cc785914(WS.10).aspx
If you do not have something like NTBackup running and performing additional backups, then you most likely have the volume shadow copy service enabled which is causing the problem.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 7 posts - 16 through 22 (of 22 total)
You must be logged in to reply to this topic. Login to reply