Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

The Voice of the DBA

Steve Jones is the editor of SQLServerCentral.com and visits a wide variety of data related topics in his daily editorial. Steve has spent years working as a DBA and general purpose Windows administrator, primarily working with SQL Server since it was ported from Sybase in 1990. You can follow Steve on Twitter at twitter.com/way0utwest

AdventureWorks in SQL Server 2012 RC0

The sample databases for SQL Server 2012 haven’t been completely finalized, but I was able to find the latest version here for AdventureWorks. This download gives you an mdf, and that’s it. You can’t directly attach that in SSMS, but you can use T-SQL to do it.

CREATE DATABASE ADVENTUREWORKS

ON (FILENAME = ‘c:\SQLdata\ADventureWorks2008R2_data.mdf’)

FOR ATTACH_REBUILD_LOG

You get a note that the log file is invalid from the MDF, but a new log is created and you have your sample databases attached.


Filed under: Blog Tagged: sql server, syndicated

Comments

Leave a comment on the original post [voiceofthedba.wordpress.com, opens in a new window]

Loading comments...