apply the service pack 4 for SQL Server 2005 and then rebuild the currupt indexes once again

Filter Index

Index Fill Factor ?

is this table is read extensive or dml extensive ?

Visit on these mentioned below links

Heading 'Large Row Support'

http://msdn.microsoft.com/en-us/library/ms190969.aspx

Heading 'Row Overflow Considerations'

http://msdn.microsoft.com/en-us/library/ms186981(v=SQL.90).aspx

1-Identity the transaction tables

2-Identity the relationships of tables

You should write store procedure for each table and in each store procedure you will write a transaction its depend upon you how...

you must be associate DBA and not then you should study alots of stuff

do you have any expierence as a DBA?

Yes first add on the passive node and then move cluster on the passive node this will convert on active node then do same as on the second passive node

take...

Execute the job and check the locks on the tables which those are using in this job and check the status of this job with the help of this query

SELECT...

yes you can add this feature in the current installed SQL Server Cluster installation

Yes

User connect the Terminal server first with the windows login and then connect the SQL server with SA how its possible ,it will show SA because users connectiing the SQL...

consider Backup also

sp_help_revlogin recovery store procedure is available by microsoft

visit this link and get the required userid password with the help of this script

http://support.microsoft.com/kb/246133

find the recovery process is running in the backupground,you can get the percentage of recovered database with the help of SQL Logs

Copy_Only option is available for the Backup without interrupt the database backup chain

Example

1-Full Backup without copy_only option

2-Full Backup with Copy_only Option

3-Differential Backup

Then you will restore the first full backup without...