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 |
|
Lorna70
Starting Member
19 Posts |
 Posted - 2010-02-26 : 05:40:54
|
| I have restored a database onto my new laptop. It restored successfully but when I attempted to create a new DB diagram it came up with an error and suggested I go into Database Properties and set the owner to a user. I did this and straight away the whole DB went into recovery mode. The exact same happened when I followed the same procedure on another laptop. Why should this occur?? |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-02-26 : 08:09:28
|
Did you restore it with NORECOVERY option?If so it is waiting for you to restore additional files  You can tell it that you have finished / no more files withRESTORE DATABASE MyDatabaseName WITH RECOVERY |
 |
|
|
Lorna70
Starting Member
19 Posts |
Posted - 2010-02-26 : 09:23:27
|
| Well it all installed successfully - it was only later when I attempted to create a new diagram and it said I had to set the owner of the DB. |
|
|
|
|
|
|
Database (in recovery) when adding an owner