Reply to thread

Message: <blockquote data-quote="G-Street" data-source="post: 20581569" data-attributes="member: 557901">machan uba gawa differentail backups sequece ekakata nath nam restore karanna ba,(point in time recovery).uba gawa full backup ekata passe sequece ekakata diff backups okkoma thiyanwanam puluwan.athara mada log backup damoth ewat restore karanna ona.most impornt eka thama,,uba anthima .bak ekedi withari with recovery denna ona.previous ewadi with no recovery deepan. follow below stepsRESTORE DATABASE MyAdvWorks     FROM MyAdvWorks_1     WITH NORECOVERY;  GO  -- Now restore the differential database backup, the second backup on   -- the MyAdvWorks_1 backup device.  RESTORE DATABASE MyAdvWorks     FROM MyAdvWorks_1     WITH FILE = 2,     NORECOVERY;  GO  -- Now restore each transaction log backup created after  -- the differential database backup.  RESTORE LOG MyAdvWorks     FROM MyAdvWorks_log1     WITH NORECOVERY;  GO  RESTORE LOG MyAdvWorks     FROM MyAdvWorks_log2     WITH RECOVERY;  GO</blockquote>

Top Bottom