InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 17:35:19 GMT20http://www.sqlservercentral.com/Forums/Topic1353492-391-1.aspxThank you all! Synonyms did the trickTue, 04 Sep 2012 03:53:00 GMTchammannhttp://www.sqlservercentral.com/Forums/Topic1353492-391-1.aspxThanks Johan, I will give it a tryMon, 03 Sep 2012 22:50:42 GMTchammannhttp://www.sqlservercentral.com/Forums/Topic1353492-391-1.aspxAs long as you stay on the same SQLInstance, it should be OK.Just:1) create another DB ( enable ownership chaining )2) create the table you need3) grant the account being used the auth it needs for that table4) in a single transaction, rename the current table and create a view or synonym that points to the new table in the new db5) move over the data from the renamed table to the new table.6) ( after double check ) drop the old (renamed ) table[b]Keep in mind, you'll need to take backups of the new db anyway! ( or if you don't care about the data, script it all every once in a while. )[/b]An alternative could be to just move that table into its own filegroup and perform filegroup backups.Also, with sql2008, [u]enable backup compression[/u]. ( with our db it reduces the backup to about 20% of the original backup file size )Mon, 03 Sep 2012 08:12:47 GMTALZDBAhttp://www.sqlservercentral.com/Forums/Topic1353492-391-1.aspxTake a look at synonyms, they should do what you need.Mon, 03 Sep 2012 07:56:12 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1353492-391-1.aspxWould it be possible to move a table to a new database, but still reference it on the old name?We backup & restore a database on different environments alot and I would like to move one of the tables out of the backup as to save space. The table is currently 25Gb.Mon, 03 Sep 2012 06:39:05 GMTchammann