Maintenance Plan bug on SQL Server 2005

Hello, everyone:

I have a strange trouble on SQL Server 2005 on XP/local and Win 2003/server. When I connect local database and create a backup plan named by "backup plan", I can see the name under "maintenance plan" and "Jobs" under SQL Server Agent. But if I connect to server database and do the samething, I cannot see the name under "maintenance plan". I can see the name under "Jobs" under SQL Server Agent. But cannot delete this job, and message:

Drop failed for job "Backup Plan".(Microsoft.SqlServer.Smo).

Did someone meet this bug and have suggestions?

Thanks

ZYTPermissions? Do you have the same permissions to the server as you do to your local SQL Server?|||Hi, Pootle:

Thanks for reply.

I have sysadmin permissions to the server.

ZYT

Permissions? Do you have the same permissions to the server as you do to your local SQL Server?|||Hi, Pootle:

The server is the remote one that our company just got from someone else. I login by "Remote Desktop Connection" and check SQL Server. From Start - Programs - SQL Server 2005, there is only "Configuration Tools" available, no other componences like "SQL Server Management Stadio". This is first time I sam and confused. What was happened?

When I connect server from SQL Server, I can all tables and stored procedrues.

Thanks

ZYT

Permissions? Do you have the same permissions to the server as you do to your local SQL Server?|||As I remember, there was a bug in SQL 2005 SP2 that affected Maintenance plans. Check to see what hotfixes are available.

Maintenance Assistant SQL 2005 Error 12291

Hello,
SQL Server 2005 EE Trial Version SP2 Win 2003 SP2
I've tried to backup the AdventureWorks database with the help of
Maintenance Assistant, I've created a fairly simple job, straight forward,
no tricks and radio button clicks!
I've started that job and after a while I got an error id: 12291 Error
Package Maintenace Plan 12291 in the event protocol.
The additional text is reporting that the backup of the database
AdventureWorks was ok!
What in the hell went wrong, A Microsoftware error?
Please help
Lanying & ManfredHi
"Lanying & Manfred Chen-Fischer" wrote:

> Hello,
> SQL Server 2005 EE Trial Version SP2 Win 2003 SP2
> I've tried to backup the AdventureWorks database with the help of
> Maintenance Assistant, I've created a fairly simple job, straight forward,
> no tricks and radio button clicks!
> I've started that job and after a while I got an error id: 12291 Error
> Package Maintenace Plan 12291 in the event protocol.
> The additional text is reporting that the backup of the database
> AdventureWorks was ok!
> What in the hell went wrong, A Microsoftware error?
> Please help
> Lanying & Manfred
>
See reply to you other post
http://www.microsoft.com/technet/co...fe
80c2b
John

Maintenance Assistant SQL 2005 Error 12291

Hello,
SQL Server 2005 EE Trial Version SP2 Win 2003 SP2
I've tried to backup the AdventureWorks database with the help of
Maintenance Assistant, I've created a fairly simple job, straight forward,
no tricks and radio button clicks!
I've started that job and after a while I got an error id: 12291 Error
Package Maintenace Plan 12291 in the event protocol.
The additional text is reporting that the backup of the database
AdventureWorks was ok!
What in the hell went wrong, A Microsoftware error?
Please help
Lanying & Manfred
Hi
"Lanying & Manfred Chen-Fischer" wrote:

> Hello,
> SQL Server 2005 EE Trial Version SP2 Win 2003 SP2
> I've tried to backup the AdventureWorks database with the help of
> Maintenance Assistant, I've created a fairly simple job, straight forward,
> no tricks and radio button clicks!
> I've started that job and after a while I got an error id: 12291 Error
> Package Maintenace Plan 12291 in the event protocol.
> The additional text is reporting that the backup of the database
> AdventureWorks was ok!
> What in the hell went wrong, A Microsoftware error?
> Please help
> Lanying & Manfred
>
See reply to you other post
[url]http://www.microsoft.com/technet/community/newsgroups/dgbrowser/en-us/default.mspx?&query=lanying&lang=en&cr=US&guid=&sl oc=en-us&dg=microsoft.public.sqlserver.server&p=1&tid=31 a069c2-d22d-4f79-99a1-91ffefe80c2b&mid=31a069c2-d22d-4f79-99a1-91ffefe80c2b[/url]
John

Maintenance Assistant SQL 2005 Error 12291

