I restored the db using interface.

Not using the command

To avoid all the confusions and complications

I created a fresh db on dev and restored the backup to this freshly created db.

and now things seems to be clean and...

I tried restoring directly by right clicking on the database and selecting the .bak file and choosing the mdf and ldf path's

I was able to choose the mdf and...

Hi,

Both seems to be logs files

but one of them on dev is named as tlog_archive,

I am not sure what it is doing.

I tried restoring the db from production...

My production environment is using only ONE ldf

and Dev has TWO ldf's

and I need to restore from Production to Dev db

mmm ... I will try to find more details about it and get back to you

Thank you for the supportive details

That is out of my scope, I just need to give the information what they were looking for.

I think they were doing some network analysis..

He wants to know the 'the database which has the most number of queries executed' per day,

to see to which db's are used(quried) more on daily basis by the world.

The success exit code is 0 and is working fine when I execute the SSIS package separetly.

I am not seeing any issue when I execute standalone SSIS

but it fails...

Hi

Thank You for the helpful top

I did enable -- "" 'Include step output in history' ."" long before and trying to work for the fix

but did not find...

mmm.. I am looking for the permissions, noting worked so far.

that exec is just putty console exe, and it works fine as a standalone SSIS from business intelligence

Hi,

I went to the command prompt and tried executing the command from batch file.

Please check the below command and msg that I am getting

C:\>dtexec pscp.exe -q -pw xxxxx -batch...

I agree with the points mentioned,

I am trying to tune the db now and I really appreciate each and every ones help to get this done.

I will try to avoid...

Hi,

I removed all the 3 functions and updated the query accordingly and executed it. it is taking 10 sec to execute now.

Thank you for all the help

I am trying to...

Table bbbb is nothing but t_UserPreferences

and table cccc is nothing but resumes

my UserPreferences i.e bbbb has comma separated region ids and category ids, that is the reason to use...