How to move a large table with images to another SQL database and link it.

• kevin.smith-1067125

  SSC-Addicted

  Points: 496

  More actions

  January 12, 2012 at 5:34 am

  #262812

  Hi, we have a SQL 2008 database in which one table contains images. The database backup size is now too big to backup and remotely copy.

  My requirement, which I wonder if anyone can help with, is to separate that table to another database, but have it linked seamlessly as though a table in the original database.

  Can that be done? Can anyone help?

  Thank you.

• azdzn

  SSCarpal Tunnel

  Points: 4128

  More actions

  January 12, 2012 at 6:32 am

  #1432424

  Duplicated post.

  See : http://www.sqlservercentral.com/Forums/Topic1234678-391-1.aspx