Friday, March 23, 2012

log shipping problem

I have 2 server 1 primary 2nd secondary
I have configured log shipping on them'
Now everything works fine, no errors any where bt file is not copied in the
secondary server folder.
any if I run the copy job on secondary server it gives following output
output
----
----
----
--
NULL
Microsoft (R) SQLMaint Utility (Unicode), Version 8.00.760
Copyright (C) Microsoft Corporation, 1995 - 1998
NULL
Logged on to SQL Server 'DB_OLD'
as 'DB_OLD\sqlservice' (trusted)
NULL
NULL
Starting copy for plan 10.11.11.11.CCM_logshipping
NULL
Source database - CCM
Copied 0 files
NULL
Finished copy for plan 10.11.11.11.CCM_logshipping
I have configure a/c on both server, a/c are local account under which sql
agent and server runs
Please let me know what can be the problem.Hi,
I think this is mainly access permisssion issue.
May user of primary server don't have access to write in secondary
server.
Regards,
Sajid C.
VSS wrote:
> I have 2 server 1 primary 2nd secondary
> I have configured log shipping on them'
> Now everything works fine, no errors any where bt file is not copied in th
e
> secondary server folder.
> any if I run the copy job on secondary server it gives following output
> output
> ----
--
> ----
--
> ----
--
> --
> NULL
> Microsoft (R) SQLMaint Utility (Unicode), Version 8.00.760
> Copyright (C) Microsoft Corporation, 1995 - 1998
> NULL
> Logged on to SQL Server 'DB_OLD'
> as 'DB_OLD\sqlservice' (trusted)
> NULL
> NULL
> Starting copy for plan 10.11.11.11.CCM_logshipping
> NULL
> Source database - CCM
> Copied 0 files
> NULL
> Finished copy for plan 10.11.11.11.CCM_logshipping
> I have configure a/c on both server, a/c are local account under which sql
> agent and server runs
> Please let me know what can be the problem.

No comments:

Post a Comment