How to Restore FILELISTONLY from a Disk

The FILELISTONLY option is a type of command switch for restoring a Microsoft SQL Server backup. FILELISTONLY retrieves a specified backup file and restores the logs and data associated with the database. You restore database backups when data becomes corrupted or your SQL Server hard drive fails. You restore files from your backups using SQL Server Management Studio, which is the main database configuration software.

Instructions

1. Click the Windows "Start" button on your SQL Server. Click "All Programs." Click "Microsoft SQL Server" and then "SQL Server Management Studio." Your database software opens.

2. Right-click the database name on the left side of the window, and select "New Query." This option opens a SQL text editor, where you type the code to restore your database.

3. Type the following code to restore your database:

   "RESTORE FILELISTONLY FROM mydatabasefile;

   GO"

   Replace "mydatabasefile" with your database file name.

4. Press "F5" to execute the code. It takes several minutes to restore the database, depending on the size of the tables.

References

• Microsoft: RESTORE FILELISTONLY (Transact-SQL)