Thanks a lot for your suggestion. Its working ...working great!! I would like to appreciate you.

I have checked it. Its seems like I have read write permission.

I'm using sql agent service.

I have shared excel file folder and given it full right(read,write).

I don't know about NTFS permission. Request you to can you tell about NTFS permission.

Yes, I have recreate excel destination connection but still its getting failed.

Both live and test DBServers are 64bit.

Thanks....

sorry, let me clarify.

I meant I have successfully tested it on test DBServer but when I deployed it on live server its getting failed. and about UNC path but...

Thanks for reply.

I have test it before deploying on live server actually.also given full rights to excel folder but still getting error.

Thanks for the replying.

I did same thing but I got this error "The Acquire connection method call to the connection manager "Excel Connection Manager 1" failed with error code 0xc0202009".

Thanks for posting this ultimate video!!!

But how can I restore this backup?(because full backup is stripe in two files)

Thank you so mcuh!!

Thanks for your suggestion!!

can I attach MSSQL 2008 R2 enterprise edition databases on standard edition?

I am also getting same issue. In fact I had checked everything that you had suggested but still its log are not restoring on secondary server.

Thanks in advanace.

I would like to thanks to for replying me.

Actually i wants to create trigger on either server or database wherever it is possible. and it should be audit Insert,update,and also...

Thanks a lot... for your answer

let me try using this way.