Is it possible in SQL Server to restore Databases partially?
In the sense, I want to backup just 2 tables from a database & restore them, instead of having to take a backup of the entire database & restore the entire database.
One way to do would be to export data & then importing data for only those selective tables, but I dont want to do that, bcause that would probably take more time & can be error prone.
You can create a seperate filegroup and create selective tables on that. Then individually backup that filegroup from rest of the database. Plus backup the transaction log.
When you need to restore those restore the filegroup backup and the transaction log. However, it is unlike any other db system and I would recommend doing a complete backup, restoring it to another server and then restore/transfer selected table
BOL implies that you can add filegroups to an existing DB but cannot move tables from one filegroup to another. I guess you would have to export the data, drop the existing tables, create new tables on a new filegroup and then import the data to the new tables.
Backup in EM has an option for backing up files/filegroups doesn't it?