thanks to replay and understand my problem

your script i have already execute. i have already db_owner right to this user.

i have check login status to execute following query

EXEC...

thank for both to replay

the database is read only or stand by mode.

my need is restore the log file to user connected database . the user only read the...

thanks to reply all

i have shrink the .ldf log file of database. becouse increse the size of log file