SQL backups without the .BAK extension do not restore
I am running into a strange problem with my backups and restores. I can't find much (any) information online.
When I backup a database from either a SQL2K or SQL2K5, the files are created without a .BAK extension. These are two seperate servers backing up different databases to different locations.
When I try to restore either of these backup files (by adding the .BAK extension to them first), to either a SQL2K5 server or a SQL2012 server (depending on which version I am restoring from), I get errors.
For example, here is once instance of an error:
RESTORE DATABASE MartinFletcherCorporate FROM DISK = 'E:\sqlshare\MartinFletcherCorporate.BAK'WITH MOVE 'MartinFletcherCorporate_Data' TO 'E:\SQLData\MartinFletcherCorporate_Data.mdf',MOVE 'MartinFletcherCorporate_Log' TO 'E:\SQLData\MartinFletcherCorporate_Log.ldf'GOMsg 3234, Level 16, State 2, Line 1Logical file 'MartinFletcherCorporate_Data' is not part of database 'MartinFletcherCorporate'. Use RESTORE FILELISTONLY to list the logical file names.Msg 3013, Level 16, State 1, Line 1RESTORE DATABASE is terminating abnormally.--------------------------------------------RESTORE FILELISTONLY FROM DISK = 'E:\sqlshare\MartinFletcherCorporate.BAK'Martinfletcher_dat E:\Program Files\Microsoft SQL Server\MSSQL\Data\martinfletcher.mdf D PRIMARY 3459121152 35184372080640 1 0 0 00000000-0000-0000-0000-000000000000 0 0 0 512 1 NULL 267267000000004600003 7E3EF7AB-309E-428E-A638-F96C95477C29 0 1Martinfletcher_log E:\Program Files\Microsoft SQL Server\MSSQL\Data\martinfletcher_log.ldf L NULL 1048576 35184372080640 2 0 0 00000000-0000-0000-0000-000000000000 0 0 0 512 0 NULL 0 00000000-0000-0000-0000-000000000000 0 0
Leave the files exactly as they are, with no extension, then when you choose the source file to restore from, make sure you select All files(*) from the "Files of type" dropdown at the bottom of the Locate Backup file window. Then you can select your file and the restore should complete.
*Edit - this is based on using SQL management studio to perform the restore.