Try it not sure

Dim strErrMsg, f, LogFile, oFS

Set oFS = CreateObject("Scripting.FileSystemObject")

...

I know log file is not optional file but when i have space problem then i am shrink database that time log file size reduce means default size but no...

Thanks a lot..........

According to this i restore 1st DIFF #3 then DIFF #2 after this DIFF # 1

then actually what happen lost any date or successfully restore All data?

Thanks, if i take 1st #3rd then #2nd then #1 What happen can i lost any data?

You should delete log file 1st then backup and then restore

hmmmmm....

i solve this problem, but i am confused that if i have 3 diff backup(3 days file) and restore 3rd day restore 1st then 2nd day, then 1st day what...

I know norecovery/standby cmd but its my problem is that until not restore with recovery it not execute any query and when i restore with recovery then i am again...

When i am restore diff backup then database not set standby or norecovery.

me want programatically set norecovery first and then restore then again set with recovery. when i am set...

You should take differential backup and restore it.

mmmmmmmm......

yes i have other plan in a feature suggest me solution.

1st server have more work load and i want reporting from 2nd server daily.

My main object is that i have daily deferential backup from a server and restore to another server by DTS.

So pls give me a sutable solution?

Thanks......

yes i have taken with norecovery backup then its items show is blank means table,storedprocedure,etc