After going through prerequisites and installing SQL Server 2012 RC 0, You might want to try your hands on on the SQL Server Sample Databases for this release. AdventureWorks for 2012 RC 0 is available for download at : Download Adventure Works for SQL Server 2012 RC0 .
AdventureWorks database provided in the link above is just a 183 MB data (.mdf) file. You can use the following command to rebuild log file and attach this mdf file to SQL Server :-
CREATE DATABASE AdventureWorks2008R2 ON (FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL11.SQL2012RC0\MSSQL\DATA\UserDB\AdventureWorks2008R2_Data.mdf') FOR ATTACH_REBUILD_LOG ;
Change the path to the location where the AdventureWorks mdf file resides on your computer.
Above command will complete successfully with following message :-
File activation failure. The physical file name
“C:\Program Files\Microsoft SQL Server\MSSQL11.DENALIRCO\MSSQL\DATA\AdventureWorks2008R2_log.ldf” may be incorrect.
New log file ‘C:\Program Files\Microsoft SQL Server\MSSQL11.SQL2012RC0\MSSQL\Data\UserDBlog\AdventureWorks2008R2_log.ldf’ was created.
Related posts:
