November 10, 2012

Fusion Active Template Library (ATL)

ERROR:
Rule "Fusion Active Template Library (ATL)" failed.
A computer restart is required because of broken fusion ATL. You must restart your computer before you continue.



SOLUTION:
Go to setup media (SQL DVD) and install this package and it'll be solved after a restart ;-)

32bit: DVD\1033_ENU_LP\x86\Setup\sqlsupport_msi\sqlsupport.msi
64bit: DVD\1033_ENU_LP\x64\Setup\sqlsupport_msi\sqlsupport.msi

November 09, 2012

SQL Server cannot process this media family


ERROR:
Specified Cast is not valid (SqlManagerUI)

ERROR:
Msg 3241, Level 16, State 13, Line 1
The media family on device 'D:\1.bak' is incorrectly formed. SQL Server cannot process this media family.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

CAUSE:
- Microsoft SQL Database fails to restore from higher ms-sql version
- Restoring the backup from SQL 2008 to SQL 2005 instance
- Restoring SQL backup file from SQL 2012 to SQL 2008

SOLUTION:
- Upgrade your destination sql server to upper version
- Prepare SQL data script instead of sql data backup file