I have the same problem, but when i trie to do:

RESTORE DATABASE SGT1 FROM DISK='D:\DBs\recup\Backup_RFVT_SGT_07--01-2011.BAK'

WITH REPLACE, CONTINUE_AFTER_ERROR

i receive the following error:

Msg 3186, Level 16, State 2, Line 1

The backup set...

When i do this:

restore verifyonly from disk ='D:\DBs\recup\Backup_RFVT_SGT_07--01-2011.BAK'

SQL Server sends this message:

The backup set is valid.

very strange....

the two backups are in the same file with the name =Backup_RFVT_SGT_07--01-2011.BAK

But if i do a restore headeronly i can see the two backups inside the file....

I really need this...

If i do with file =1 i receive the following error:

Server: Msg 3270, Level 16, State 1, Line 1

An internal consistency error occurred. Contact Technical Support for assistance.

Server: Msg 3013,...

thank you for the reply:

when i try to restore like this:

restore database SGT11 from disk='D:\DBs\recup\Backup_RFVT_SGT_07--01-2011.BAK' with file=2

i receive the following SQL Server error:

Server: Msg 3242, Level 16, State 2, Line...

thank you very much for the tip.

Why no backups? because it is Angola....

In Angola we do not have database administrators and SQL Server backups (maintenance plans)...

I have already told the job that (on sucess go to and on failure go to...)

Still same problem.

Any ideias?

I am thinking in using your stored procedure:

use msdb

go

CREATE PROCEDURE [dbo].[usp_DeleteOldBackupFiles]

@path nvarchar(256),

@extention nvarchar(10),

@age_hrs int

AS

BEGIN

SET NOCOUNT ON;

DECLARE @DeleteDate nvarchar(50)

DECLARE @DeleteDateTime datetime

SET @DeleteDateTime = DateAdd(hh, -@age_hrs, GetDate())

SET @DeleteDate = (Select Replace(Convert(nvarchar, @DeleteDateTime,...

Thank you for your reply.

I have two question about your stored procedure:

1) do i have to activate in the Surface area configuration the xp_cmdshell to use your procedure?

2) Where do...

we don't use that.

Thanks for the tip.

What did you meant buy "cleanup operations" ?

Thank you

Yes, i know that if the mirror is in pause, then the log will grow because when i resume the mirror session all the changes that where made in master...

i'm sorry. My english is not very good...

Now, with your last post i understood what you meant.

Thank you very much

i'm sorry, i didn't understood your answer...

Do you mean that if i do not suspect the mirror, then log backups will not discart transaction from the log file?

"unless mirroring gets suspended, then log grows because log records can't be discarded."

Hum.....

Can not be discarted?

Suppose this:

I have an instance of SQL Server with a database named test1, this database...