How can we help you today? How can we help you today?

Partial Restore of Filegroups

When using Red-Gate filegroup (partial) restores, are the tables in filegroups that are NOT restored still listed in SSMS - even though they are not restored and have no data?

I am trying to prove the process of initializing transactional replication from a backup/restore process and do not want the non-replicated tables showing up on my subscriber.

I have put all my replicated tables in specific filegroups, backed up by filegroups and restored only the filegroups of replicated tables, but the non-replicated tables also show up - the process I have been using is outside of the Red-Gate tool.

So, I need to know if after using Red-Gate for this purpose if the non-replicated tables would still showup on my subscriber. I currently do not have Red-Gate SQL Backup with which to test.
LarryVB
0

Comments

1 comment

Sort by
  • petey
    If the non-replicated tables show up in SSMS using native SQL Server backup and restore tools, then you would get the same results using SQL Backup.

    Perhaps you could obtain the results you want using Red Gate's data synchronization tools i.e. SQL Compare and SQL Data Compare?
    petey
    0

Add comment

Please sign in to leave a comment.