Viewing 10 posts - 121 through 130 (of 130 total)
thanks for your suggested links.it's so useful to me.
April 7, 2009 at 2:58 am
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...
April 6, 2009 at 10:53 pm
i need the reason why the specified error is coming when i'm restoring, T-SQL in before post.
April 6, 2009 at 10:32 pm
here is the t-sql
April 6, 2009 at 10:27 pm
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...
April 6, 2009 at 10:21 pm
Please explain why the error is comming.The backup set holds a backup of a database other than the existing 'SASE' database
April 6, 2009 at 10:20 pm
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.
April 6, 2009 at 9:55 pm
i've doubt how can i detect that the particular page is corrupted.
April 6, 2009 at 9:34 pm
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....
April 6, 2009 at 9:25 pm
it can be perform on production server, is there any problem to log backups or some other recover options.
April 6, 2009 at 5:23 am