i can do that too, but than it will drop all connection and i have to rename the file right ?

can i restore db with new name ?

i think below query might work but it shows the full history. I just want to see job name and last run date/time and duration

SELECT h.server, j.name, h.run_date, h.run_time, h.run_duration

...

so i know why it came as blank result becasue it ask me to enter job name etc.

sorry about that but looks like that query didn't work, it gives me blank result

so there are more than 100 sql servers - database servers

i have list of server name and instance name which i registered in ssms.

On each server there are many...

before this post, i tried that (sqlcmd -L)

it gave me nothing.

attach is the result page from that command

I just have list of all the server names

that will be great if you can send me that power-shell script, let me know if you want emailaddress. also the steps you take to automate that script. also trying...

Is there a query or way to register 100 server name with one query and you will see all the list in your left panel of register server or do...

to run the query you posted i have to connect to each server individually to check the backup, i want script which should remotely monitor or backup and create a...

Guys, Just to clarify I know the query how to check up the last backup of the database from the server.

What I am looking for is the check that data...

after i posted the example I NOTICE Something

that Table B (second table) has many records with All_ID column not just one

so basically i want to make sure the result/condition should...

PLEASE SEE ATTACHED WORD DOCUMENT TO GET MORE CLEAR PICTURE OF WHAT I AM TRYING TO ACHIEVE

PLEASE SEE ATTACHED WORD DOCUMENT TO GET MORE CLEAR PICTURE OF WHAT I AM TRYING TO ACHIEVE

PLEASE SEE ATTACHED WORD DOCUMENT TO GET MORE CLEAR PICTURE OF WHAT I AM TRYING TO ACHIEVE

Table A

select all_ID,My_Name,account,total,total_split,money_no from misc where all_ID=5505

Result of Table A Query

all_IDMy_Nameaccounttotaltotal_splitmoney_no

750Raja co.A55644331

750Raja co.A55642135

Table B

select...