Can you use Full and Differential backup to restore a Filegroup? (74738)

Chat now with support

Return

Feedback submitted.

Was this article helpful?

[Select Rating]

Title

Can you use Full and Differential backup to restore a Filegroup?
Description

Can you use Full and Differential backups to restore a Filegroup?
Resolution

You should be able to restore a Filegroup with a Full and Differential backups. However , you will need the tlogs for it though (SQL limitation..no tlog no restore of a file group pulled from a full backup). As long as you have the complete log chain to bring the restored file group up to speed you should be fine
Here is some information that may help you.
http://msdn.microsoft.com/en-us/library/ms190710.aspx

Feedback submitted.

Was this article helpful?

[Select Rating]

Title