Thanks

Hi,

I don't know the answer but i am very interested in that topic.

Also i would like to know how can i restore backup file from tape to disk, just to...

thanks a lot

acko

Try something like this:

use msdb

go

select top 200 b.backup_set_id, b.backup_start_date, b.backup_finish_date,

          bm.physical_device_name,

    cast (((b.backup_size / 1024) /1024) / 1024 as decimal(16,2)) AS GB

from backupset b join backupmediafamily bm

on b.media_set_id =...

Hi

I think but not sure, that you have to move sql cluster group to another node.

Thanks Steve

Alex

Hi Bruce

It would be nice if you send me your code.

Thanks a lot

aleksandar

Thanks a lot

The problem was with triger

Alex

thanks a lot

alex

THANKS Amit

That is what i wanted, but how can i see and order id for maximum sum.

Alex

Thanks a lot

Alex

Can you tell me how can i send output to text file.

yes, i used EM, but the same think was with DBCC SHRINKFILE

alex

thanks

thanks