I'm using Sql Server and Windows authentication.

Sql server was up that time.

This job ran for 44 second before it failed.

Thanks

Its related to access ights.

Thanks,

i don't want to change to simple recovery mode.all i want if i truncate my log

backup log .. truncate_only.

and take a backup.

if anything happened after couple of day,can i able...

Thanks for ur advise, Itried that but after data restore database showing loading after so many hours,how can i bring to normal mode.

Now thats the problem?

Please advise....

Thanks

Yes i'm using System administrator account.

But why i can't see th emapped drive ?

i tried UNC name too still i got error.

if anyone have any idea please let me know.

Thanks

Before i started restore i had 9 Gb space, including the existing database the one i want to restore.now still i have 9 Gb free space,first i want delete the...

Thanks for reply,

but i read Text/Image column changes is not logged in transaction log,so how can i get these changes to subsciber.

When anything changed, it records in logs from where logreader...