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 |
|
Da_Retina
Posting Yak Master
109 Posts |
 Posted - 2002-01-10 : 05:47:41
|
| Salute...I read in a recent post that the following statement:RESTORE DATABASE MyNwind WITH RECOVERYcan restore a database that has not been backed up!..how could that be possible?I deleted a test database that was an attached file from the beginning and used the the recovry statement but with no use..which is VERY logical!..I mean I DELETED the file..from WHERE should the DBMS restore or retrieve the data?..anyone, any clue???Peace!... |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-01-10 : 08:17:15
|
| Retina , i would suggest if you have any doubt in a particular post. raise your doubts in the same post. Dont Start a New thread ,if what you are asking is Not going to disturb the original post or its not very different from the original.check back the original post .http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=11971----------------------------Anything that Doesn't Kills you Makes you Stronger |
 |
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2002-01-10 : 08:19:56
|
| What you read in the recent post if it's the same one i read !? refers to this.... from books on-line....Recovering a Database Without RestoringThe operation of rolling back all uncompleted transactions and rolling forward all completed transactions is called recovery and is required to restore the integrity of the database. Restoring a database backup or applying a transaction log backup recovers the database automatically at the end of the restore operation. Additionally, recovery occurs in a database each time the database is opened, for example when Microsoft® SQL Server™ starts.You may need to recover a database manually when: A standby server has been kept up-to-date with a production server by loading a series of transaction log backups from the production server. To bring the standby online, recover the database. You attempt to recover a suspect database. |
|
|
|
|
|
|
RESTORE wtih NO BACKUP!