November 20, 2007 at 10:16 am
DB backup works, no issues - cleanup plans work fine,
I am not doing any truncates to the trans log - and I have verified full db backups exist. (Full recovery mode)
Receiving the following error:
**********************
Executing the query "BACKUP LOG [my_dbase] TO DISK = N'E:\\MSSQL.1\\MSSQL\\Backup\\my_dbase\\my_dbase_backup_200711200800.trn' WITH NOFORMAT, NOINIT, NAME = N'my_dbase_backup_20071120080001', SKIP, REWIND, NOUNLOAD, STATS = 10
" failed with the following error: "BACKUP LOG cannot be performed because there is no current database backup.
BACKUP LOG is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
**********************
I have read through as many posts as I can (without losing my eyesight) and I have found some information that has helped me tweak my application, nothing seems to resolve this.
I also referenced Microsoft article 873235 on trans log behavior. In addition I reviewed the information provided in the following link: http://www.sql-server-performance.com/articles/dba/creating_backup_jobs_p1.aspx
Service pack 1
Thanks in advance, any assistance is appreciated.
BK
November 21, 2007 at 10:43 am
bk
Was the database recently renamed, dropped and recreated?
Error Log should contain an entry of a full database backup like this:
Date11/19/2007 3:00:30 AM
LogSQL Server (Current - 11/21/2007 11:17:00 AM)
SourceBackup
Message
Database backed up. Database: your_db, creation date(time): 2007/07/03(13:15:03), pages dumped: 70718, first LSN: 17568:146990:37, last LSN: 17568:147006:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {C:\your_backup_path\your_db200711190300.bak'}). This is an informational message only. No user action is required.
refer to this kb article for further investigation
http://support.microsoft.com/kb/928317
November 30, 2007 at 9:31 am
Very strange. If you manually run a full backup and then a log backup immediately afterwards, does that work?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply