t for one thing. The T-Log Restore to the Standby server fails everytime.
Everyone has full permissions to it and I am using the Network Admin account
to transfer and restore.
Has anyone had any similar issues and might have any solutions? Thank you.What error do you receive?
For log shipping to work properly you have to first restore the database =
WITH STANDBY
You then restore your logs
The (destination) database cannot be in use when the log is applied.
Refer to http://sqlguy.home.comcast.net/logship.htm for more =
information.
--=20
Keith
"Don" <donolwert@.hotmail.com> wrote in message =
news:5A8317ED-4B10-41B5-981E-A35F6008C319@.microsoft.com...
quote:
> I have log shipping setup b/t 2 servers and everything is working fine =
except for one thing. The T-Log Restore to the Standby server fails =
everytime. Everyone has full permissions to it and I am using the =
Network Admin account to transfer and restore. Has anyone had any =
similar issues and might have any solutions? Thank you.|||Thanks for responding. There error message I am getting is as follows:
Executed as user: FS-SA\fssaadmin. sqlmaint.exe failed. [SQLSTATE 42000] (Er
ror 22029). The step failed.
I verified and made sure I restored the DB in Standby mode as well. Permiss
ions should be fine as the user fssaadmin is our Domain Admins account.
I also switched the Database to Single-User mode and then ran the restore jo
b but am still getting the error. Thanks for any help.
Don
-- Keith Kratochvil wrote: --
What error do you receive?
For log shipping to work properly you have to first restore the database WIT
H STANDBY
You then restore your logs
The (destination) database cannot be in use when the log is applied.
Refer to http://sqlguy.home.comcast.net/logship.htm for more information.
Keith
"Don" <donolwert@.hotmail.com> wrote in message news:5A8317ED-4B10-41B5-981E-A35F6008C319@.microsoft
.com...
quote:
> I have log shipping setup b/t 2 servers and everything is working fine except for one thin
g. The T-Log Restore to the Standby server fails everytime. Everyone has full permissions
to it and I am using the Network Admin account to transfer and res
tore. Has anyone had any similar issues and might have any solutions? Than
k you.|||Can you run the appropriate T-SQL (restore database and restore log) =
commands within Query Analyzer on the target server when connected as =
sa? Does it work?
You may find some helpful infomation within Tibor Karaszi's post:
http://groups.google.com/groups?hl=...=3DUTF-8&threa=
dm=3D08ea01c18440%249e9828f0%2439ef2ecf%
40TKMSFTNGXA08&rnum=3D1&prev=3D/g=
roups%3Fhl%3Den%26lr%3D%26ie%3DUTF-8%26oe%3DUTF-8%26q%3DError%2B22029%26b=
tnG%3DGoogle%2BSearch%26meta%3Dgroup%253
Dmicrosoft.public.sqlserver.*
or
http://tinyurl.com/3f4e4
--=20
Keith
"Don" <donolwert@.hotmail.com> wrote in message =
news:6DF3AC39-C30A-4DBA-9438-C2CA32758BB7@.microsoft.com...
quote:
> Thanks for responding. There error message I am getting is as =
follows:
quote:
> =20
> Executed as user: FS-SA\fssaadmin. sqlmaint.exe failed. =
[SQLSTATE 42000] (Error 22029). The step failed.
quote:
>=20
> I verified and made sure I restored the DB in Standby mode as well. =
Permissions should be fine as the user fssaadmin is our Domain Admins =
account.
quote:
>=20
> I also switched the Database to Single-User mode and then ran the =
restore job but am still getting the error. Thanks for any help.
quote:
>=20
> Don
>=20
> =20
> -- Keith Kratochvil wrote: --
> =20
> What error do you receive?
> =20
> For log shipping to work properly you have to first restore the =
database WITH STANDBY
quote:
> =20
> You then restore your logs
> =20
> The (destination) database cannot be in use when the log is =
applied.
quote:
> Refer to http://sqlguy.home.comcast.net/logship.htm for more =
information.
quote:
> =20
> --=20
> Keith
> =20
> =20
> "Don" <donolwert@.hotmail.com> wrote in message =
news:5A8317ED-4B10-41B5-981E-A35F6008C319@.microsoft.com...
quote:|||Keith, Thank you for all your help. I discovered what the issue is...McAfee
working fine except for one thing. The T-Log Restore to the Standby =
server fails everytime. Everyone has full permissions to it and I am =
using the Network Admin account to transfer and restore. Has anyone had =
any similar issues and might have any solutions? Thank you.[QUOTE]
>
. I uninstalled McAfee and everything ran perfectly. Thank you.
-- Keith Kratochvil wrote: --
Can you run the appropriate T-SQL (restore database and restore log) command
s within Query Analyzer on the target server when connected as sa? Does it
work?
You may find some helpful infomation within Tibor Karaszi's post:
http://groups.google.com/groups?hl=...53D
micr
osoft.public.sqlserver.*
or
http://tinyurl.com/3f4e4
Keith
"Don" <donolwert@.hotmail.com> wrote in message news:6DF3AC39-C30A-4DBA-9438-C2CA32758BB7@.microsoft
.com...
quote:
> Thanks for responding. There error message I am getting is as follows:
> Refer to http://sqlguy.home.comcast.net/logship.htm for more informat
ion.
> Keith
store. Has anyone had any similar issues and might have any solutions? Thank you.[QUOTE][color=d
arkred]
>
No comments:
Post a Comment