Post reply

ive lost "northwind.mdb"

  • August 23, 2004 at 6:56 am

    #86335

    hiya,

    the above database has been deleted from my instance of sql2k.

    I searched for "northwind.mdb" on my sql2k disk and also on the net.

    I apologise for the stupid question, but does anyone know where I can download the .mdb file?

    yours in stupidity

    yogi

  • August 23, 2004 at 10:38 am

    #520207

    If you don't have access to another instance, you may have to re-install.  If you have enough space, you could install a named instance, backup Northwind ( or stop SQL and copy the database files), then delete the named instance.  Then I would suggest taking a backup of all the databases on your server. 

    Steve

  • August 24, 2004 at 4:24 am

    #520281

    No need to feel stupidity for this.

    Follow the link

    http://www.microsoft.com/downloads/details.aspx?FamilyId=06616212-0356-46A0-8DA2-EEBC53A68034&displaylang=en

    Download the executable and execute it.

    thanks,

    Ganesh

  • August 24, 2004 at 4:45 am

    #520285

    hiya,

    ta for the advice.

    I tried installing a named instance, but northwind.mdf did not turn up.

    then, I downloaded and ran the script.

    However, when i tried to atach, I got the error:

    error 5123: CREATE FILE encountered OS system error.

    I think this might be to do with another another problem which I'll post.

    cheers,

            yogi

  • August 24, 2004 at 1:39 pm

    #520401

    Northwind Sample Database

    The Northwind Traders sample database contains the sales data for a fictitious company called Northwind Traders, which imports and exports specialty foods from around the world.

    If you have made changes to the Northwind database, you can reinstall it by running a script from the Install directory of your Microsoft® SQL Server™ 2000 installation:

    1. At the command prompt, change to the Mssql\Install directory.
    2. Use the osql utility to run the Instnwnd.sql script: 
      osql/Usa /Psapassword /Sservername /iinstnwnd.sql /oinstnwnd.rpt

    3. Check Instnwnd.rpt for reported errors.

    The database is created in the Data directory of your SQL Server installation.

    Above info retrieved from BOL.

    Gary

     

     

  • August 25, 2004 at 5:04 am

    #520477

    hi folks, I managed to get it installed.

    ta,

    yogi

Viewing 6 posts - 1 through 5 (of 5 total)

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