[thelist] MSDE management

Norman Beresford n.beresford at anansi.co.uk
Tue Aug 28 09:11:45 CDT 2001


Hi all

This is possibly me being a bit thick, but I'm rather stupmed atm.  I've
installed the .net framework sdk on a win2k pro machine at home.  As part of
the install it's setup MSDE, with a number of sample databases.  Now my
friend recently won a copy of Professional ASP.Net which he gave to me.
I've started working my way through it but it requres an additional sample
DB to be added to the server.  However it only includes instructions on
adding it through SQL Server Enterprise Manager, and for the life of me I
can't find this mentioned in the MSDE documentation anywhere.  Do I need to
install this onto one of my home machines, and then use it to connect to the
MSDE server, and then follow the instructions. Or am I doomed to simply not
have the sample database available to me?  Or am I missing something really
basic out (my brains are rather fried atm after spending Saturday at the
Oval).  I've attached the instructions at the end of this email.

Thanks in advance to anyone that can help me out

Norman

Instructions for setting up the IBuyAdventure database in SQL Server
====================================================================

- Open up SQL Server Enterprise Manager.
- Right-click on the Databases folder in the left-hand pane.
- Select "New Database".
- Name it "IBuyAdventure".
- Click "OK".
- Right-click on your new IBuyAdventure database, go down to
"All Tasks" and then select "Restore Database".
- Select "From device" in the Restore dialogue.
- Click "Select Devices", then "Add", and browse to your copy of
IBuyAdventureBackup.
- OK back to the Restore database window, then select the "Options" tab.
- Select "Force restore over existing database".
- Select OK

Your database is now ready to go once you have restarted the server.





More information about the thelist mailing list