timscronin (12/7/2009)

---

Sorry, what I am looking for is that if I have 2 instances of SQl Server on a Standard edition SQL 2005 Active/Passive Cluster, that I expect both instances...

Try it with "@locallogin = NULL" and let me know if it helps!

Could you please be more specific about the kind of servers you are using? I found a link which mey help you http://www.eggheadcafe.com/aspnet_answers/SQLServerreplication/Aug2006/post27636484.asp

I agree with Elliot. Your question is not completely clear. If your question is if it is possible to have more than two instances in the cluster, then first you...

Hi Bhuvnesh,

Did any of the suggestions help you to solve your problem?

Ignacio A. Salom Rangel (10/22/2009)

---

I will like to know if any one here has ever partitioned the "AllDocStreams" table in a SharePoint Database and if so what are the experiences...

I think the job will always run under the account that starts the SqlServerAgent service!

Hey Mad-Dog,

Did you shrink the tempdb, and in case you did, what did you do to shrink it?

I run my whole backup and DR scripts with SSIS and so far I have little problems with it. It makes the maintenance of the scripts a lot easier that...

You can add the sp_configure to the script to enable and disable the xp_cmdshell and then you are set.

I think it has to do with the rights of the sqlagent account on that server. Try to login in that server with the sqlagent account and then delete the...

So if you disable it with the script an then restart the sqlagent you are good to go!

Nice script! Thank you!

The script does not work for enabling the job either. I found another solution, that is using msdb.dbo.sp_update_job. You have to give the job name as a parameter, see the...

I have the same problem as you. Disabling the job will not stop the backups and even the last run will show the last backup. I will check if I...