restore multiple SQL Server databases from single dump file

Question

we have received a single dump (.dmp) file created for multiple databases. Could someone please tell me

how do you create this single file ? and
more importantly how do I restore these databases to a new sql server instance

John Saunders · Accepted Answer · 2012-02-07 19:10:13Z

1

Can't check at the moment as not at my DB server, however if it's what I think it is, try right clicking on your SERVER name in SQL Management studio, navigate to tasks, and backup/restore databases.

This may also be an option on individual tables, containing multiple tables.

edited Feb 7, 2012 at 19:10

John Saunders

162k26 gold badges252 silver badges403 bronze badges

answered Nov 25, 2011 at 15:26

shawty

5,8692 gold badges44 silver badges73 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

restore multiple SQL Server databases from single dump file

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related