Log Shipping Sql server 2005 enterprise edition

require some urgent help on Sql Server 2005 Log Shipping
Our Project :
Seprate Read & Write Process by building Report Server using Sql
Server 2005 Log Shipping SQL Server 2005 Enterprise Edition installed on
Windows 2003 (64- bit) Server as Production server we had implemented Log
Shipping on the production server which will transfer logs after every 15 mi
n
to two Sql Server 2005 standby servers.(Windows 2003 64-bit). Both secondry
databases are in Standby / ReadOnly Mode .The system is working fine. All
logs are transffered sucessfully. we had tried online indexing on production
server which works fine.
Problem :--
Our main purpose of two standby server is 1st standby server will be
utilised as Report Server and 2nd standby Server we want to take full backup
everyday but when we try to take backup of 2nd standby server it give us
error like "cannot take backup the database is in warm standby mode".We
cannot take backup from Production server as it is required for online
indexing and data updation during night hrs.
OR
Is there any other way to take full backup from secondry servers?
We require help on following issues
1) How to take full backup of 2nd stand by server?
2) If Log shipping Failed How to restart Log Shipping without restoring a
new backup copy on secondry servers?
3) In this case how to make all server available with minimum downtime?
4) Is the process is Technically Perfect?I think you have a problem here.
Only way i can think of is .Stop the standy mode -recover the database with
last log file. And make a fullbackup.|||A database that is in STANDBY mode is technically in a RESTORING state with
a special stop point. You cannot back up a database while it is restoring.
Therefore, you cannot back up a log shipping target database.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"PankajP" <PankajP@.discussions.microsoft.com> wrote in message
news:49EB67A0-288F-4339-9F01-5EEBBB2CF86C@.microsoft.com...
> require some urgent help on Sql Server 2005 Log Shipping
> Our Project :
> Seprate Read & Write Process by building Report Server using Sql
> Server 2005 Log Shipping SQL Server 2005 Enterprise Edition installed on
> Windows 2003 (64- bit) Server as Production server we had implemented Log
> Shipping on the production server which will transfer logs after every 15
> min
> to two Sql Server 2005 standby servers.(Windows 2003 64-bit). Both
> secondry
> databases are in Standby / ReadOnly Mode .The system is working fine. All
> logs are transffered sucessfully. we had tried online indexing on
> production
> server which works fine.
> Problem :--
> Our main purpose of two standby server is 1st standby server will be
> utilised as Report Server and 2nd standby Server we want to take full
> backup
> everyday but when we try to take backup of 2nd standby server it give us
> error like "cannot take backup the database is in warm standby mode".We
> cannot take backup from Production server as it is required for online
> indexing and data updation during night hrs.
> OR
> Is there any other way to take full backup from secondry servers?
> We require help on following issues
> 1) How to take full backup of 2nd stand by server?
> 2) If Log shipping Failed How to restart Log Shipping without restoring a
> new backup copy on secondry servers?
> 3) In this case how to make all server available with minimum downtime?
> 4) Is the process is Technically Perfect?