Grant, that's what I thought. I just googled it says 1 Kilobyte = 1000 byte. Backup_set is in bytes according to BOL. I am trying to figure out backups size...

I use Maintenance plan (Maintenance Cleanup Task) and point to the folders where backup files stores.

Thank you Grant!!!

Grant Fritchey, Can you please put your inputs about what exactly I have and what's the 'MaxDop' no. should be?

I appreciate your inputs JeepHound!!!

is it copying on the same server or different server? when you 'view history' of the copy job what it says (click on + sign if you have any in...

Thanks for the reply Lowell. just have few questions:

1. Is it OK just to copy login using sp_help_revlogin and give 'sysadmin' role later? will it work?

2. what's the best solution...

So which level is fragmented 99% according to G. Berry's script? should I be worried about above result and run rebuild index job?

Thanks for you reply. But i didn't catch you. All three outputs have same table name, same index name and index type, but different fragment level and different page count!!!

Thanks you guys for your input.

@jeff it's 1.5 TB

Is running DBCC CheckDB is safe on 'Snapshot' of mirrored database on Mirror server? I think running 'Checkdb' would need lots of TEMPDB resources. What should be safe side running...

Thanks for the quick reply. I am missing something here:

I think Rebuilding index is to remove fragmentation, when you remove fragmentation you will have less or no page split,...

Add a file to another drive. Check for any long running transaction and 'kill' it.

Thanks for your reply. 1.75 TB database

Thank you Grant and Scott.