can you post details of the job steps?

doe this machine belong to a windows domain, supply more info please

personally i'd burn them to separate disks

option 1 is the native client update, option 2 is the full monty 😉

usually a repair of the .NET 2 framework is enough did you try that at all in your previous steps

madhu

your service account does not need domain or machine rights as they are automatically assigned by the setup program or sql config manager. A series of local groups get created...

releasing space can be wasteful of resources. Space in the file wil be required to carry out the action, so it'll only grow again and have you going round in...

Gail, who knows i'm with you on this!

BTW happy new year 😉

Daksin

as Adi pointed out you cannot query the database in the norecovery state. Bear in mind with the standy option when log file restores occur users will be kicked out...

Gail, i see where Paresh has gone with this. He advises that after truncating the log and breaking...

Dugi (12/31/2008)

---

Yes I can see for that reason I told Steve that the SSC board should have more...

also remembering from another of your posts,

did you set the "lock pages in memory" policy on this server?

BTW nice script Jeff

dholland (12/30/2008)

---

Ahh yes. I don't believe I have it on my box..

Just checked:

Microsoft SQL Server Management Studio9.00.1399.00

That is SP1. My server is on SP2, let me...