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 |
|
AdiI
Starting Member
31 Posts |
 Posted - 2009-07-01 : 06:38:34
|
| Hello to alli have been facing a very serious problem. i'm oracle DBA i never work with SQL SERVER. i have deleted a database unintentionally. i have full backup 2 week ago. i did RND on net than i came to know transaction log. before going to actually corrupted database and restore it i have created a test database. create a table in it 2 or three record now i take backup and than create 2 more table and insert some record and delete db by right click management studio explorer. now i restore db with option Leave the database non-operational, and do not roll back the uncommitted transactions. Additional transaction logs can be restored. (RESTORE WITH NORECOVERY) my question is how to apply transaction log From previous backups of database it show blank From file or tape what file i select what is the backup log plz help if u need more information i will explain moreadeeladeel |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
|
|
|
how to recover deleted database