Database architecture

Hello,
I am new in database administration, I have a SQL 2000 database on server. I
need to see the architecture/design of the current running database. Is there
any tool or way to find or see the database architecture/design, so that I
can easily figure out the relations between different tables and understand
the database design.
Thanks in advance,
LeoUse "Create Database Diagram Wizard". Add all user tables into it, which will
give you a digramatic representation of the same. Hope this will help!!!
Thanks,
Sree
"Leo_Surf" wrote:
> Hello,
> I am new in database administration, I have a SQL 2000 database on server. I
> need to see the architecture/design of the current running database. Is there
> any tool or way to find or see the database architecture/design, so that I
> can easily figure out the relations between different tables and understand
> the database design.
> Thanks in advance,
> Leo|||Thanks Sree..
will I be able to see/understand database schema from the diagrams? or there
is any other way to do that? because in diagrams I am not able to see the
relationship betewwn the tables.
Thanks in advance...
Leo
"Sreejith G" wrote:
> Use "Create Database Diagram Wizard". Add all user tables into it, which will
> give you a digramatic representation of the same. Hope this will help!!!
> Thanks,
> Sree
> "Leo_Surf" wrote:
> > Hello,
> >
> > I am new in database administration, I have a SQL 2000 database on server. I
> > need to see the architecture/design of the current running database. Is there
> > any tool or way to find or see the database architecture/design, so that I
> > can easily figure out the relations between different tables and understand
> > the database design.
> >
> > Thanks in advance,
> > Leo|||Leo_Surf wrote:
> Thanks Sree..
> will I be able to see/understand database schema from the diagrams? or there
> is any other way to do that? because in diagrams I am not able to see the
> relationship betewwn the tables.
> Thanks in advance...
> Leo
>
The diagram should show relationships as long as the foreign keys
exist. Do they exist or are they missing from the diagram because they
aren't there? Use the Object Browser in Query Analyzer to check that
the foreign key constraints you expected are not missing.
Unfortunately Enterprise Manager's diagrams are extremely poor. They
don't use any of the proper notation for keys. They also don't easily
scale, print or embed in other documents. For any serious work you'll
want to consider using a different tool for diagrams such as Microsoft
Visio or ERwin.
--
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--

Database architecture

Hello,
I am new in database administration, I have a SQL 2000 database on server. I
need to see the architecture/design of the current running database. Is there
any tool or way to find or see the database architecture/design, so that I
can easily figure out the relations between different tables and understand
the database design.
Thanks in advance,
Leo
Use "Create Database Diagram Wizard". Add all user tables into it, which will
give you a digramatic representation of the same. Hope this will help!!!
Thanks,
Sree
"Leo_Surf" wrote:

> Hello,
> I am new in database administration, I have a SQL 2000 database on server. I
> need to see the architecture/design of the current running database. Is there
> any tool or way to find or see the database architecture/design, so that I
> can easily figure out the relations between different tables and understand
> the database design.
> Thanks in advance,
> Leo
|||Thanks Sree..
will I be able to see/understand database schema from the diagrams? or there
is any other way to do that? because in diagrams I am not able to see the
relationship betewwn the tables.
Thanks in advance...
Leo
"Sreejith G" wrote:
[vbcol=seagreen]
> Use "Create Database Diagram Wizard". Add all user tables into it, which will
> give you a digramatic representation of the same. Hope this will help!!!
> Thanks,
> Sree
> "Leo_Surf" wrote:
|||Leo_Surf wrote:

> Thanks Sree..
> will I be able to see/understand database schema from the diagrams? or there
> is any other way to do that? because in diagrams I am not able to see the
> relationship betewwn the tables.
> Thanks in advance...
> Leo
>
The diagram should show relationships as long as the foreign keys
exist. Do they exist or are they missing from the diagram because they
aren't there? Use the Object Browser in Query Analyzer to check that
the foreign key constraints you expected are not missing.
Unfortunately Enterprise Manager's diagrams are extremely poor. They
don't use any of the proper notation for keys. They also don't easily
scale, print or embed in other documents. For any serious work you'll
want to consider using a different tool for diagrams such as Microsoft
Visio or ERwin.
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx

Database architecture

Hello,
I am new in database administration, I have a SQL 2000 database on server. I
need to see the architecture/design of the current running database. Is ther
e
any tool or way to find or see the database architecture/design, so that I
can easily figure out the relations between different tables and understand
the database design.
Thanks in advance,
LeoUse "Create Database Diagram Wizard". Add all user tables into it, which wil
l
give you a digramatic representation of the same. Hope this will help!!!
Thanks,
Sree
"Leo_Surf" wrote:

> Hello,
> I am new in database administration, I have a SQL 2000 database on server.
I
> need to see the architecture/design of the current running database. Is th
ere
> any tool or way to find or see the database architecture/design, so that I
> can easily figure out the relations between different tables and understan
d
> the database design.
> Thanks in advance,
> Leo|||Thanks Sree..
will I be able to see/understand database schema from the diagrams? or there
is any other way to do that? because in diagrams I am not able to see the
relationship betewwn the tables.
Thanks in advance...
Leo
"Sreejith G" wrote:
[vbcol=seagreen]
> Use "Create Database Diagram Wizard". Add all user tables into it, which w
ill
> give you a digramatic representation of the same. Hope this will help!!!
> Thanks,
> Sree
> "Leo_Surf" wrote:
>|||Leo_Surf wrote:

