Solved

Northwind deleted tables, how to restore

Posted on 2004-04-27
2
354 Views
Last Modified: 2010-07-27
Hi
I have an MS SQL 2000, which I use for development. I accidentaly deleted some files(I guess so) of the database,
Now I can't see some tables and stored procedures.  Is there a away to replace it/ restore it to its original state? I am a newbie,
so please give me some tips?

Thanks
Heart
0
Comment
Question by:heartguy123
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 69

Expert Comment

by:Scott Pletcher
ID: 10932308
1) Do you have a backup of Northwind that you can restore over the existing Northwind?

2) Do you have another SQL Server installation with Northwind?  If so, you can take a backup of that db and restore it over the damaged Northwind.
0
 
LVL 7

Accepted Solution

by:
Lori99 earned 250 total points
ID: 10932357
Go to the directory c:\program files\microsoft sql server\mssql\install or wherever you installed SQL Server.  There you will find a SQL script called instnwind.sql.  This is a script that drops and recreates Northwind.  You can run it from Query Analyzer.
0

Featured Post

Do you have a plan for Continuity?

It's inevitable. People leave organizations creating a gap in your service. That's where Percona comes in.

See how Pepper.com relies on Percona to:
-Manage their database
-Guarantee data safety and protection
-Provide database expertise that is available for any situation

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

622 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question