Hello,
SQL Server 2005 EE Trial Version SP2 Win 2003 SP2
I've tried to backup the AdventureWorks database with the help of
Maintenance Assistant, I've created a fairly simple job, straight forward,
no tricks and radio button clicks!
I've started that job and after a while I got an error id: 12291 Error
Package Maintenace Plan 12291 in the event protocol.
The additional text is reporting that the backup of the database
AdventureWorks was ok!
What in the hell went wrong, A Microsoftware error?
Please help
Lanying & ManfredHi
"Lanying & Manfred Chen-Fischer" wrote:
> Hello,
> SQL Server 2005 EE Trial Version SP2 Win 2003 SP2
> I've tried to backup the AdventureWorks database with the help of
> Maintenance Assistant, I've created a fairly simple job, straight forward,
> no tricks and radio button clicks!
> I've started that job and after a while I got an error id: 12291 Error
> Package Maintenace Plan 12291 in the event protocol.
> The additional text is reporting that the backup of the database
> AdventureWorks was ok!
> What in the hell went wrong, A Microsoftware error?
> Please help
> Lanying & Manfred
>
See reply to you other post
http://www.microsoft.com/technet/community/newsgroups/dgbrowser/en-us/default.mspx?&query=lanying&lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.sqlserver.server&p=1&tid=31a069c2-d22d-4f79-99a1-91ffefe80c2b&mid=31a069c2-d22d-4f79-99a1-91ffefe80c2b
Johnsql

MAC address

Hi,
I have a win 2000 adv + sql 2000 box. I would like to know if it is
possible to not allow access to the server using some machines MAC address o
r
Name. I know we can do a lot by using logins and other ways, but in my case
I
have no other choice except either MAC or machine name.
Thanks for your help.
SalamHi
Do this at network router level as it is really efficient down there and the
right place to do it.
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/
"SalamElias" <eliassal@.online.nospam> wrote in message
news:FE1C4C5A-84A2-4E21-8669-4EDC5B25FCA9@.microsoft.com...
> Hi,
> I have a win 2000 adv + sql 2000 box. I would like to know if it is
> possible to not allow access to the server using some machines MAC address
> or
> Name. I know we can do a lot by using logins and other ways, but in my
> case I
> have no other choice except either MAC or machine name.
> Thanks for your help.
> Salam|||This is my problem, I have no control on the router.
So as I said I have no other choice rather thatn machine name or mac adresse
Thanks
"Mike Epprecht (SQL MVP)" wrote:

> Hi
> Do this at network router level as it is really efficient down there and t
he
> right place to do it.
> 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/
> "SalamElias" <eliassal@.online.nospam> wrote in message
> news:FE1C4C5A-84A2-4E21-8669-4EDC5B25FCA9@.microsoft.com...
>
>|||Hi
If you have Windows 2003 (preferably with SP1), you can use IPSec at OS
level to filter the traffic. Look up IPSec on technet for more information.
No an elegant solution, but it is the only thing that you could do.
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/
"SalamElias" <eliassal@.online.nospam> wrote in message
news:E2528C86-EFEF-43E4-A998-EDC6F6153136@.microsoft.com...[vbcol=seagreen]
> This is my problem, I have no control on the router.
> So as I said I have no other choice rather thatn machine name or mac
> adresse
> Thanks
> "Mike Epprecht (SQL MVP)" wrote:
>

LSN Error

SQL 2k WIn 2k.
I just restored a dB and now I am receiving the following error on my
log reader for the restored dB.
The LSN (169614:314254:8) passed to log scan in database 'StoreMain' is
invalid.
I cannot find anything online. Any one have any ideas?
Larry...
Did you also restore the distribution database as well as the subscribers?
When the log reader starts, it reads an entry from the distribution database
that designates the last LSN read from the transaction log. The Log Reader
then starts to read the transaction log forward of that marker. If you have
restored the publisher without also addressing the distribution database and
the susbcriber, then the Log Reader is not going to find the LSN that it is
looking for and will then throw this error. The cleanest way to fix this is
to reinitialize, because your subscribers can have data that is out of synch
with the publisher.
Mike
Mentor
Solid Quality Learning
http://www.solidqualitylearning.com
"LPR-3rd" <lreames@.gmail.com> wrote in message
news:1136841382.142705.313890@.f14g2000cwb.googlegr oups.com...
> SQL 2k WIn 2k.
> I just restored a dB and now I am receiving the following error on my
> log reader for the restored dB.
> The LSN (169614:314254:8) passed to log scan in database 'StoreMain' is
> invalid.
>
> I cannot find anything online. Any one have any ideas?
> Larry...
>
|||How will reinit fix the LSN problem?
The cleanest way to fix this is to reinitialize, because your
subscribers can have data that is out of synch with the publisher.