CODEWITHSUNDEEP
sql-serversql-server-2008database-backupsdatabase-restore
sujith karivelil
sujith karivelil

Reputation: 29026

Restore selected tables from .bak file

Is their any possibility to restore selected tables from a .bak file using Microsoft SQL server management studio. By using query browser i am able to open back-up file in script tab and hence select required queries, is their any similar operation is available in sql server?

Upvotes: 3

Views: 3534

Answers (1)

Jeffrey Van Laethem
Jeffrey Van Laethem

Reputation: 2651

Unfortunately it is not possible to restore specific objects from a .bak file. You could restore the database somewhere else, then use the Import/Export utility to refresh a table's data.

Upvotes: 8

Related Questions