Database Administration for Specific Platforms › SQL Server/Windows Routine Procedures › Backing Up Your Database › Restoring Databases from a Database Dump Device

Restoring Databases from a Database Dump Device

Back up stored information in files created when you create your dump device. The files, as described earlier, have the .DMP extension. For information on LOAD DATABASE command or restoring database in event of failure, see the SQL Server documentation for the LOAD DATABASE command. This gives instructions on restoring from a database dump device.