|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Administrative TasksHi
Can somebody please point me to good URL or may be some scripts that I can use to execute as part of DB health check. Also, I would like to see if the DB is well designed or thought of while it was created; I know its a wide subject, but I will be happy to get started with some script that you guys have been using in your environment. TIA PP Hi
You may want to read up on maintenance plans in Books online along with other procedures such as the DBCC commands. Also check out the article http://www.sqlservercentral.com/columnists/awarren/sqlmaintenanceplans.asp s well as the other scripts/articles on this site. If you want to do things yourself you may want to look at what the expressmaint procedure at http://www.sqldbatips.com/code.asp does. John Show quote "PP" wrote: > Hi > > Can somebody please point me to good URL or may be some scripts that I can > use to execute as part of DB health check. > Also, I would like to see if the DB is well designed or thought of while it > was created; I know its a wide subject, but I will be happy to get started > with some script that you guys have been using in your environment. > > TIA > PP SQL Server 2000 Administrator's Pocket Consultant
http://www.microsoft.com/technet/prodtechnol/sql/2000/books/pkadmindefault.mspx SQL Server 2000 Operations Guide http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlops0.mspx SQL Server 2000 Resource Kit http://www.microsoft.com/technet/prodtechnol/sql/2000/reskit/default.mspx Microsoft SQL Server Developer Center - Architecture and Design http://msdn.microsoft.com/sql/learn/arch/ SQL-Server-Performance.Com http://www.sql-server-performance.com/ Show quote "PP" <P*@discussions.microsoft.com> wrote in message news:AA0FF976-9140-42B6-BDF4-8A741D03DAF5@microsoft.com... > Hi > > Can somebody please point me to good URL or may be some scripts that I can > use to execute as part of DB health check. > Also, I would like to see if the DB is well designed or thought of while > it > was created; I know its a wide subject, but I will be happy to get started > with some script that you guys have been using in your environment. > > TIA > PP  |
|||||||||||||||||||||||
Other interesting topics