Good morning,

I do not have much experience in SQL, which is why I need your .
What steps should I continue to make a running SQL server and DBS?.
You can defragment the DBS with some software?. I bought the PerfectDisk 8, but I dare not pass it.

Windows Server 2003 x64 16GB.
SQL 2005 EE SP2 - Cumulative_Update_7

Thank you.

Justo (justo@hotmail.com) writes:
> I do not have much experience in SQL, which is why I need your .
> What steps should I continue to make a running SQL server and DBS?. You
> can defragment the DBS with some software?. I bought the PerfectDisk 8,
> but I dare not pass it.

When it comes to defragmenting databases, we usually talk about
defragmenation within the database. A disk fragmenter can be ful
if the database files themselves are very fragmented, but usually the
problem is with indexes and tables within the database. Defragmenting the
database files is something you maybe only once, but defragmenting indexes
is something you need to regularly to database that is updated frequently.

If you are new to the game, it may be easiest to set up a maintenance
job. And attend a class on SQL Server administration.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx