Setting up the Database, Options, Tempdb size ...

• Digs

  SSCertifiable

  Points: 7333

  More actions

  February 5, 2005 at 2:00 pm

  #165898

  I see the procedure sp_dboption has many settings for ones database, I also understand that the Tempdb can be set for large data sizes.

  I am looking for information on how to set up ones database under "best practise" guidlines, are there any links you have any advice is welcome.

  I have searched this site, but not much as come up

   

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  February 7, 2005 at 3:27 am

  #540876

  Counterquestion: What kind of environment are we talking about? OLTP or OLAP. How many users, transactions, size of db, uptime requirements....

  In the meantime have a look here:

  http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlops0.mspx

  http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/anservog.mspx

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