I want to restore a table in SQL Server 2005, not the whole database. I don't believe I have 'file groups' set up. I am doing:
drop table myTable
select * into dbo.myTable from backupDB.dbo.myTable
the 'restore into' works well enough - it preserves identities and null/not-null settings. The problem is that it loses the key and index definitions. I have not tried it on a table with column descriptions and initial values, so I don't know if those are preserved or not.
Is there a better way that preserves all attributes of a table?