Default backup lockation is available in registry of the server "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.2\MSSQLServer" on "BackupDirectory".

i dont think this is accessible using the partila code provided by you.

can you post...

as i read the link he provided i got to know it is for Windows Server 2008 and in Windows Server 2008 R2 editions.

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?