hi,

thanks for your suggested links.it's so useful to me.

Is the SQL I have written:

i have only the backup of this databse. at present we dont have that server.

RESTORE DATABASE SASE

FROM DISK = 'C:\SASE\DatabaseOldBackup\SASE041202'

WITH REPLACE, MOVE 'SASE_log2' TO 'C:\Program...

i need the reason why the specified error is coming when i'm restoring, T-SQL in before post.

Thanks,

here is the t-sql

RESTORE DATABASE SASE

FROM DISK = 'C:\SASE\DatabaseOldBackup\SASE041202'

WITH REPLACE

Server: Msg 5133, Level 16, State 1, Line 1

Directory lookup for the file "E:\MSSQL\data\SASE_log2_Log.LDF" failed with the operating system error 3(The system cannot find the path specified.).

Server: Msg 3156, Level...

Please explain why the error is comming.The backup set holds a backup of a database other than the existing 'SASE' database

thanks,

actually i have a problem, i have a backup file it was in multiple files, when i'm trying to restore it's giving error.

hi,

i've doubt how can i detect that the particular page is corrupted.

HI,

Thanks for ur answer. i need to be standby server should be the readonly. how can i change? if i want to set standby/readonly at the time of log shipping....

it can be perform on production server, is there any problem to log backups or some other recover options.