Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> SQL Server >> SQL Server Database Engine

Initializing A Subscription From A Filegroup Backup - SQL Server 2005

One of the new features of SQL Server 2005 replication is the ability to initialize a Subscription from a backup instead of applying a snapshot.This is a welcome feature, but it also leads me to a question.

Assume I have implemented a filegroup backup strategy.My Subscriber database has two filegroups: one contains tables that are replicated, the other contains tables that are NOT replicated.I shut down replication while I load a large data file.The load takes more than 24 hours.I now need to resynchronize my Subscriber.

Would I be able to initialize my Subscription by restoring only the backup of the filegroup for the replicated tables?

[1388 byte] By [KenPowers] at [2008-2-15]
«« Win200K and MS SQL data retreival ?
»» Printing winform in app ?
# 1

Ken,

The general rule is that the database must be consistently recovered to a point in time after the point when the publication was created with the initialize from backup property was set. As long as this is true, any style of backup/restore will work.

Matt Hollingsworth
Program Manager

MattHollingsworth at 2007-9-9 > top of Msdn Tech,SQL Server,SQL Server Database Engine...
SQL Server
SQL Server Database Engine

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified