That's a shame but if that's the way it is then oh well we'll just have to accept it and try rescue the rows we know we can access. Thanks...

Perry, Steve

Thank you for the information. Glad I checked before attempting! Are there any dependencies on the order in which I do the migrations i.e. do I move...

Cheers opc.three will try this out when our system admin is back in the office. After reading the blogs you pointed me to I don't think it's worth doing...

Thank you to you all for pointing me in the right direction. The information has been most useful in deciding how we approach our proposed 2012 implementation.

Cheers,

Greg

The first SHRINKFILE with NOTRUNCATE executes OK, the second fails with the original message of:

Msg 3140, Level 16, State 5, Line 1

Could not adjust the space allocation for file 'EVVSGUKEVVSG01_1_1_data_002'.

DBCC...

Thank you for info I'm rather new to this so it's nice to be pointed in the right direction.

I've ran your query and no rows were returned for any of...

No. All file groups have been created with a single data file.

No I don't...

Thank you. I've found it! The option to set the email addresses (operators) was under the Reporting & Logging button which is next to the Manage Connections button.

Regards,

Greg