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 |
|
adam3291
Starting Member
8 Posts |
 Posted - 2002-02-12 : 08:52:02
|
| Hi,Will I screw up my restore process if I am doing full backups to both the local server and a remote server at different times during the day. For example, even hours I backup locally, odd hours remotely. Is this a safe practice?No logs, real small DB. Should I backup locally only and run a AT command to copy it remotely?Thanks |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2002-02-12 : 09:42:56
|
| You don't screw anything up, but you get different sets of backups... In other words, if you ever had to restore your data to the state it was in at around 9am you'd have to use your remote backup ('cause that's where odd hours are), but if you wanted 10am you could only restore from local (even hours). I'd suggest simply adding one extra step to the backup job to copy the backup device over to a remote location via DOS command. That way you know that you have the same set of backups both locally and remotely.Edited by - izaltsman on 02/12/2002 09:44:44 |
 |
|
|
|
|
|
Quick Backup/Restore Question