error '80020009' HELP!

error '800200009' HELP!!!
I am new to this forum and am looking for help...
I inherited a Win NT4.0 server that is serving up MS SQL 7. It will
eventually be replaced, now that I have responsibility for the machine. But
in the meantime...I am getting the following error message from some users
when they try to access the database through a web browser.
error '80020009'
Exception occurred.
/include_files/mimpo/VBSFunctions.inc, line 61
This error appeared a while back, and the machine arrived in my area with
the error. I am new to SQL and am seeking help.
All present users within the machine have access to the database via their
web browsers. It is when I create a new user, that this error appears. Any
ideas?
If I restore the database from a backup when the error was not occurring,
would this elimate the error, and allow me to create new users that can
access the database successfully?
Or is there another method that I can use, without loosing two months of
info by performing a database restore?
Any help with this matter would really be great!!!
thanks,
scott
Hi
Check your SQL Server event logs for any problems.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"s-jeff" <s-jeff@.discussions.microsoft.com> wrote in message
news:C2B03635-F38F-4DC0-8092-90B388A41712@.microsoft.com...
> error '800200009' HELP!!!
> I am new to this forum and am looking for help...
> I inherited a Win NT4.0 server that is serving up MS SQL 7. It will
> eventually be replaced, now that I have responsibility for the machine.
But
> in the meantime...I am getting the following error message from some users
> when they try to access the database through a web browser.
> error '80020009'
> Exception occurred.
> /include_files/mimpo/VBSFunctions.inc, line 61
>
> This error appeared a while back, and the machine arrived in my area with
> the error. I am new to SQL and am seeking help.
> All present users within the machine have access to the database via their
> web browsers. It is when I create a new user, that this error appears. Any
> ideas?
> If I restore the database from a backup when the error was not occurring,
> would this elimate the error, and allow me to create new users that can
> access the database successfully?
> Or is there another method that I can use, without loosing two months of
> info by performing a database restore?
> Any help with this matter would really be great!!!
> thanks,
> scott
>

error '80020009' HELP!

error '800200009' HELP!!!
---
I am new to this forum and am looking for help...
I inherited a Win NT4.0 server that is serving up MS SQL 7. It will
eventually be replaced, now that I have responsibility for the machine. But
in the meantime...I am getting the following error message from some users
when they try to access the database through a web browser.
error '80020009'
Exception occurred.
/include_files/mimpo/VBSFunctions.inc, line 61
This error appeared a while back, and the machine arrived in my area with
the error. I am new to SQL and am seeking help.
All present users within the machine have access to the database via their
web browsers. It is when I create a new user, that this error appears. Any
ideas?
If I restore the database from a backup when the error was not occurring,
would this elimate the error, and allow me to create new users that can
access the database successfully?
Or is there another method that I can use, without loosing two months of
info by performing a database restore?
Any help with this matter would really be great!!!
thanks,
scottHi
Check your SQL Server event logs for any problems.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"s-jeff" <s-jeff@.discussions.microsoft.com> wrote in message
news:C2B03635-F38F-4DC0-8092-90B388A41712@.microsoft.com...
> error '800200009' HELP!!!
> ---
> I am new to this forum and am looking for help...
> I inherited a Win NT4.0 server that is serving up MS SQL 7. It will
> eventually be replaced, now that I have responsibility for the machine.
But
> in the meantime...I am getting the following error message from some users
> when they try to access the database through a web browser.
> error '80020009'
> Exception occurred.
> /include_files/mimpo/VBSFunctions.inc, line 61
>
> This error appeared a while back, and the machine arrived in my area with
> the error. I am new to SQL and am seeking help.
> All present users within the machine have access to the database via their
> web browsers. It is when I create a new user, that this error appears. Any
> ideas?
> If I restore the database from a backup when the error was not occurring,
> would this elimate the error, and allow me to create new users that can
> access the database successfully?
> Or is there another method that I can use, without loosing two months of
> info by performing a database restore?
> Any help with this matter would really be great!!!
> thanks,
> scott
>

error '80020009' HELP!

