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-05-19 : 07:24:46
|
| Guill writes "Hello:I would like to give you some background information:Let’s suppose I have my stand by server that works only as a remote backup server, but it does not have the capacity to work as a productive system which maybe is a SAP system. Thinking about the remote backup is mandatory; I would have the following questions:1. I have set up log shipping in two sql servers, and I would like to know if it is possible, in any way, to backup the source database (full backup, truncating or without truncating the log) without lose synchronization?2. If (1.) were possible, is it possible to recover the database and apply transactions logs generated automatically by the log shipping after the full backup?Best regards,Guillermo" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-05-19 : 12:44:29
|
| Yes you can perform a full backup of the source database but you cannot perform a transaction log backup. If you perform a transaction log backup then you are going to cause log shipping to fail.2. is true as well. You do not have to use transaction logs to recover the database. But if you want to apply transaction logs, then you cannot use the full backup from 1. above. You will need to use the full backup that is created by the log shipping job. You then would need to apply the logs that were created after this backup.Tara |
 |
|
|
|
|
|
SQL log shipping