August 17, 2012 at 10:01 pm
Hi,
I restored database to SQL 2008 from backup file SQL server 2008. after that executed database maintenance such as DBCC commands. but database integrity command successfully not completed, due to below errors;
ODBC error: (42000) - [Microsoft][ODBC SQL Server Driver][SQL Server]The log file for database '<database>' is full. Back up the transaction log for the database to free up some log space .
First time not possible take Tlog backup, once taken Full backup after that can able to take Tlog backup.
Is it possible take Tlog backup first time without taken full backup?
How to fix it? or can restore SQL 2000 MSDB at new version SQL 2008?
thanks
August 18, 2012 at 1:26 am
First you have to take a Full backup and then You can take Log backups
Pooyan
August 18, 2012 at 2:13 am
ok do this,:
1) just expand the log file by a little, this will prevent the error during full backup.
2) Then perform Full backup.
3) and Then perform log backup.
In a worst case scenario and at the cost of losing point in time recovery option change the database recovery model to Simple to empty the transaction log ( as log as you do not have a large open transaction)
August 18, 2012 at 2:13 am
Please read through this: http://qa.sqlservercentral.com/articles/Transaction+Log/72488/
It's not necessarily a log backup that it needs. So first thing is to identify why the log is full.
That said, since the DB was moved from 2000 to 2008 via backup/restore, it's had a full backup (moving versions doesn't break the log chain) and may well need a log backup.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply