restore diff and full file backup on sql server

Question

dear all,

Is possible restore one full backup file and one diff backup file with different month??i.e. full backup file on March and Diff file on April..??

Thanks 4 all answer

Best regards

Answer 1

It is possible if you perform full backup on March and diff on April, nothing in the middle:-))))) I mean no full/diff backup between March and April.

---

Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

Answer 2

HI,

When you take full backup SQL server there is something like mark identify the last full backup after that when you take differential backup SQL server backup your DB from last full backup till now.

so make sure that there is no full backup (if there is one taken with copy only option there is no problem) taken between march (full backup) and April (Diff backup).

I hope this is helpful.

---

Please Mark it as Answered if it answered your question
OR mark it as Helpful if it help you to solve your problem
Elmozamil Elamir Hamid

MyBlog

Answer 3

Hello Urang

Please Verify From Microsoft Link

http://msdn.microsoft.com/en-us/library/ms175510.aspx

-- Assume the database is lost at this point. Now restore the full
-- database. Specify the original full database backup and NORECOVERY.
-- NORECOVERY allows subsequent restore operations to proceed.
RESTORE 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

I hope Help you ..

Best Regards

---

Leonardo Martínez