|
Home > Archive > microsoft.public.sqlserver.server > November 2002 > "Installing" a SQL Server Database
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
"Installing" a SQL Server Database
|
|
|
| Hi all,
I am using an MSPRESS trainging book for ASP.NET. In one
chapter it says to install the "Contacts" database from a
folder on the cd. In this folder there are four files:
Contacts.LDF 1,024 KB
Contacts.mdb 1,188 KB
Contacts.MDF 1,152 KB
InstallContacts.sql 21 KB
How do I go about creating the database in SQL Server? I
have installed the SQL Server 2000 Developer Edition on my
machine (Win2k Pro).
Thanks!
| |
| Brian Moran 2002-11-29, 1:23 pm |
| Well... I suspect the book has some more detailed instructions, but... I
have you looked at the contents of InstallContacts.sql ? You can probally
run this script from Query Analyzer (ships with SQL Server) to create the DB
from scratch.
You can also look in Books Online under sp_attach_db for infomation about
how to attach the database files with the .mdf and .ldf extensions. The .mdb
is probally an Access database.
--
Brian Moran
SQL Server MVP
SQL Server Magazine Columnist
"Tony" <tony@tonypino.com> wrote in message
news:1eead01c297b2$9983f4d0$8a
f82ecf@TK2MSFTNGXA03...
> Hi all,
>
> I am using an MSPRESS trainging book for ASP.NET. In one
> chapter it says to install the "Contacts" database from a
> folder on the cd. In this folder there are four files:
>
> Contacts.LDF 1,024 KB
> Contacts.mdb 1,188 KB
> Contacts.MDF 1,152 KB
> InstallContacts.sql 21 KB
>
> How do I go about creating the database in SQL Server? I
> have installed the SQL Server 2000 Developer Edition on my
> machine (Win2k Pro).
>
> Thanks!
|
|
|
|
|