Hi Sugesh,

Thank u for ur reply.

I have tried the same in enterprise manger.after that i have seen database and showing "Databasename(Loading)".but i cannot access it the same.

I have restored first...

hi sugesh,

Thank you for ur reply,

can u explain where i have missed that WITH NORECOVERY options in Enterprise manager or T-sql.

most urgent

cheers

karthik

deepak thank you for ur reply.the same should do through TSQL or Enter prise manager.if T-sql plz send the code for the same.

cheers

karthik

plz check ur backup path