Newbie needs SQL database maintenance help

[rickster1]

Our software vendor has required us to do SQL database maintenance with their latest software release. It's either pay them or do it ourselves. The maintenance calls for identifying and re-indexing the tables and recreating the views twice a month (normal SQL database maintenance).
There is no DBA here. I've checked out Enterprise Manager, can I do everything on EM? Any feedback is appreciated

 

[ArtieChoke]

That doesn't sound like any "normal" maintenance I'm aware of. Why would they want you to recreate a view?!!! I can see updating the statistics periodically. We have 10 Gig databases with over 1000 tables - we don't recreate the indexes!

Now if they're talking about tuning large tables based on certain types of queries or transactions, you would want to analyze them and make index changes - but not twice a month!

How much data are you moving through these tables on a daily basis?


"I think we're all Bozos on this bus!" - Firesign Theatre

 

[SQLBill]

I have a database that's over 150 GB. Believe me - I don't reindex it. Every two or three months I run DBCC INDEXDEFRAG and shrink the log files, but that's it. There's no need to reindex and no need to frequently Defrag the index.

-SQLBill

 

[rickster1]

Artie and Bill

Thanks for the responses. Our database is about 70meg and we have about 6 users, most do not use the database every day. Our free disk space is about 8gig on our 2000 server. Are the commands run from the \prog files\microsoft SQL Server\MSSQL\Binn prompt?

 

[ArtieChoke]

Use query analyzer. If you've installed the client tools, it will be on the start menu.

"I think we're all Bozos on this bus!" - Firesign Theatre