Database Diagram

Hi,
I created a database with diagram in ServerA. After that I backup and
restore this database in ServerB. I try to open the database diagram in
ServerB, but it show empty. Is there anyone know why like that?
Thanks,
KennyKenny
If I remember well a diagram is stored in dtproperties system table. Try
transfer the table into the new server.
"Kenny" <keejh@.hotmail.com> wrote in message
news:uvKbXSTdEHA.2520@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I created a database with diagram in ServerA. After that I backup and
> restore this database in ServerB. I try to open the database diagram in
> ServerB, but it show empty. Is there anyone know why like that?
> Thanks,
> Kenny
>|||did you backup and restore the transaction log?
Another way is to detach the database from one server, copy it to the new
one, then attach the database to the new server
aoxpsql
"Kenny" <keejh@.hotmail.com> wrote in message
news:uvKbXSTdEHA.2520@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I created a database with diagram in ServerA. After that I backup and
> restore this database in ServerB. I try to open the database diagram in
> ServerB, but it show empty. Is there anyone know why like that?
> Thanks,
> Kenny
>|||Hi,
Use the below link to transfer diagrams between servers.
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q320125
It is just copying the contents of dtproperties from source server to
destination as pointed by Uri. Since you the restored the same database, the
contents will be already there in destination.
Probably you have to delete the contents before you folow the link mentioned
above.
Thanks
Hari
MCDBA
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:u8xwqWTdEHA.3260@.TK2MSFTNGP09.phx.gbl...
> Kenny
> If I remember well a diagram is stored in dtproperties system table. Try
> transfer the table into the new server.
> "Kenny" <keejh@.hotmail.com> wrote in message
> news:uvKbXSTdEHA.2520@.TK2MSFTNGP12.phx.gbl...
> > Hi,
> >
> > I created a database with diagram in ServerA. After that I backup and
> > restore this database in ServerB. I try to open the database diagram in
> > ServerB, but it show empty. Is there anyone know why like that?
> >
> > Thanks,
> > Kenny
> >
> >
>|||Detach / Attach the database also having the same problem ...
"aoxpsql" <anonymous@.discussion.com> wrote in message
news:OcZnytTdEHA.1356@.TK2MSFTNGP09.phx.gbl...
> did you backup and restore the transaction log?
> Another way is to detach the database from one server, copy it to the new
> one, then attach the database to the new server
> aoxpsql
>
> "Kenny" <keejh@.hotmail.com> wrote in message
> news:uvKbXSTdEHA.2520@.TK2MSFTNGP12.phx.gbl...
> > Hi,
> >
> > I created a database with diagram in ServerA. After that I backup and
> > restore this database in ServerB. I try to open the database diagram in
> > ServerB, but it show empty. Is there anyone know why like that?
> >
> > Thanks,
> > Kenny
> >
> >
>