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 |
|
jimmy
Starting Member
9 Posts |
 Posted - 2002-07-04 : 05:10:16
|
| Hi, I'm new in sql server...i try to restore a database but half-wayi cancel it. now it in (loading) status, how to resolve it. Thanks for advice, is urgent. |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2002-07-04 : 06:09:27
|
| Finish restoring it.... Run your restore again.You have left the database in a suspect state, it will be trying to rollback the restore...PeaceRick |
 |
|
|
¢ödêmån
Starting Member
32 Posts |
Posted - 2002-07-04 : 08:10:24
|
| If it will not let you restore back to it, you may have to change the status.e.g.EXEC sp_resetstatus 'PUBS'see sp_resetstatus BOL.if you need further help pls post.cheers,--¢ödêmån-- |
|
|
|
jimmy
Starting Member
9 Posts |
Posted - 2002-07-04 : 21:05:35
|
| Thanks for help, i restore again and it completed.Thank you. |
|
|
|
jimmy
Starting Member
9 Posts |
Posted - 2002-07-04 : 21:21:21
|
| Thanks for help, i restore again and it completed.Thank you. |
|
|
|
|
|
|
HELP - restore problem