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 |
|
mjeddi
Starting Member
5 Posts |
 Posted - 2005-03-02 : 11:36:14
|
| I have arcserve sql agent installed on a machine and from that machine I am making a full sql database backup which is lacted on remote sql server .The first full database backup is done on the C drive of that machine at 6:00 am the second full database is done on tape at 7:00 pm. Then starting from 8:00 AM I am making a differential backup on the C DRIVE each 60 min.My question is the differential backup is based on the full database backup on tape or on C drive? Thanks a lotMJeddi |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-03-02 : 12:27:50
|
| It's based on the last full backup so yes.As you should have found when you tested the restores.You do test the restores? If not then you don't know if any backups work so which the diffs are based on is less important.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Backups using SQL agent