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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-01-13 : 08:23:29
|
| Siva writes "How to backup the databsaes symultaneously using the backup options 1.database - complete 2. database - differential. So that the complete database backup can be stored in one area and the differential database backup can be stored in another area. The idea behind this is to backup the databases on day to day basis along with complete one untouched. This has to be done on a remote server.My version is sqlserver2000 with server pack 4.Please help me out.Thank" |
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2003-01-13 : 09:58:06
|
| If your databases are small enough to do a complete backup each day why do you need to do a differential one as well ? Why not just back it up to 2 different places.===========Paul |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-01-13 : 12:34:13
|
| Maybe I'm missing something here, but just have your backup commands point to two different locations. |
|
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2003-01-13 : 12:45:30
|
quote:
Maybe I'm missing something here, but just have your backup commands point to two different locations.
absolutely ,backup to two different places with different commands.waz up about sql server 2000 service pack 4???Expect the UnExpected |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-01-13 : 16:21:37
|
quote:
waz up about sql server 2000 service pack 4???
Maybe Siva has SQL 7.0 with sp4, but definitely not SQL2k with sp4. |
|
|
|
|
|
|
SQL server 2000 Databases Backup