Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
 Posted - 2011-01-05 : 00:05:51
|
| Dear All,I have created the maintenance plan to get the tran log back up for every 2 hours on production server.After 2 backup i have got with this errorMessageExecuted as user: SA\GANGA. ...ion 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 4:00:00 PM Progress: 2011-01-05 16:00:01.56 Source: {40FFB5DE-2F33-4DC2-9E9E-D9713BB79638} Executing query "DECLARE @Guid UNIQUEIDENTIFIER EXECUTE msdb..sp".: 100% complete End Progress Error: 2011-01-05 16:00:01.91 Code: 0xC002F210 Source: Tran log Back Up Database Task for TESTDB Execute SQL Task Description: Executing the query "BACKUP LOG [TESTDB ] TO DISK = N'E:\TESTDB \database\backup\TESTDB _backup_201101051600.trn' WITH NOFORMAT, NOINIT, NAME = N'TESTDB _backup_20110105160001', 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... The package execution fa... The step failed.Please help me to resolve this.Thanks,Gangadhara MSSQL Developer and DBA |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-01-05 : 00:26:04
|
| Until the first full backup is taken the datbase uses the simple recovery model and a tr log backup cannot be taken.What point would there be without a full backup - couldn't be restored anywhare.If you take a full backup it should work - but sounds like you don't have a restore strategy otherwise you would have a full backup to store with the logs so need to decide on that first.No need for log backups until that is done.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
Posted - 2011-01-05 : 01:36:44
|
| Hi,I have already taken the full back up and Differential back up in the Sub_pan 1 and Sub_plan2 and i have executed successfully.After this i have created sub_plan3 to have tran log backup which is failing with above error.Can u pls help me to resolve this pls.Thanks,Gangadhara MSSQL Developer and DBA |
|
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-01-05 : 01:40:01
|
| Are you sure?The error message says "BACKUP LOG cannot be performed because there is no current database backup."Is your full backup of TESTDB? Did it succeed?==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-01-05 : 02:51:44
|
| Since the last differential someone has either run BACKUP LOG ... WITH TRUNCATE_ONLY or has switched the database to simple recovery and back. Either of those will break the log chain and you'll need to take another full/diff backup--Gail ShawSQL Server MVP |
|
|
|
|
|
|
|
|
tran log backup failed