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 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?
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?

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 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?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?sql

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?

Log Shipping Jobs please help us (Urgent need)

Hi,
When i am changing Log Shipping job owner in Monitor server, stand by server
and primary server, i am getting error as "Error 14269:Job 'Log shipping
alert job-backup' is already targetted at server. xxxxxx(SQL Instance) The
Job was not saved.
please advise how to chnage the Job owners, if we are getting these errors.
Thanks,
John
All, i am working with MS Support now for this error. we analyzed due to
sp_add_job and other related stored procedures does not take instance name
more than 30 chars (our servers have more than 30 chars).
so when ever we are setting up Log shipping or replication, shall we need
our SQL Intance should be lesthan 30 character? my friend is telling for
Oracle databases they dont have any problem with intance name length.
hope this scenario may help someone in future.
good lcuk to all, John
"John" wrote:

> Hi,
> When i am changing Log Shipping job owner in Monitor server, stand by server
> and primary server, i am getting error as "Error 14269:Job 'Log shipping
> alert job-backup' is already targetted at server. xxxxxx(SQL Instance) The
> Job was not saved.
> please advise how to chnage the Job owners, if we are getting these errors.
> Thanks,
> John
|||John,
You could create aliases with shorter names. Open the client network
utility and go to Aliases.
M