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 |
|
Teretrus
Starting Member
4 Posts |
 Posted - 2008-03-22 : 08:06:46
|
| I've restored a database by the standard menu (the backup was a .bak file).It worked really well, but now I can't use the database, but there is a "(Restoring...)" standing to the right of the database-name in the sql server management studio. I thought it should work like this and therefore was sitting and waiting, but hous later the status didn't change.What shell I do? |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2008-03-22 : 09:51:38
|
| How big was the backup?Mike"oh, that monkey is going to pay" |
 |
|
|
Teretrus
Starting Member
4 Posts |
Posted - 2008-03-22 : 11:20:39
|
| About 2 gbBy the way, it is still "Restoring..."That means... the script ran, but the database is unavailable |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-22 : 11:30:59
|
| Did you do with T-SQL or GUI?you should % of database being restored. |
|
|
|
Teretrus
Starting Member
4 Posts |
Posted - 2008-03-22 : 11:47:45
|
| I did it by gui, and it processed perfectly until 100%. Then it showed me a message that it finished and I was shown the main window of sql server management studio again where my restored database was now listed under the menu databases, but not expandable and with a "(Restoring...)" behind the name. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-22 : 11:52:58
|
| It's because you restored with norecovery option so that you can apply transaction log. If you don't have any,reapply same process but with First option choosen |
|
|
|
Teretrus
Starting Member
4 Posts |
Posted - 2008-03-22 : 14:11:34
|
| Thanks a lot... it works |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-22 : 16:21:45
|
| In fact you don't have to redo restore, only need run 'restore database db_name with recovery'. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-22 : 17:46:18
|
| That is what i mean. |
|
|
|
|
|
|
RESTORE takes hours..