Post reply

Where can i get a sample database for SQL Server 2008 R2?

  • May 18, 2012 at 2:38 pm

    #274309

    Where can i get this for the Developer edition?

    I have tried http://sqlserversamples.codeplex.com/ and the links no longer seem to work or the Sample doesnt install correctly or have a DB

  • May 18, 2012 at 2:46 pm

    #1489969

    This should work for you

    http://msftdbprodsamples.codeplex.com/releases/view/59211#DownloadId=198008

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • May 18, 2012 at 2:51 pm

    #1489971

    Thanks for your quick reply, should i download just the 'AdventureWorks2008R2 Data File' or the others below aswell?

  • May 18, 2012 at 2:55 pm

    #1489972

    Just the data file will work for creating that database.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • May 18, 2012 at 3:07 pm

    #1489974

    Thanks once downloaded should i select open with SQL Server 08? As tutorials ive watched the sample seems to open up differently ?

  • May 18, 2012 at 3:16 pm

    #1489976

    Once downloaded, then you attach the database file within ssms. Do you know how to attach a database file?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • May 18, 2012 at 3:31 pm

    #1489980

    I have just tried to attach the downloaded database and it came up with an error?

    I originally had the DB saved on my desktop so i moved it to the SQL directory in my C drive but it is coming up with an error

  • May 18, 2012 at 3:38 pm

    #1489984

    what is the error?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • May 18, 2012 at 3:40 pm

    #1489985

    When i select the Downloaded sample DB i get this message when trying to attach:

    Attach database failed for Server '*******'. (Microsoft.SqlServer.Smo)

    An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

    Unable to open the physical file "C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\AdventureWorks2008R2_Log.ldf". Operating system error 2: "2(failed to retrieve text for this error. Reason: 15105)". (Microsoft SQL Server, Error: 5120)

  • May 18, 2012 at 3:52 pm

    #1489991

    You will need to remove the log file from the files to be attached windows.

    Highlight the log file and then click remove. The file should say not found. Just remove it from the list, then click ok. It should create a log file for you.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • May 18, 2012 at 3:58 pm

    #1489995

    Note that if you have the R2 or 2012 versions, they won't attach.

    I tend to like the 2008 version since it has the Filestream stuff. If you don't need that, then pick the one without Filestream.

  • May 18, 2012 at 4:02 pm

    #1489996

    Steve Jones - SSC Editor (5/18/2012)

    Note that if you have the R2 or 2012 versions, they won't attach.

    I had no problems attaching either of those two versions (2008 R2 and 2012). You just have to remove the log file from the attach script.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • May 18, 2012 at 4:04 pm

    #1489997

    i have just tried removing the log file and i am now given this error message:

    CREATE FILE encountered operating system error 5(failed to retrieve text for this error. Reason: 15105) while attempting to open or create the physical file 'C:\Program Files\Microsoft SQL Server\Sample DBs\AdventureWorksDW2008R2_log.LDF'.

    Could not open new database 'AdventureWorksDW2008R2'. CREATE DATABASE is aborted.

    File activation failure. The physical file name "C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\AdventureWorksDW2008R2_Log.LDF" may be incorrect. (Microsoft SQL Server, Error: 5123)

  • May 18, 2012 at 4:08 pm

    #1489999

  • May 18, 2012 at 4:46 pm

    #1490004

    Is there something i may have not installed properly?

    Also does filestream have to be anabled or anything else? Ive noticed i dont seem to have filestream with the SQL 2008 R2 Dev.

Viewing 15 posts - 1 through 15 (of 48 total)

You must be logged in to reply to this topic. Login to reply