Delete Northwind/Pubs | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Delete Northwind/Pubs

Hi All,
Just wanted to confirm with someone that it is ok to delete both the Northwind and Pubs databases (ie it wont break my server!)?? Thanks
Ben
No ben it won’t
I have done this several times
even I have found that in some palaces they have advocated to drop those databases for secuity reasons.
quote:Originally posted by benwilson Hi All,
Just wanted to confirm with someone that it is ok to delete both the Northwind and Pubs databases (ie it wont break my server!)?? Thanks
Ben

more information http://www.zone-h.org/files/34/sql_security.htm says Drop all sample databases. By default, the Northwind and pubs sample databases are created on install. Defaults on systems invariably have security-related problems, and we advise that these two default databases be removed.
Thanks Dinesh <img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />
As one of the best practice, it is ideal to delete those databases from production servers. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
And in case you’ll find an issue (which is *very* unlikely), have a look at the folder Microsoft SQL ServerMSSQLInstall. You should find two files there: instnwnd.sql and instpubs.sql. Guess what they will do [<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]<br /><br />–<br />Frank Kalis<br />SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />
Thanks All!
These databases may be sometimes useful, because lots of people (in books, on the Internet, etc) use them in their examples. — Rediscover the web
http://www.mozilla.org/firefox/

Very true,
It is ok those databases to be in for a development server.
But it is very much advisable to drop them in a live server. Many hackers use these databses to login into the database server as they know the structure of the database.
quote:Originally posted by chopeen These databases may be sometimes useful, because lots of people (in books, on the Internet, etc) use them in their examples. — Rediscover the web
http://www.mozilla.org/firefox/


Absolutely and I feel Chopeen’s reference is in accordance to development server. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by satya</i><br /><br />Absolutely and I feel Chopeen’s reference is in accordance to development server.<hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br />Yes, exactly.<br />By <b>’may'</b> and <b>’sometimes'</b> I meant ‘development machine’. [<img src=’/community/emoticons/emotion-5.gif’ alt=’;)‘ />]<br /><br />–<br /><br /><i>Rediscover the web<br /<a target="_blank" href=http://www.mozilla.org/firefox/>http://www.mozilla.org/firefox/</a></i>
]]>