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 |
|
ksr39
Posting Yak Master
193 Posts |
 Posted - 2014-10-22 : 12:23:01
|
| Hi All,I need a small clarification, one of my databases backup was overwritten on the existing database backup, the script it was with NOINIT and the backup was overwritten twice, is there any way we can restore one from that backup file.Please suggest.Thank You All In AdvanceKRS39 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-10-22 : 12:38:21
|
| If NOINIT is specified, then the backups have been appended. You can restore using the FILE option. Please see the documentation for details.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
ksr39
Posting Yak Master
193 Posts |
Posted - 2014-10-22 : 12:57:04
|
| Thank you Kizer,i did the same i used restore files...i was in stress and couldn't recollect this option in mind.Thank you once again.Thank You All In AdvanceKRS39 |
|
|
|
|
|
|
Database Backup