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 |
|
gliffton
Starting Member
2 Posts |
 Posted - 2007-04-02 : 04:16:10
|
| Hi,I am trying to create a DRS for a SQL Server 2000 database in another city. We cannot do a replication at the moment, because the database design does not support it.Due to this we decided to take monthly full backups and end of each day differential backups. And then download the backup each night at the DRS site. The DBA in the main site, wants to do a daily full backup. As a result, if we want to restore a differential backup we are not able to do so without restoring the daily full backup. And it is not practical to transfer a 12 GB database backup daily.Please advise some solution to this problem. Thanks in advance.Cheers,Gliffton |
|
|
gliffton
Starting Member
2 Posts |
Posted - 2007-04-03 : 09:10:45
|
| Is log shipping the answer to this problem? Please suggest.Cheers,Gliffton |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-04-03 : 09:34:10
|
| I would be a bit concerned about only doing a FULL backup monthly ... if that is not readily recoverable you can't get to any of the following differential backups ...However, I expect that Log Shipping may be a better answer anyway. So long as you do not have any massive TLog backups caused by, say, Database Maintenance RoutinesKristen |
|
|
|
|
|
|
Backup Plan Problem