Thanks for all the reply, i will try it and let you know.

I'm running 2003 R2 SP2 Enterprise and SQL 2005 STD, all in X86

I might also try the solutions...

Hi,

What's should I put as Min & MAX ? It's a dedicated SQL Server so it was thinking min 10 GB / max 16 GB ?

Hi,

thanks for the help and your reply.

Server is running X86

- As i said : min is set to 0 and maximum is to 2147483647 ( 2 TB )

- ...

Hello,

Found it, the trick was to restore the MSDB with option DISPLAY HEADERS ONLY

Then look for the number of the SoftwareVersionBuild

Im my case was 2055

THen i google this number...

I d'ont see any error message after my restore in the SQL logs, the only error message that I have is from my backup application :

[Warning] From: OB2BAR_Main@canmtlapp05.ds.liz.com "(DEFAULT)"...

Thx for your help Mohit,

The problem is that the backup is not on the disk its an tape, the only way to restore is via my backup application ( DataProtector...

Thx for the advice,

If i recap

- By turning the Autoshink Off i will increase the performance, however the transaction will still get empty after the Full backup ?

- Yes DB...