---
title: "Restore Database (Files Page) | Microsoft Docs"
ms.custom: ""
ms.date: "06/13/2017"
ms.prod: "sql-server-2014"
ms.reviewer: ""
ms.technology: backup-restore
ms.topic: conceptual
f1_keywords: 
  - "sql12.swb.restoredb.files.f1 in the code"
  - "sql12.swb.restoredb.files.f1"
ms.assetid: 714c36ea-a9f9-43a4-99f9-a6f73d1baf8e
author: MikeRayMSFT
ms.author: mikeray
manager: craigg
---
# Restore Database (Files Page)
  Use the **Files** page of the **Restore Database** dialog box to manage the specific files you have chosen to restore within the database.  
  
## Options  
  
### Restore database files as  
 Use to assign and manage the new file path to the restored files.  
  
 **Relocate all files to folder**  
 Relocates restored files.  
  
|Option|Description|  
|------------|-----------------|  
|**Data file folder**|Enter or search for the data file folder name that the restored data file or files should be relocated to.|  
|**Log file folder**|Enter or search for the log file or files folder that the restored log file should be relocated to.|  
  
 **Logical File Name**  
 Displays one row for each database file to be restored.  
  
 **File Type**  
 Displays the file type.  
  
 **Original File Name**  
 Displays the original file path for the restored file.  
  
 **Restore As**  
 Lists the file names that the restored files are to be saved as. Enter or search for the appropriate file name.  
  
## See Also  
 [Restore Database (General Page)](../../integration-services/general-page-of-integration-services-designers-options.md)   
 [Restore Database (Options Page)](restore-database-options-page.md)   
 [RESTORE Arguments (Transact-SQL)](/sql/t-sql/statements/restore-statements-arguments-transact-sql)   
 [Define a Logical Backup Device for a Tape Drive (SQL Server)](define-a-logical-backup-device-for-a-tape-drive-sql-server.md)   
 [RESTORE (Transact-SQL)](/sql/t-sql/statements/restore-statements-transact-sql)