noamco36
asked on
SQL Server DBA
Hello:
I have restored a database from a full backup and it restored just fine.
I can see the database and tables and data with in the table.
When I try to create a new Database diagram and select all the columns, it creates a diagram, BUT, the relationship lines between the tables do no show up.
Any idea how to get the lines to show?
Thank you,
Noa
I have restored a database from a full backup and it restored just fine.
I can see the database and tables and data with in the table.
When I try to create a new Database diagram and select all the columns, it creates a diagram, BUT, the relationship lines between the tables do no show up.
Any idea how to get the lines to show?
Thank you,
Noa
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
When will the lines appear in the diagram?
If the there PKs or FKs or Any Key?
If the there PKs or FKs or Any Key?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi jamesniox, thanks for checking back.
"Hi Noa,
Did you check if your relationships always exists between your tables?"
What I have is a full backup of the original db that came from a different server. when I restored it on my machine, I also generated a new diagram via SSMS and saw no FK relationship. that means that in the original database there were no relationships to begin with, correct?
Or could it be that whoever did the full backup on the original server somehow missed to include the FK relationships in the backup and this is why they restored as just indipendent (stand-alone) tables?
"Hi Noa,
Did you check if your relationships always exists between your tables?"
What I have is a full backup of the original db that came from a different server. when I restored it on my machine, I also generated a new diagram via SSMS and saw no FK relationship. that means that in the original database there were no relationships to begin with, correct?
Or could it be that whoever did the full backup on the original server somehow missed to include the FK relationships in the backup and this is why they restored as just indipendent (stand-alone) tables?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Yeh, the author... go figure who that is...
I was just told "here is the db , go figure it out."
Anyways, it looks like I will have to stick with no FK for now.
I was just told "here is the db , go figure it out."
Anyways, it looks like I will have to stick with no FK for now.
ASKER
the is what I have:
I received a SQL db full backup from offsite and restored it on my local machine.
Then I created the Database diagram in SSMS , but cant see any lines between the tables.
Could it be that the database/tables dont have relationships to begin with?
But this would not make sense, I mean who would create a database that has no relationships in its tables?