i got sql server 2005 express on my pc and it works flawlesslyNow i make every day backups by hand and save it to directory on my computer. Now my company made a test server with sql server 2005 express ( and management tools )and i want to restore the database to the backup file i got from my pc....Ive read alot of things about no backwards compatibility with 2008 to 2005, but this isnt the case cuzits both 2005... anyway, this is the error i get when i click options, in the restore windowTITLE: Microsoft SQL Server Management Studio Express------------------------------An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)------------------------------ADDITIONAL INFORMATION:De mediafamilie op apparaat C:\Documents and Settings\Administrator\Bureaublad\db backups\020710aa.bak is onjuist samengesteld. SQL Server kan deze mediafamilie niet verwerken.RESTORE FILELIST wordt op abnormale wijze beëindigd. (Microsoft SQL Server, Error: 3241)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=08.00.2055&EvtSrc=MSSQLServer&EvtID=3241&LinkId=20476------------------------------BUTTONS:OK------------------------------
i must say, i only installed the sql server 2005 ( first i did the MSXML update like ms site stated, then the framework 2.0)further i made a database, nothing else...thx in advance guys
backup restore from 2005 to 2005 fails
Posted - 2010-07-02 : 05:34:09
