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.
Showing posts with label secondaryi. Show all posts
Showing posts with label secondaryi. Show all posts
Friday, March 23, 2012
log shipping problem
Subscribe to:
Posts (Atom)