Read, write and modify permissions are available for the user id which is running the job.

more over i have tried with my windows id still is not deleting but manualy...

where is your ndf is it on primary group or secondary?

which is group is default?.

thanks gail

i never been updated with that.

try this instead of complete db if you want to clear the only the logs.

dump tran dbNamewith no_log

dbcc shrinkfile (dbName_logName,truncateonly)

do you have any space issue to clear the log...

do have your servers running on different id's?.

if it is same id why access change is required?

zahid_7777 (9/3/2012)

---

May be you are right I will create new backup policy, by adding recurring, daily, expires in 1 day and append option selected. But where can i found append...

i hope this is wrong, can someone confirm this.

opc you mis-understood this is not @rarara.

i asked my doubt related to that.

Thanks, i have read it somewhere , but how did the other details gone to the secondary server?

what about drive and backup drive details?

if their speed is low or any hardware issue there this might happen.

as the user specified select * from sys.sql_logins datas are matching on both the servers.

is it matching due to master DB mirroring?

opc.three ,

hope login created dates are matched because of master DB sync?

just connect in mangement studion and expand security and right click on login and it will guide you.

kindly post new request in new post.

can you post the hardware server configuration, like processors, and drives are ordinaly HDD or san drives. backup drive details

Definetly looks like sql is waiting for something.

Hope your identity int column as reached its limit.