Thank you

any help

Thanks

I am just trying to understand and test how to use token, if you have more information about usages this will be helpful

Thanks lot

Thanks

Then Hoe do you suggest to use token appropriatly or better usages

Thanks

Thanks

is job token must be runned by alert or it can be runned as normal job

Thanks

but the out file doesnt show the database name , which is used in token

Thanks

I made an output file to the step, but what is writen is

Job 'testbackup' : Step 1, 'token1' : Began Executing 2013-02-05 16:12:34

Current database name is [SQLSTATE 01000]

any suggestion

Thanks for replying

I wrote PRINT N'Current database name is $(ESCAPE_SQUOTE(A-DBN))' ;

inside step, and the job is succeded, and the mail alert has sent by the operator to the target...

Thanks for replying

I have read these info, but I need to know where should I write the token

should I write it inside the job after the t-sql code step or...

thanks

I am making backup from SSMS -- dbtasks and the error says user hasno permission to perform this action

The restore file located on the same harddesk, but there is...

Thank you very much, I can read it now by running this query

Thanks lot

I made

begin tran pp with mark ;

SELECT * FROM msdb..logmarkhistory;

The result is nothing, 0 rowes affected, what does this means ?

Thanks lot

I repeated steps

-Mark transaction

-backup transaction log

-restore full db with no recovery and close existing connection

- db -- tasks -- restore -- transaction log

then marked transaction -- emplty dialog box

any idea,...

Thanks for replying

please find attached, I solved the gray tranaction log, but I found the mark dialog box is empty and I sure I have done it

I dont know...

Thanks for replying

Kindly find the attached file, why the Tasks -- restore -- Transaction log is not enabled

Thank you very much