thanks gail, misunderstood.

Will DB in norecovery mode accepts "Set to read only" command?

Are you reffering named instance like this "ITI-PDP-DB\chandu"

first try the network path in windows , if it is not working check and fix it.

can provide more details like server1 and...

What do you exactly want to optimize? we coudnt understand your requirement.

Why dont you use replication but you cant alter any data..

Can you give us the purpose...

Have tried running profiler and try to find out "Tempdb" is the cause or you query?

Sure can help you, can you post your table structure.

Just a doubt do you have backup every 1 sec? even then the time you mentioned is not matching, elobrate it.

I guess you want to automate the (FAX Document) file reading and order generation process rather that it is happening manually(as of now).

I think you take SSIS in to consideration...

What do you mean by every 10 mins, view is not a job that executes automatically by...

Do you want to prepare and execute a manual tSQL script?

Can you give it in more clear way?

As far as i understand , you want to implement log shipping and replication.

I can tell you one thing from log shipping you...

Thanks for you reply

Are there no other alternative to this.

Is there some more details available on ther server?

Can you check the job history and see the error details?

update table_name

set col1 = replace(col1,'XXX','')

are you using something like this?

$w@t (10/31/2013)

---

Can i update systables data from my application

like [msdb].[dbo].[sysjobschedules] has job schedule dates

what if i update next date?? then the job will be run on given...