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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Restore Database Diagrams

Author  Topic 

Ken Blum
Constraint Violating Yak Guru

383 Posts

Posted - 2005-05-03 : 15:05:54
To make a long story short, I did not realize that DTS did not transfer my database diagrams. After DTS'ing my entire database to another database, I deleted the original and detached/renamed files/attached the exported db to the original db name. Is there any way I can restore just the diagrams from backup?

TIA

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-05-03 : 17:43:43
No. You'll need to restore the entire database using a different name, then:

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q320125

Why not just use backup/restore or detach/attach instead of DTS?

Tara
Go to Top of Page

Ken Blum
Constraint Violating Yak Guru

383 Posts

Posted - 2005-05-04 : 07:51:42
Next time I will just do a backup. Thanks.
Go to Top of Page
   

- Advertisement -