Northwind

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Administration » Northwind

Northwind

Rate Topic

Display Mode

Topic Options

Author

Message

hirenk

Posted Wednesday, October 23, 2002 8:19 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, November 30, 2012 2:03 PM
Points: 142, Visits: 96

We can safely drop Northwind, correct? I know it's completely test Db but just want to make sure that Northwind is not of any use.

Thanks.

Post #7628

Clive Strong

Posted Wednesday, October 23, 2002 8:21 AM

SSC Eights!

Group: General Forum Members
Last Login: Monday, May 13, 2013 10:12 AM
Points: 959, Visits: 6,341

Correct.

Both Pubs and Northwind are test db's. You can do with them as you wish.

Clive Strong
clivestrong@btinternet.com

Post #44509

Greg Larsen

Posted Wednesday, October 23, 2002 8:39 AM

Ten Centuries

Group: General Forum Members
Last Login: Saturday, January 19, 2013 8:28 AM
Points: 1,038, Visits: 255

We have dropped it from our production environment, although we leave it in our test environment, so new programmers can use some of the BOL examples. Also have dropped the PUBS db as well.

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

Gregory A. Larsen, MVP

Need SQL Server Examples check out my website at http://www.sqlserverexamples.com

Post #44510

hirenk

Posted Wednesday, October 23, 2002 9:13 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, November 30, 2012 2:03 PM
Points: 142, Visits: 96

Thanks.

Post #44511

Antares686

Posted Wednesday, October 23, 2002 9:34 AM

SSCrazy Eights

Group: Moderators
Last Login: Tuesday, April 09, 2013 12:53 PM
Points: 8,357, Visits: 684

It doesn't hurt to make a backup copy of either that you can restore to any server for testing and troubleshooting issues that seem to only occurr on one server or another.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Post #44512

Clive Strong

Posted Thursday, October 24, 2002 5:07 AM

SSC Eights!

Group: General Forum Members
Last Login: Monday, May 13, 2013 10:12 AM
Points: 959, Visits: 6,341

Or failing to back it up, you can re-create the Northwind DB for future use.

From the command line go into the mssql\install directory and run the following...

osql/Usa /Psapassword /Sservername /iinstnwnd.sql /oinstnwnd.rpt

the file instnwnd.rpt will contain errors (if there are any).

Clive Strong
clivestrong@btinternet.com

Post #44513

« Prev Topic | Next Topic »

Permissions