Yes I have backedup the registry key.

1. I did unintall DB engine and reinstall it , this was done to change the collation. After reinstalling the DB Engine I...

Hi All,

Even I am facing the same error.

Service cannot be started. System.Exception: Default appdomain failed to initialize.

at Microsoft.ReportingServices.Library.ServiceAppDomainController.Start()

at Microsoft.ReportingServices.Library.ReportService.OnStart(String[] args)

at...

Thank you.

This is my output when I ran sysprocess

waittypewaittimelastwaittypewaitresourcedbiduidcpuphysical_iomemusage

0x01E4179712580PREEMPTIVE_OS_PIPEOPS ...

Is it possible to use inline views ?

mike 57299 (8/6/2010)

---

Ok...

This:

use xyz

EXEC sp_grantdbaccess @loginame = 'sv2'

gets me 'public' database access to xyz for user sv2. How do I programatically get the db_owner set for...

I did try using another media but no luck.

Other 3 instances...

Thanks SSC Journeyman.

Thanks, got load of...

Thanks for the reply, I want first and last row as output rather then all the four rows.

waiting for your reply..:-)

Paul Randal (11/17/2009)

---

Is this a database that you've recently upgraded? I'm curious as to why the corruption occured in the first place - my guess is that the corruption was...

Hopefully if you have a full database backup you will be able to restore. Restoring the job please check the MSDB database this might help.

check the following views:

sysmaintplan_plans

sysjobs_view

sp_help_jobactivity

PLease find the table struct attached with sample date

Thanks a lot..saved my day.

find out the reason why the backup failed? Take another backup. Backup is very much necessary to bring up your DB from damage or corruption.

Agree with Pradeep, Good DR plan is neccesesary to protect the data. We have setup replication for most of our production boxes. Even good backup strategy will also help. Try...