Please give more clarity of your question.

Thanx..

Dear Gila and Shankar,

Thanx for reply,actually I want to understood how sql works in backend if more than one log file exist..

http://msdn.microsoft.com/en-us/library/ms681382(v=vs.85).aspx

This comes either because path of mdf ldf is not correct or user doesn't have permission.

Thanx

Is there any free tool but good also?:hehe:

Dear,

Keep in mind start with the minimum privileges.

🙂

Looping Myself...

I have tried it 3-4 times then it has startred automatically.

Dear Dave,

I am getting same error ,What permoission you have given here.

Suhas Should JimB01979 use below command?

BACKUP LOG P TO DISK = 'NUL'

with proper considerations.

JimB01979 After this command actually your log will not backup they will be discarded.

Will it dscard only inactive logs...

or

the logs which have not backed up?

I am getting the same problem and I am not able to login using sa

Error is coming:Login failed for user sa Microsoft Error:18456

Its Urgent...

Thanks..

My RM was asking

Thanks to all,Yet something below:

I have found that there is a "mirror Server" option in System DSN Sql Native Client configuration but one confusion is here that :

Should I have...