- Win. (8/17/2010)

---

Hi,

It was failed when server was rebooted. And we updated the domain account and password and tried restarting the services, but still it failed.....

Please find the below error...

GilaMonster (8/17/2010)

---

Depending on how the database crashed. If SQL is still running and the transaction log is still available you can do a tail-log backup and back up right to...

John Mitchell-245523 (8/17/2010)

---

Your thinking is indeed correct.

We use sa or the SQL Server Agent account as the job owner. We usually go for the former because it's easier to...

Although u need to be very cautious doing this on a production box... and not at all recommended unless you're facing some serious perfomance issues and you need to be...

See deadlock is automatically handeled by sql server we don't need to do anything except do our investigation to find out the root cause and taking preventive measures so that...

or it shud be like below

create procedure aa

as

begin

if exists (select * from sys.objects where name='bb')

...

I don't think its a good practice for the sql service account (both mssql & agent service) to have local admin rights to the server. Although it's the other way...

Naveen..

This is a very open questin.... to prevent this happening again.. you need to have understanding of your app and then you need to understand why it happened...

Below are some...

Good one....:-D

- Win. (8/17/2010)

---

Hi,

It was failed when server was rebooted. And we updated the domain account and password and tried restarting the services, but still it failed.....

Please find the below error...

and the service account shud have same level of permissions on the network share as well..

Rohit

Hi..

Can you plz provide more info on this as.... what exactly happen when the agent wasn't starting?? was it crashed or machine was rebooted or services were rebooted.... plz post...

I don't think this is possible..... but is there any specific reason for this??

Rohit

See this all depends on the value of the data... as if data is critical then you can even have 2-4 weeks of backups on your drives itself (which is...

Yeah SAN can be one of the reasons... but I'll go with what Bhuvnesh suggested..... i.e first look at the execution plan on both servers and make a note of...