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 |
|
franco
Constraint Violating Yak Guru
255 Posts |
Posted - 2001-10-02 : 04:46:25
|
| SQL 7.0 SP1.We do SQL Server backup and also third part backup (with SQL agent active) of SQL Server databases.Sometimes happen this situation:01.00 SQL Server backup of DB101.00 third part backup of DB1 02.00 SQL Server T-LOG backup of DB103.00 SQL Server T-LOG backup of DB103.30 SQL Server differnatial DB backup of DB104.00 SQL Server T-LOG backup of DB1or this situation:01.00 SQL Server backup of DB102.00 SQL Server T-LOG backup of DB103.00 SQL Server T-LOG backup of DB103.10 third part backup of DB1 03.30 SQL Server differnatial DB backup of DB104.00 SQL Server T-LOG backup of DB1My questions now are:Are my SQL Server backups valid (DB,Differenatial and T-LOG)? In case of a restore operation, can I use my SQL Server backups without problem?In other words, can we leave the third part backup tool active or it should be taken away?Can anybody clarify this for me?Thank you in advance.Franco |
|
|
|
|
|