And the error is like this:

Service cannot be started. System.IO.FileLoadException: Could not load file or assembly 'ReportingServicesNativeServer, Version=0.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The application has failed to...

i am getting error that ACESS IS DENIED.

what if system databases go suspect mode due to corruption during transaction rollback or during crash recovery.that time will the sql server will be alive?

Suspect mode requires that SQL...

Gail, what i mean is,when sql server is running fine,then suddenly model and msdb went into suspect mode during this time will sql server work fine or not?

here :

when msdb...

Thank you so much Gail for helping dba's like me for sharing your knowledge with us.

Gail, this was the question i faced in an interview recently,but i don't know what interviewer mean by that?He asked me clearly other possible ways to do it.

Thank you Gail,

apart from rebulid and reorganize is there any other ways of fixing it.

thanks in advance.

Hai Gail,

What types of permission we need to give to sql server in order to provide permission to that folder? Can u please explain which service accounts is best recommended...

for more information on mirroring setup:

http://blogs.msdn.com/b/suhde/archive/2009/07/13/step-by-step-guide-to-configure-database-mirroring-between-sql-server-instances-in-a-workgroup.aspx

yes, we can setup mirroring with more than one instances in the same machine by configuring principal server and mirror server and an optional server called witness server.

fro more information...

Hai Ramana,

here my question is " if we give NT AUTHORITY/NETWORK for both instances that is for default instance and named instance, when we restore database to a named instance,...

Hai,

I am explianing what i did

In my local machine i installed sql 2008r2,one is default and the other is named instance in which i gave the service account as NT...