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 |
|
mahajanakhil1985
Yak Posting Veteran
71 Posts |
 Posted - 2010-08-30 : 09:47:26
|
| I have a situation where my database is in 'restoring' state and I want to recover and bring it online without applying additional backups. It could mean that the database becomes functional by rolling back transactions ,if any, without asking for addtional backups to be applied.I am not very familiar with transact SQL, so I am trying to explore doing such a thing using Management Studio. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-08-30 : 11:51:09
|
| restore database databaseName with recovery |
 |
|
|
|
|
|
recover database in sql server