|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Tracking Databases On a Server/Instancedevelopers can send me a request, and I create them a blank database and administer it, perform backups etc. The users can add tables, views, data, etc. I want to automate a tool to track all the databases on the server. When a database is created, I want to what developer requested, how big they said it would be, and when they will be done with it so I can clean up the disk space. What I would like to do is automate this and make sure we have this information stored somewhere before any new database is requeted. I was wondering how to do this possibly using a DDL trigger. I want to force users to provide that information before they can create a database and have it logged into a table somewhere. Any ideas/help? I can't purchase any third party tools for this. Thanks, Jason -- Jason JasonDWilson wrote:
Show quote > I am a DBA and have a development DB server (SQL Server 2005) where I have a script that will help automate the backup of these databases.> developers can send me a request, and I create them a blank database and > administer it, perform backups etc. The users can add tables, views, data, > etc. I want to automate a tool to track all the databases on the server. > When a database is created, I want to what developer requested, how big they > said it would be, and when they will be done with it so I can clean up the > disk space. What I would like to do is automate this and make sure we have > this information stored somewhere before any new database is requeted. I > was wondering how to do this possibly using a DDL trigger. I want to force > users to provide that information before they can create a database and have > it logged into a table somewhere. Any ideas/help? I can't purchase any > third party tools for this. > > Thanks, > > Jason > My site is currently being rebuilt, but you can get the script from Google's cache by searching for "automaticbackupofalldatabases" Sounds like a procedural issue rather than a tools issue; are you the
only sysadmin on the box? If not, lock it down so no one can create a database. Then, make a small paper form (or you can create a database to do this) that outlines the requirements your developers need. Don't create a database until that request is filled out. Am I missing something? Stu JasonDWilson wrote: Show quote > I am a DBA and have a development DB server (SQL Server 2005) where > developers can send me a request, and I create them a blank database and > administer it, perform backups etc. The users can add tables, views, data, > etc. I want to automate a tool to track all the databases on the server. > When a database is created, I want to what developer requested, how big they > said it would be, and when they will be done with it so I can clean up the > disk space. What I would like to do is automate this and make sure we have > this information stored somewhere before any new database is requeted. I > was wondering how to do this possibly using a DDL trigger. I want to force > users to provide that information before they can create a database and have > it logged into a table somewhere. Any ideas/help? I can't purchase any > third party tools for this. > > Thanks, > > Jason > > -- > Jason I would recommend looking at using Extended Properties on the database to
hold that information. If you are using SQL Server 2005, you could use DDL triggers to populate much of the information automatically or just incorporate updates to the extended properties into your automation scripts. -- Show quoteThis posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm "JasonDWilson" <JasonDWil***@discussions.microsoft.com> wrote in message news:72B7A2EA-ED3D-4F97-A712-1602929AE120@microsoft.com... >I am a DBA and have a development DB server (SQL Server 2005) where > developers can send me a request, and I create them a blank database and > administer it, perform backups etc. The users can add tables, views, > data, > etc. I want to automate a tool to track all the databases on the server. > When a database is created, I want to what developer requested, how big > they > said it would be, and when they will be done with it so I can clean up the > disk space. What I would like to do is automate this and make sure we > have > this information stored somewhere before any new database is requeted. I > was wondering how to do this possibly using a DDL trigger. I want to > force > users to provide that information before they can create a database and > have > it logged into a table somewhere. Any ideas/help? I can't purchase any > third party tools for this. > > Thanks, > > Jason > > -- > Jason  |
|||||||||||||||||||||||
Other interesting topics