March 29, 2006 at 3:45 am
Hello,
I migrated some db from SQL2000 to SQL2005. I'll created a maintenance plan to backup the transaction log each hour. The db name with an underscore give a problem. I tried also with a new db, same result. Without underscore in the db name, no problem.
A manual backup give also no problem.
Executing the query "BACKUP LOG [sdsd_ds] TO DISK = N'n:\\MSSQL\\Backup\\sdsd_ds\\sdsd_ds_backup_200603291217.trn' WITH NOFORMAT, NOINIT, NAME = N'sdsd_ds_backup_20060329121757', 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.
Thanks you
March 29, 2006 at 4:52 am
Try taking the full database backup and then see if this works.
backup log <dbname> with no_log
March 29, 2006 at 6:02 am
It's resolved. I deleted all maintenance plan and recreate it in local on the server. The first I created in remote.
Thanks
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply