Ok I have 2 stand alone SQL Servers on Windows 2003 server. i have a
local user on both machines same username and password.
The user has the following on both servers.
act as operating system
logon as a batch job
logon as a service
When I run through the Database Maintenance Plan Wizard, at the last
screen when doing the steps I get the error.
Unable to copy the initialization file to the secondary server.
I have searched endlessly for the reason but have been unsuccessful.
Can anyone shed some light on what I could be missing.
Thanks.I think, your local accoutn not geeting acces the seconary mechines
folder. create a Mapped drive to the secondary server and try to copy
the backup.
pisquem@.gmail.com wrote:
> Ok I have 2 stand alone SQL Servers on Windows 2003 server. i have a
> local user on both machines same username and password.
> The user has the following on both servers.
> act as operating system
> logon as a batch job
> logon as a service
> When I run through the Database Maintenance Plan Wizard, at the last
> screen when doing the steps I get the error.
> Unable to copy the initialization file to the secondary server.
> I have searched endlessly for the reason but have been unsuccessful.
> Can anyone shed some light on what I could be missing.
> Thanks.|||I tried as you described and I was able to map a drive, connect to it
and copy the file over.
Any other ideas?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment