| Author |
Topic |
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
 Posted - 2008-08-05 : 13:53:43
|
| Anyone using IPvault for sql server backup? I guess there is an option in IPVault for VSS backup(not sure). I want to know whether this VSS backup interferes with regular backup. For e.g. 1. Take the FULL backup from SSMS2. Take IPvault VSS full backup 3. If I start a SSMS log backup, what will be the starting point , point 1 or point 2? ------------------------I think, therefore I am - Rene Descartes |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-08-05 : 13:55:47
|
| Either full backup could be a starting point. You just need any full backup and then the transaction log chain since the one you picked. But you shouldnt't be backing up using two different programs.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2008-08-05 : 14:15:47
|
| I have a unique need where I need both backups. SQL as well as IPVault. What will happen in the following case?1. I take a SSMS FULL backup 2. I delete something – select * from t1 3. I take IPVault full backup 4. Take a SSMS log backupNow, the log backup contains command on step 2 or not?------------------------I think, therefore I am - Rene Descartes |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-08-05 : 14:18:45
|
| Let's say a system went production 5 years ago. You do full backups daily and tlog backups every hour. You've got every file available on disk or tape since 5 years ago. You find that all of your full backups are corrupt except the very first one from 5 years ago. But all of your transaction log backups are fine.You can restore the full backup from 5 years ago and then all of the transaction log backups since then as long as you aren't missing any transaction log backups. This is a stupid scenario as it is highly unlikely to ever happen, but it illustrates my point.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2008-08-05 : 14:30:00
|
| I got your point. Thanks. How ever I have a different quetion. If what you are saying is correct (which I am sure it is correct), what is the use of COPY_ONLY option of backup clause?------------------------I think, therefore I am - Rene Descartes |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-08-05 : 14:37:49
|
According to BOL:quote:
A copy-only backup does not affect your overall backup and restore procedures for the database.
quote:
The copy-only log backup has no effect on the log chain, and other log backups behave as if the copy-only backup does not exist.
Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2008-08-05 : 14:49:38
|
| Got it! Thanks. I have changed my question, and would like to know how it works for DIFF backup. 1. I take a SSMS FULL backup 2. I delete something – select * from t1 3. I take IPVault full backup 4. Take a SSMS DIFF backupNow, the diff backup contains changes made from command on step 2 or not?------------------------I think, therefore I am - Rene Descartes |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-08-05 : 14:53:29
|
| Differential backups do not affect the tlog chain. Differentials contain all of the changes since the last full backup, so in your scenario your diff does not contain step 2. Diffs are used so that you can restore less tlog backups in the case of a recovery.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2008-08-05 : 14:57:03
|
| Everything is clear! Thank you Tara. Just reached 1K posts!------------------------I think, therefore I am - Rene Descartes |
|
|
|
|
IPVault for sql server backup.