> Thanks Sree..
> will I be able to see/understand database schema from the diagrams? or the
re
> is any other way to do that? because in diagrams I am not able to see the
> relationship betewwn the tables.
> Thanks in advance...
> Leo
>
The diagram should show relationships as long as the foreign keys
exist. Do they exist or are they missing from the diagram because they
aren't there? Use the Object Browser in Query Analyzer to check that
the foreign key constraints you expected are not missing.
Unfortunately Enterprise Manager's diagrams are extremely poor. They
don't use any of the proper notation for keys. They also don't easily
scale, print or embed in other documents. For any serious work you'll
want to consider using a different tool for diagrams such as Microsoft
Visio or ERwin.
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--

Database Administration/Maintenance - Guidance Needed

I have been working SQL server for many years as a web developer, however in my current position we are lacking an expert in maintenance and admninistration as the company has recently switched over to SQL Server 2005.

I therefore need to develop a greater understanding of the best practices with regards to administration and am a bit lost as there are so many options which seem like they might match my requirements. As I have never looked beyond the basic administration/maintenance side of things before I have no idea which options to investigate.

Basically I want to clear any records older than 3 months old on a scheduled/automatic basis. There seem to be various options that could do this, however I want to know what the best option is, rather than waste a lot of time and risk problems by resorting to trial and error.

We are already backing up this data, however I am not sure if I should combine these tasks. It is highly unlikely that we will ever have to restore these older records, however we do need to store the data for legal reasons.

I dont expect anyone to tell me everything, as I am happy to investigate, I just need a nudge in the right direction.

Thanks

maw

Hi there,

Do you have an easy way of distinguishing what records you want to delete (e.g. the records have a timestamp field associated with them)?

I would define a SQL Agent job that runs as per your desired schedule and executes some T-SQL that will delete the records as required.

In terms of backups, I would be tempted to take a "before" and "after" backup of the data. You can work the "before" backup into your regularly scheduled backup routine. For example (times are example only):

2:00am Regularly scheduled backup job runs and takes DB backup

2:30am Job to cull records older than 3 months fires & as part of the job execution, after all the cull logic has fired a BACKUP DATABASE statement is issued.

Thus, your job to cull records older than 3 months would look like:

/*
BEGIN: T-SQL statements for job
*/
-- Logic for deleting records
DELETE....
DELETE....

-- Backup after changes
BACKUP DATABASE Test_DB
TO DISK = 'C:\Backup_After_Delete.bak'
./*
END: T-SQL statements for job
*/

Hope that helps a bit, but sorry if it didn't
|||

Thanks Nate, thats exactly what I needed to know.

I had already read up a little bit on setting it up as a job, however I wasnt sure it was the best method.

I do have timestamp fields set up, so this should work perfectly.

Thanks again for your help.

Database Administration Survey

Hi,

We are a systems research group at the Computer Science department
at
Rutgers University, and are conducting a survey to understand details
about network, systems and database administration. We hope that this
information would help us recreate a realistic environment to help
research in 'systems management'.

We request network, systems, and database administrators to take this
survey. As an incentive, all surveys completed in their entirety will
be
entered into a drawing of a number of $50 gift certificates (from
Amazon.com).

We hope you have a few minutes to take the survey which is located at:

http://vivo.cs.rutgers.edu/administration_survey.html

Research in our group:
The goal of our research is to improve the overall availability and
maintainability of services. Since administrators form an integral part
of these services, a key aspect of this work is to build environments
and tools that ease the task of service administration. In particular,
environments which would help administrators know how their actions
might impact the real service (before performing them for real), we
believe would be useful in preventing inadvertent actions. This survey
tries to understand the existing environments, what administrators do
currently to test the 'validity' of their actions, and the difficulties
they face in doing so. The two specific systems we are looking at are
networks and databases, as we believe these are important components of
many services.

If you have any questions regarding this survey or our work, feel free
to email us:
Fabio Oliveira (fabiool at cs || rutgers || edu), or
Kiran Nagaraja (knagaraj at cs || rutgers || edu)

Thanks for your time,

Fabio Oliveira
PhD student, Vivo Research Group (http://vivo.cs.rutgers.edu)
Rutgers UniversityTo anyone who is wondering the survey is not very long and none of the
questions were dollar related, which was my first suspicion.

In my opinion the survey suffers from the flaw of allowing you to
identify several databases are in use in your shop, but does not allow
associating the answers/problems identified to any one database
product.

HTH -- Mark D Powell --|||"Mark D Powell" <Mark.Powell@.eds.com> wrote in message
news:1106753026.980765.309700@.z14g2000cwz.googlegr oups.com...
> To anyone who is wondering the survey is not very long and none of the
> questions were dollar related, which was my first suspicion.
> In my opinion the survey suffers from the flaw of allowing you to
> identify several databases are in use in your shop, but does not allow
> associating the answers/problems identified to any one database
> product.
> HTH -- Mark D Powell --

One of many flaws. Another is the same as with any of these surveys- it is
designed to support the solution under consideration.|||I did my part and participated.. Wondering what the results is...! Can
the creater update us on your statistics out of this survey???|||"QueryBuilder" <pg.242w@.gmail.com> wrote in message
news:1106769002.075423.231530@.c13g2000cwb.googlegr oups.com...
> I did my part and participated.. Wondering what the results is...! Can
> the creater update us on your statistics out of this survey???

Why are you asking me? Anyway, the answer was on the web site. If you left
your email address, you will get a copy of the results.