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.
| Author |
Topic |
|
AdamWest
Constraint Violating Yak Guru
360 Posts |
 Posted - 2010-10-15 : 09:29:54
|
| HI I have to make a copy of the diagram for the database.I can't make a backup copy because I can't detach the database.So I make a copy and import the data but import doesn't copy the diagram. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-10-15 : 15:11:20
|
| restore a backup to a different location ought to work |
 |
|
|
AdamWest
Constraint Violating Yak Guru
360 Posts |
Posted - 2010-10-15 : 15:24:06
|
| I am trying to make a backup but i get an error message"Failed set property devices" |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-10-15 : 15:27:40
|
| are u using the GUI?Try like this:BACKUP DATABASE yourDatabase TO DISK = 'FilePathHere'WITH init, stats; |
|
|
|
AdamWest
Constraint Violating Yak Guru
360 Posts |
Posted - 2010-10-15 : 15:41:14
|
Thanks i was not backing up bec. it was pointing to tape!What a dopey thing of me.quote:
Originally posted by russell
are u using the GUI?Try like this:BACKUP DATABASE yourDatabase TO DISK = 'FilePathHere'WITH init, stats;
|
|
|
|
|
|
|
How to make a copy of database diagrams schema?