Compresses, encrypts, secures and monitors SQL Server backups.
Moderators: JonathanWatts, Chris Auckland, eddie davis, Colin Millerchip, Brian Harris, james.billings, RBA, petey
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.
- Posts: 1
- Joined: Mon Nov 04, 2013 5:42 pm
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
SQL Backup Consultant Developer
Associate, Yohz Software
- SQL Backup goodies under the hood, updated for version 7
- Posts: 2233
- Joined: Sun Apr 24, 2005 12:34 pm
Return to SQL Backup 7
Who is online
Users browsing this forum: No registered users and 1 guest