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.

Thanks for your reply. As you said I can see the script but how can I see execution plan while it was running or after it ran?

First, thanks for your reply. It was moved from DAS to Local Drive. Now it's faster.

Thank you!!!

I know both have toll. what would you do on production db backup? only CHECKSUM? CHECKSUM AND RESTORE VERIFYONLY? OR VERIFYONLY?