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 - 2006-02-27 : 12:12:49
|
| yjpr writes "How do I refresh the another server from primary server periodically by applying transaction log after full database backup everyday night.I have following questions:1. My question is when I restore the database from primary server to secondary server every night using 'WITH MOVE', should I use 'WITH NORECOVERY' OR 'WITH RECOVERY' OR 'WITH STANDBY'2. Then when I apply the transaction log on secondary server from primary server every one hour gap, should I use 'WITH NORECOVERY' OR 'WITH RECOVERY' OR 'WITH STANDBY' I need to apply this transaction log from 7am until 9pm.Users need to use the server during applying the transaction log.I appreciate, if anyone can help me in this regard.Thanks,YJPR" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-02-27 : 13:10:47
|
| You'll use with WITH NORECOVERY or WITH STANDBY for the restore of the database and the tlogs. When you are finished applying the transaction logs, you specify WITH RECOVERY. If users need to access the secondary server, then WITH STANDBY is the only option. WITH STANDBY leaves the secondary database in read-only mode. Users will get disconnected though each time a restore is run.Tara Kizeraka tduggan |
 |
|
|
|
|
|
Log Shipping periodically to another server