Home Forums SQL Server 2008 Data Corruption (SS2K8 / SS2K8 R2) Restore database from SQL Server 2012 to SQL Server 2008 R2 RE: Restore database from SQL Server 2012 to SQL Server 2008 R2

  • May 6, 2014 at 11:36 pm

    #1711341

    Right-click the database in SQL 2012...Tasks..."Generate Scripts". Choose the "Advanced" button under "Set scripting options" and set the "script for server version" to the required database format. For "Types of data to script" choose "Schema and data".