The link you provided indicates other versions.Or you could install a newer version. Any idea where I can find some sample 2008 db's ? (Microsoft SQL Server, Error: 3241)For help, click: ĭid you ensure you downloaded the version that'll work with SQL Server 2008 R2? You can't restore a 2012+ backup file to a 2008 R2 server.Tara Kizer SQL Server MVP since 2007Īh, in that case no. You can do so using the RESTORE (Transact-SQL) command, or using the graphical interface (GUI) in SQL Server Management Studio (SSMS) or Azure Data Studio. bak file to restore your sample database to your SQL Server instance. SQL Server cannot process this media family.RESTORE HEADERONLY is terminating abnormally. SQL Server 2012 SQL Server 20R2 Restore to SQL Server You can use the. ()-ADDITIONAL INFORMATION:The media family on device 'C:\Users\Administrator\Downloads\Adventure Works 2014 Full Database Backup\AdventureWorks2014.bak' is incorrectly formed. bak file from my Downloads folder:TITLE: Microsoft SQL Server Management Studio-An exception occurred while executing a Transact-SQL statement or batch. I attempted doing the Restore via the GUI but I got an error when I chose the. Since you are new to backups/restores in SQL Server, I'd highly recommend the GUI.Tara Kizer SQL Server MVP since 2007 You can use the GUI in SSMS (right click Database and go through the restore wizard, making sure to change the path of the database files) or use RESTORE DATABASE command and specify the WITH MOVE option. No idea how to get it to show in SSMS in SQL 2008 R2.Thanks!Ī bak file is a backup file, so you'll now need to restore the database. I need some sample databases so I got one from downloads as a zip file and extracts on. From the list, download the Adventure Works 2014 Full Database Backup.zip below the Recommended Download Section. We've got lots of great SQL ServerĮxperts to answer whatever question you can come up with. First of all, download the AdventureWorks for SQL Server 2012 from this Microsoft link: Download Adventure Works for SQL Server 2012 (Notice that the download only contains the mdf file).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |