0

Is it possible to log shipping for few tables only in SQL Server 2012?

Thanks

Rajan
  • 198
  • 1
  • 2
  • 10

2 Answers2

3

SImple answer: NO. THere is no per table log. THere is ONE log per database. SImple like that. You want partial table stuff - only chance is replication.

TomTom
  • 61,059
  • 10
  • 88
  • 148
0

You can manually configure this using FileGroups (ie. put tables into a different FILEGROUP), and manually manage the restore process.

Initially only restoring the tables you require Lookup Partial Restore.

This is a currently working.

user2870723
  • 1
  • 1