I got it, but one question while copying this is command pane.. there we have to select the database also?? by defauklt it is Master, what should i choose???

thanks Shell.. will try to implement it

Anthony - Do u want me to paste the entire code in Command pane ending with Exec SP???

example -

DECLARE @sql NVARCHAR(MAX)

SELECT...

Hi Shell,

Acccording to John, i have followed the below step

(1) Modify the code I posted so that it fits your environment

(2) Create a new job

(3) Copy and paste the code...

20 seperate steps is okas of now...

But in another Server there are almost more than 100 Db's :w00t:

Anyways will test it step by step, incase i have any issues, will...

Cool John, Thanks Man 😉

I will do it today itself & will let you know tomorrow..

Just one question..

IF i set the SP pne after other then..

The sequence of execution will...

Yes the procedure is same for all database, but John can u let me know the steps by step about setting the jobs?

how do i set the JOBS one after one..

I mean...

1st the SP for one DB will be executed & only after that the SP should get executed of rthe second...

john, where did u go:w00t:

Yes John, same to same 🙂

Hi,

can u please copy paste the scripts n steps here... the link is blocked in my office :w00t: & at home i have no internet 🙁

:w00t:

No reply 🙁

I spoke with them,... they said they are using a FTP via which the files are transffered.. but if i want to make a database backup restore or data import/export...

Ok fine.. willl see to it 🙂

thank you everyone for quick response n help 🙂

I will like to add one more thing

We have one Rack Space server & other normal...

i opened Event Viewer.. but exactly where do i find the Logs stating SQL server

Thanks Gila, but reagrding SQL SERVER Error Log, will this will a file stored on any location???

coz if DB wont start how to check Error logs then??

More over coming to...