I have a problem i set old backup for my database all the new data gone any one know how to reset database to specific date that before the day i restore the old data i know it may be impassable
If your database is in Full Recovery model you can take a Transaction backup (now) and then restore previous Full back, every Transaction log Backup since the full backup, in order, and on the last one use the STOPAT command to restore up to a specific point in time.
If you are not using Full Recovery Model then this is not possible, but you may be able to use a 3rd party log reader to rescue information from the Log, but I doubt it!
SELECT id, CASE WHEN Abs( Sin(Ascii(Reverse (id) ) *
355.0 / 226)) < 7e-6 THEN 'Even' ELSE 'Odd' END FROM
(SELECT t1 + t2 + t3 + t4 AS id
FROM (SELECT 0 AS t1 UNION SELECT 1
UNION SELECT 2) AS z1 CROSS JOIN (SELECT 0 AS t2
UNION SELECT 3 UNION SELECT 6) AS z2 CROSS
JOIN (SELECT 0 AS t3 UNION SELECT 9 UNION
SELECT 18) AS z3 CROSS JOIN (SELECT
0 AS t4 UNION SELECT 27 UNION SELECT 54) AS z4
) AS z ORDER BY 1
No Backup To Use to restore data
Posted - 07/11/2007 : 03:42:32
