Friday, March 30, 2012

log shipping without backing up and restoring the whole database

Hi,
We have specific problem here. We have very large database (1TB) on one
server, and we need to set up log shipping to another server. Problem is tha
t
we don't make regular sql server backups on the source server because of
obvious reason (it would take too long). Therefore we cannot restore databas
e
in standby mode on the standby server. The only way to do database restore i
n
our case is to use BCV software (disk subsystem on both servers is EMC), and
that software doesn't have option od leaving database in standby mode. My
question is "is there any way to put database into standby mode, regardless
that is hasn't been restored using sql server native restore procedure?".
Servers are sql server 2000, service pack 3.
ThanksEven if you could put it into Standby mode, you wouldnt be able to apply
additional changes without TLog backups. I dont know if there is an option o
f
new software or not? If so, I wrote my own Log Shipping using SQL Lite Speed
.
"Pedja" wrote:

> Hi,
> We have specific problem here. We have very large database (1TB) on one
> server, and we need to set up log shipping to another server. Problem is t
hat
> we don't make regular sql server backups on the source server because of
> obvious reason (it would take too long). Therefore we cannot restore datab
ase
> in standby mode on the standby server. The only way to do database restore
in
> our case is to use BCV software (disk subsystem on both servers is EMC), a
nd
> that software doesn't have option od leaving database in standby mode. My
> question is "is there any way to put database into standby mode, regardles
s
> that is hasn't been restored using sql server native restore procedure?".
> Servers are sql server 2000, service pack 3.
> Thankssql

No comments:

Post a Comment