error '800200009' HELP!!!
---
I am new to this forum and am looking for help...
I inherited a Win NT4.0 server that is serving up MS SQL 7. It will
eventually be replaced, now that I have responsibility for the machine. But
in the meantime...I am getting the following error message from some users
when they try to access the database through a web browser.
error '80020009'
Exception occurred.
/include_files/mimpo/VBSFunctions.inc, line 61
This error appeared a while back, and the machine arrived in my area with
the error. I am new to SQL and am seeking help.
All present users within the machine have access to the database via their
web browsers. It is when I create a new user, that this error appears. Any
ideas?
If I restore the database from a backup when the error was not occurring,
would this elimate the error, and allow me to create new users that can
access the database successfully?
Or is there another method that I can use, without loosing two months of
info by performing a database restore?
Any help with this matter would really be great!!!
thanks,
scottHi
Check your SQL Server event logs for any problems.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"s-jeff" <s-jeff@.discussions.microsoft.com> wrote in message
news:C2B03635-F38F-4DC0-8092-90B388A41712@.microsoft.com...
> error '800200009' HELP!!!
> ---
> I am new to this forum and am looking for help...
> I inherited a Win NT4.0 server that is serving up MS SQL 7. It will
> eventually be replaced, now that I have responsibility for the machine.
But
> in the meantime...I am getting the following error message from some users
> when they try to access the database through a web browser.
> error '80020009'
> Exception occurred.
> /include_files/mimpo/VBSFunctions.inc, line 61
>
> This error appeared a while back, and the machine arrived in my area with
> the error. I am new to SQL and am seeking help.
> All present users within the machine have access to the database via their
> web browsers. It is when I create a new user, that this error appears. Any
> ideas?
> If I restore the database from a backup when the error was not occurring,
> would this elimate the error, and allow me to create new users that can
> access the database successfully?
> Or is there another method that I can use, without loosing two months of
> info by performing a database restore?
> Any help with this matter would really be great!!!
> thanks,
> scott
>

Error 4305 - Log-Shipping

Hi-
SQL 2000
Win 2k sp4
We have created a maintenance plan to ship one of our databases to a
secondary server. The initial snapshop shipped fine but we get error 4305
when trying to apply subsequent shipped tran logs.
The error says that the transaction log is too new.
We have another maintenance plan running on this DB that does backing
up(complete and tran logs) and it did do a tran-log backup after the
log-shipping snapshot. The log-shipping plan then made a tran log backup and
shipped it(which is too new).
I am trying to clarify if we can have two maintenance plans on the same
db(one for backup and one for log-shipping). Is this is what is causing this
error since they are overlapping.
I have not been able to find any info on this and am inclined to think they
are and I can only have oneplan that does all the backing up and the
log-shipping.
Can anyone confirm?
Thanks.Hi
With log shipping, you can do a Full and Differential backup at any time,
but transaction logs are sacred. Only log shipping can do the logs, otherwise
you would loose transactions.
Regards
Mike
"Jez" wrote:
> Hi-
> SQL 2000
> Win 2k sp4
> We have created a maintenance plan to ship one of our databases to a
> secondary server. The initial snapshop shipped fine but we get error 4305
> when trying to apply subsequent shipped tran logs.
> The error says that the transaction log is too new.
> We have another maintenance plan running on this DB that does backing
> up(complete and tran logs) and it did do a tran-log backup after the
> log-shipping snapshot. The log-shipping plan then made a tran log backup and
> shipped it(which is too new).
> I am trying to clarify if we can have two maintenance plans on the same
> db(one for backup and one for log-shipping). Is this is what is causing this
> error since they are overlapping.
> I have not been able to find any info on this and am inclined to think they
> are and I can only have oneplan that does all the backing up and the
> log-shipping.
> Can anyone confirm?
> Thanks.
>
>|||Thanks Mike for quick response
jez.
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:BD6B7EE8-97DA-4522-B201-0494A27C54F0@.microsoft.com...
> Hi
> With log shipping, you can do a Full and Differential backup at any time,
> but transaction logs are sacred. Only log shipping can do the logs,
> otherwise
> you would loose transactions.
> Regards
> Mike
> "Jez" wrote:
>> Hi-
>> SQL 2000
>> Win 2k sp4
>> We have created a maintenance plan to ship one of our databases to a
>> secondary server. The initial snapshop shipped fine but we get error 4305
>> when trying to apply subsequent shipped tran logs.
>> The error says that the transaction log is too new.
>> We have another maintenance plan running on this DB that does backing
>> up(complete and tran logs) and it did do a tran-log backup after the
>> log-shipping snapshot. The log-shipping plan then made a tran log backup
>> and
>> shipped it(which is too new).
>> I am trying to clarify if we can have two maintenance plans on the same
>> db(one for backup and one for log-shipping). Is this is what is causing
>> this
>> error since they are overlapping.
>> I have not been able to find any info on this and am inclined to think
>> they
>> are and I can only have oneplan that does all the backing up and the
>> log-shipping.
>> Can anyone confirm?
>> Thanks.
>>