LogShipping

Hi all I have created a log shipping task in my SQL servers
This Is the server order
Ist Server (Win2003 , SQL 2000 sp3) is the data server let's say
2nd Server (win2003 , SQL 2000 sp3) Is the monitor server
3rd Server (win2000, SQL 2000 sp3) Is the server that accepts the data
(1st & 2nd server is a clucter system )
And the line Connecting 1st & 2nd Server with the 3rd server is 1MB
The problem now is that the SQL Help is awful about logshipping. It explains
nothing!!
I have Create the log shipping but i get en error that the databases are not
sync.
And the FileLoaded and file copped is stack on First_File...trn
And also my databades seemed to be in sync
What Is wrong'
What should I do'
Please HELP!!!
Thanks in advance
DimitrisHi,
I have to correct you on something...there is plenty of
documentation for log shipping!
Try looking at BOL and this link will help. You should
read before implementing.
http://support.microsoft.com/?id=323135
hth
DeeJay
>--Original Message--
>Hi all I have created a log shipping task in my SQL
servers
>This Is the server order
>Ist Server (Win2003 , SQL 2000 sp3) is the data server
let's say
>2nd Server (win2003 , SQL 2000 sp3) Is the monitor server
>3rd Server (win2000, SQL 2000 sp3) Is the server that
accepts the data
>(1st & 2nd server is a clucter system )
>And the line Connecting 1st & 2nd Server with the 3rd
server is 1MB
>The problem now is that the SQL Help is awful about
logshipping. It explains
>nothing!!
>I have Create the log shipping but i get en error that
the databases are not
>sync.
>And the FileLoaded and file copped is stack on
First_File...trn
>And also my databades seemed to be in sync
>What Is wrong'
>What should I do'
>Please HELP!!!
>Thanks in advance
>Dimitris
>
>
>.
>

Logon failed during timed subscriptions

Hello,
Environment: Win2003 server SP1, IIS 6.0, SQL Server 2000 SP4, Reporting
services 2000 SP2.
Reporting services using account of sql server authentycation with logon
name of 'sa' and password.
Executing reports from manager working fine, but timed subscriptions failing
on execution with the following error: 'Logon failed'.
RS log file has the following messages:
e!notification!1094!05/11/2007-03:23:05:: e ERROR: Error occured processing
notification. Logon failed.
ReportingServicesService!notification!1094!05/11/2007-03:23:05::
Notification 63d3f301-ff48-4fc2-9697-578eaf02d5da completed. Success: False,
Status: Logon failed., DeliveryExtension: Report Server Email, Report: Batch
Inventory-tmp, Attempt 0
ReportingServicesService!dbpolling!1094!05/11/2007-03:23:05::
NotificationPolling finished processing item
63d3f301-ff48-4fc2-9697-578eaf02d5da
ReportingServicesServic
Dears, what caused notification problems:
is it problems with scheduled jobs or is it authentycation problems with SMTP?
How to see (or somehow extract) more detailed log from RS?
Thanks,
Andrius.Update:
Reporting services Unattended Execution Account using sql server
authentycation method with logon name of 'sa' and password.
"Andrius" wrote:
> Hello,
> Environment: Win2003 server SP1, IIS 6.0, SQL Server 2000 SP4, Reporting
> services 2000 SP2.
> Reporting services using account of sql server authentycation with logon
> name of 'sa' and password.
> Executing reports from manager working fine, but timed subscriptions failing
> on execution with the following error: 'Logon failed'.
> RS log file has the following messages:
> e!notification!1094!05/11/2007-03:23:05:: e ERROR: Error occured processing
> notification. Logon failed.
> ReportingServicesService!notification!1094!05/11/2007-03:23:05::
> Notification 63d3f301-ff48-4fc2-9697-578eaf02d5da completed. Success: False,
> Status: Logon failed., DeliveryExtension: Report Server Email, Report: Batch
> Inventory-tmp, Attempt 0
> ReportingServicesService!dbpolling!1094!05/11/2007-03:23:05::
> NotificationPolling finished processing item
> 63d3f301-ff48-4fc2-9697-578eaf02d5da
> ReportingServicesServic
> Dears, what caused notification problems:
> is it problems with scheduled jobs or is it authentycation problems with SMTP?
> How to see (or somehow extract) more detailed log from RS?
> Thanks,
> Andrius.
>