Red Gate forums :: View topic - Partial Restore of Filegroups
Return to RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup 7
SQL Backup 7 forum

Partial Restore of Filegroups

Search in SQL Backup 7 forum
Post new topic   Reply to topic
Jump to:  
Author Message

Joined: 04 Nov 2013
Posts: 1

PostPosted: Mon Nov 04, 2013 5:56 pm    Post subject: Partial Restore of Filegroups Reply with quote

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.
Back to top
View user's profile Send private message

Joined: 24 Apr 2005
Posts: 2306

PostPosted: Tue Nov 05, 2013 3:25 am    Post subject: Reply with quote

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?
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 7
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Powered by phpBB © 2001, 2005 phpBB Group