I see log shipping as the best choice for Dr if the customer accepts a little dta shortage. With

Replication , there is a chance that you may miss objects...

Looks like your DR database has got corrupted for some reasons. Was there a restart of the service when the log restore was going on or any changes to the...

Is oracle clint installed in the sql server machine. if so can yu post us the exact error message that you get.

This is an IO error possibly due to a corruption in the physical disk. You need to get this cleared using some tools so that the IO error is rectified.

The column that holds the index should not have a size more then 900. The best option is to create an index in clumns that are smaller in length, 95%...

He has to have permissions in the msdb database to view the jobs and the MPs.

Use a group policy object to control this. Before that check in a test machine if by restricting so you will be able to use the aplication successfully. Do the...

Yes of course they will not.

You have an OS command to check if there is any deadlock @ the OS level of so go ahead with that. You can get the list of commands in...

Suresh,

You gussed and got it right. But what if the questionarrie gets the wrong process killed and hence going for a reboot. Unless we knw the right process name i...

Are you going to send mails to 5million users simultanreously. if so my first advice check if your mail server ot SMTP server can handle this much load with the...

Yes there is a link between the MPs and the jobs. you get a job scheduled for each MP that you have configured. Just check th command part of the...

No probs. Since you say that its 2000 you have to educate your users to create object with prefix dbo. so that the object is created under the dbo as...

Suresh

How do ou end the external xp using Task Manager unless u know the process or the program name associated.

the best part that i could see is check...

Vaidey, This is a SQL 2005 forum. The link that you have given is for SQL 2000. Please check...