For logins transfer, you have script in Microsoft KB's..For jobs you can do it through SSIS..SSIS packages, i think in same way, except you have to change parameters (if you...

For free space, try xp_fixeddrives

Use SYSALTFILES for location and size of databases..

--Sudhie.

I have never configured witness servers, but most of the configuration errors will be due to End points and their permissions, certificates..

Make sure that all the servers trust each other...

Try giving security admin privileges to Sharepoint accounts (Admin account as well as farm account), i assume you are using only 2 accounts.

Did you configure search service? whats the...

No SQL Lite speed?

Use sp_dbmmonitorresults stored proc to see the send rate. If send rate is good, then you should not have problem with network bandwidth.

If you have are mirroring highly transactional database,...

Following the query to get report for Index defrag scan percentage from 10 to 99% for various indexes. (From the last reboot).

use

GO

Select [Object_id] AS ObjectId,

index_id AS IndexId,

avg_fragmentation_in_percent AS FragPercent,

partition_number...

You may have to check your statistics information - Run it on all the databases -

SELECT O.name AS

, O.name AS [Index Name],

I.rowmodctr AS [Rows Modified]...

DBA suggests, DBA manager approves, Business gives out money when proper justification is given.

--Sudhie.

If primary goes down, you can bring secondary up in seconds just by a single command.

Detailed Documentation available here -

http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx

--Sudhie.

Harsha - It depends on your scope of work, If you are asked to document every functionality then God Save you 🙂 and the reverse engineering will help you as...

By clustering, you will have single point of failure both at disk level and SQL layer level. If your database is corrupted, you are gone. Cost will also be higher...

Jack - Query is giving you the number of rows updated after the stats are last updated.

--Sudhie

Krishna (2/12/2009)

no its not strane its the...

Secondary status should be something like this..

Mirror,Synchronized/Restoring

Mirror,Synchronizing/Restoring

If the status is not in above two and just it is restoring, then its a broken case. you will have to re-create mirroring.

Thanks,

Sudhie.