Thank you all guys!

Sorry guys another question. What is the benefit to append backups to one file? If I do full backup/diff backup/log backup every day, why I need to append files?

Thanks

Are you initializing the backup file each time, or is the backup file stacking? Try running RESTORE HEADERONLY to see if you're putting multiple backups into a single...

Are you initializing the backup file each time, or is the backup file stacking? Try running RESTORE HEADERONLY to see if you're putting multiple backups into a single...

It is less than 2 G.

Anyone has got any idea?

Hi Jeff,

Thanks for your reply.

The full back up normally take over than an hour. For example full backup start on 1AM, and finish around 2:30AM. The log is...

Thanks guys. I think I was correct. I change the full backup to start on 1:30AM everyday and log backup to run every two hours start on 3AM. It looks...

thanks guys I will run checktable and let you know the result.

The interesting thing is I have restored the full back up into another database and I can shrink the...

The message when I back up the log is:

TITLE: Microsoft SQL Server Management Studio

------------------------------

Backup failed for Server 'DBMEL02'. (Microsoft.SqlServer.SmoExtended)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=11.0.3000.0+((SQL11_PCU_Main).121019-1325+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Backup+Server&LinkId=20476

------------------------------

ADDITIONAL INFORMATION:

System.Data.SqlClient.SqlError: BACKUP detected corruption in...

Hi GilaMonster,

Thanks for your reply. I have run the dbcc checkdb and there is no error returned. Do I have to run dbcc checktable?

Thanks

Daniel