Sign in

Microsoft.com

Microsoft

Remove From My Forums

Backups.

Question
0

Sign in to vote

Hi,

As we know that full backup take the backup data from data file and log file. Does differential backup too take the backup of the data from the log ? I am confused because when we restore the full backup ,in end it goes through the redo and undo phase for any uncommitted transaction at the time of full backup and i have seen differential also goes through the same phase ?

Regards

Saturday, January 13, 2018 6:08 PM

Answers

0

Sign in to vote
You should specify what kind of database you are working with. If it is an SQL Server database, you should ask in an SQL server forum, perhaps here:

https://social.technet.microsoft.com/Forums/en-us/home?forum=sqltools

If it is an Access database, perhaps ask here:

https://answers.microsoft.com/en-us/msoffice/forum/msoffice_access
Richard Mueller - MVP Enterprise Mobility (Identity and Access)
- Marked as answer by Sourabh tiwari Sunday, January 14, 2018 9:47 AM
- Unmarked as answer by Sourabh tiwari Sunday, January 14, 2018 9:47 AM
- Proposed as answer by Richard MuellerMVP Saturday, February 3, 2018 4:41 PM
- Marked as answer by Danny van DamMVP, Editor Thursday, March 15, 2018 12:37 PM
Sunday, January 14, 2018 1:27 AM

All replies

0

Sign in to vote
You should specify what kind of database you are working with. If it is an SQL Server database, you should ask in an SQL server forum, perhaps here:

https://social.technet.microsoft.com/Forums/en-us/home?forum=sqltools

If it is an Access database, perhaps ask here:

https://answers.microsoft.com/en-us/msoffice/forum/msoffice_access
Richard Mueller - MVP Enterprise Mobility (Identity and Access)
- Marked as answer by Sourabh tiwari Sunday, January 14, 2018 9:47 AM
- Unmarked as answer by Sourabh tiwari Sunday, January 14, 2018 9:47 AM
- Proposed as answer by Richard MuellerMVP Saturday, February 3, 2018 4:41 PM
- Marked as answer by Danny van DamMVP, Editor Thursday, March 15, 2018 12:37 PM
Sunday, January 14, 2018 1:27 AM
0

Sign in to vote
Thanks .Posting in SQL server database forum.

Regards
- Edited by Sourabh tiwari Sunday, January 14, 2018 9:43 AM
Sunday, January 14, 2018 9:43 AM