Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Zoma
Yak Posting Veteran
76 Posts |
 Posted - 2008-11-13 : 02:13:08
|
| Hi AllI am looking for clues from any one who can help or have ever had something like this.On our client which we are their IT Company..There is a live server which happens to be the main used server. There are about a list of 25 Databases in the Server and Running SQL 2005.There is also a "DBA Checklist" Database which was created by previous DBA's and now my manager just asked if i can be able to bring that Database up again. There are system stored procedures for sms's and staff... It was last updated about a year ago.. I want to bring this database up so i wont have to manually check all database status every morning atleast i can get a notification for Jobs or maintenance task that failed.Any one know where or sp's,triggers i can use to monitor all theses databases..get the space left or log files space...any Info i can get into this database so i can use it as my checklist.Please provide any information if any one has something or does something like this....That also can be a part of how good the DBA job is...By that my manager told me i may not have to come to work just to do the checklist only but get an notification..& Im sure also some DBA's here wish to have that kind of Database that automatically does the checklist for u which can also helps us for daily, weekly, monthly reports.ThanksThanks Team |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-11-13 : 04:39:29
|
| google for DBA checklists. that is enough for you.i didnot understand up the databse....you are saying that that is the production database and that was not in use for last one year. what is the meaning of up database? are you talking about the services? please let me know clearly.....are the services are running?are you expecting a checklist from us? or the way how to start using the database in production again?ArnavEven you learn 1%, Learn it with 100% confidence. |
 |
|
|
Zoma
Yak Posting Veteran
76 Posts |
Posted - 2008-11-13 : 05:29:21
|
| I want a way to start using the database in production again. I do have a daily checklist.The services dat runs are sql agent jobs which uses schedules,Like daily back ups and staff... I want this databse to record transactions that happens(failed,errors..space e.t.c) |
|
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-11-13 : 06:00:17
|
| then generate the script from the database and run as a new database (if u don't want the previous data). in your configuration files, change the accessing database to the new database.if you want the data also, i think you need not to do anything as your database is already available.ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
|
|
|
A Checklist Database!