grimstoner
New Member
I am dealing with a weird problem in SQL Server 2008.I previously had SQL Server 2005 installed on my local machine.I have a backup of a SQL Server 2008 which has to be worked upon locally and then restored to the original database (work involves use of ad-hoc queries which is disabled on my server since it is hosted with an ISP.)Problem:The SQL Server 2008 is giving me the following error.\[quote\] An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) The media family on device 'D:\Data\F1\purt144_634889883032976839.bak' is incorrectly formed. SQL Server cannot process this media family. RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3241)\[/quote\]Questions:
- Can 2 or more versions of SQL Server co-exist on same machine? If yes why is the server instance showing version no 09.XXX (in the right hand section for SQL Server Management Studio 2008) version for SQL Server 2008 being 10.XX.
- What could possibly be the problem apart from database being corrupted or backward compatibility issues?