Post reply

PUBS database

  • June 21, 2005 at 1:08 pm

    #89848

    Is there any reason I cannot remove the 'pubs' db that is installed with SQL Server 2000?

     

    Chris

  • June 21, 2005 at 1:17 pm

    #567196

    What error message are you getting when trying to remove it?

    If you are speaking about reasons not to do it, then there's none... actually it's a best practice to remove it on install.

  • June 21, 2005 at 1:19 pm

    #567198

    None... I haven't tried it yet. As long as I'm in as 'SA' should I expect any errors? Is there anything I can do to avoid issues? The thing is just taking up space.

     

    Thanks.

  • June 21, 2005 at 1:25 pm

    #567203

    If you should experience any issues (which is very unlikely), you can always recreate PUBS from your ...MSSQL\INSTALL\instpubs.sql file.

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • June 21, 2005 at 1:28 pm

    #567207

    Just on a final note, pubs and northwind are there only for demo and testing purposes. But if you don't need them, you're better off deleting them from the production server.

    Nice to see you back online Frank .

  • June 21, 2005 at 1:30 pm

    #567208

    Thanks Remi & Frank!

  • June 21, 2005 at 1:33 pm

    #567212

    HTH..

    Now don't go deleting the Model db... You actually need this one (just in case it's actually doable without a warning).

  • June 22, 2005 at 3:50 am

    #567338

    Many example scripts use PUBS or NORTHWIND and for that reason I would keep a copy of them on a server somewhere. Remi is right there is no need for them to be on a production server, but maybe on a development server so you can work through the examples you find

    HTH

    Sharing knowledge saves valuable time!
    Simon Martin

  • June 22, 2005 at 4:52 am

    #567343

    Specially when you're brand new to SQL Server and learning the ropes....even otherwise, they can come in quite handy!

    Frank - have you "withdrawn" so Remi can catch up with you ?! (That's my personal theory - since I haven't seen many of your posts since you returned from your vacation ?!?!?!)







    **ASCII stupid question, get a stupid ANSI !!!**

  • June 22, 2005 at 4:58 am

    #567346

    Even I have to work sometimes. Apparently more than Remi at the moment.

    Btw, regarding the samples out there. SQL Server 2005 will ship with a new sample database named Adventure Works, AFAIK. So, most samples will be rewritten anyway.

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • June 22, 2005 at 6:49 am

    #567387

    Hehe, I'm not catching up with him... still 3k posts behind. That's hardly close enough to even talk about it. However I can officially say that my lifetime daily post average has gone up lately from 3.2 to 6.2, passing frank by .4 post/day.

    Select 5412.0 / datediff(d, '12/5/2002', getdate()) as LifetTime_FRANK, 2541.0 / datediff(d, '5/10/2004', getdate()) as LifetTime_REMI

    5.8193548387096.227941176470

  • June 22, 2005 at 6:54 am

    #567393

    Remi - when do you get your work done ?! You sure seem to have plenty of spare time!!!

    Anyway, since Frank's posts have gone down considerably and yours' have increased, it won't be long before we see you pass 5K....

     







    **ASCII stupid question, get a stupid ANSI !!!**

  • June 22, 2005 at 7:28 am

    #567427

    Another reason I keep Northwind around is for testing backups.  I support numerous production and test environments and it's good for me to have a database that I can do trial backup/restores between all of the systems and environments.

    /Just sayin'  :oP

     

    jg

  • June 22, 2005 at 7:32 am

    #567429

    Give it a few months... got 2 weeks holidays coming soon (next month). Don't expect to see much of me here while I'm out .

Viewing 14 posts - 1 through 13 (of 13 total)

You must be logged in to reply to this topic. Login to reply