SQL Server Performance Forum – Threads Archive

Correct procedure for removing pubs-Northwind

I#%92ve read that, from a security standpoint, it is advisable to remove the pubs and northwind sample databases from MS SQL server. What is the correct procedure to do this? Detach the two databases at the command line: use master
go
sp_detach_db â€˜pubs#%92
go (Then do same thing with Northwind) Then delete databases in SQL Enterprise manager (simply right click, then delete)? Thank you in advance, Aval

Hi Aval, I always just go into Enterprise Manager, right click on the database(s) and then click delete You can also detach the database, which will allow you to attach it again at a later stage (not sure why you’d want to do this…) If you detach the database then the next time you go into Enterprise Manager, the database will have been removed from the list of databases for that server Cheers
Twan

Either way you can drop those 2 databases which are installed alongwith SQL Server installation and it is a right step as a security measure to drop them on the production servers. There is no point having their backups or keep them for future use. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

"use master
go
sp_detach_db â€˜pubs#%92
go (Then do same thing with Northwind) Then delete databases in SQL Enterprise manager (simply right click, then delete)?" If you dettach pubs, you can’t find it in EM. So, use EM like Twan said. Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided â€œAS ISâ€ with no warranties for accuracy.

While I agree that there is no point in having both databases on a production server, I am curious what the security risks look like. Can you post, where you’ve read about that security aspeects? And just in case, you ever need to have both databases again on a server, just go to your SQL Server/Install directory. There you’ll find the instnwnd.sql and instpubs.sql files. By running them against a server, you can recreate the databases. —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Heute schon gebloggt?http://www.insidesql.de/blogs
Ich unterstÃ¼tze PASS Deutschland e.V. http://www.sqlpass.de)

]]>