UNSOLVED

nicktang1

updated

17 years ago

N

nicktang1

7 Posts

0

1757

February 19th, 2010 21:00

NW 7.6 + nmsql521 backup SQL 2008 failure

Client envirement:server 2008 ent,sql 2008 ent,nw76_win_x86,nmsql521_win_x86

Can't auto or manual backup sql.When open networker module for sql,get some error:The objects "master.sys.databases" and "master..sysdatabases" in the FROM clause have the same exposed names. Use correlation names to distinguish them.(Translated from Chinese)

I found the error is for my sql 2008 can't run the query:

SELECT master..sysdatabases.name, master..sysdatabases.status FROM master..sysdatabases INNER JOIN master.sys.databases ON master..sysdatabases.name = master.sys.databases.name WHERE source_database_id is NULL

What might be reason of this problem?

  • BSequeira

    30 Posts

    547

    0

    Posted February 20th, 2010 04:00

    Hi,

    This issue is fixed in NMSQL 5.2 sp1 build 320 and higher. (latest 334)

    After the upgrade, the error will go away.

    Hope this helps.

    Regards

    Bruno

  • nicktang1

    7 Posts

    547

    0

    Posted February 20th, 2010 05:00

    I use NMSQL 5.2 sp1 build 299,this is the only version I can find to download.

  • BSequeira

    30 Posts

    547

    1

    Posted February 20th, 2010 08:00

    Hi

    Try this build:

    ftp://ftp.emc.com/outgoing/nmsql521_win_x86.zip

    Regards,

    Bruno

  • nicktang1

    7 Posts

    547

    0

    Posted February 20th, 2010 17:00

    Thank you.

    Now I can open the Networker Module for sql.

    I think this problem is about the Compatibility level of "master" database.

  • mig2

    5 Posts

    547

    0

    Posted February 26th, 2010 05:00

    I have the exact same problem, but I cannot seem to download the fix from the ftp site.

  • BSequeira

    30 Posts

    475

    0

    Posted February 26th, 2010 05:00

  • BSequeira

    30 Posts

    547

    0

    Posted February 26th, 2010 05:00

    Hi,

    Try again:

    ftp://ftp.emc.com/outgoing/nmsql521_win_x86.zip

    Regards,

    Bruno

  • mig2

    5 Posts

    551

    0

    Posted February 26th, 2010 05:00

    Thanks for the quick reply, but...this file is build 299 and I thought this was the one with the bug???

    Larry

  • BSequeira

    30 Posts

    320

    0

    Posted February 26th, 2010 06:00

    Hi Larry,

    Just downloaded and checked the build again, it is the latest. 347.

    Make sure that you are not overwriting a previous version when you download.

    Try to download the package to an empty folder, and unzipp it inside that folder.

    Lets me know if it still comes up with build 299


    Regards,

    Bruno

  • nicktang1

    7 Posts

    551

    0

    Posted February 26th, 2010 06:00

    Or you can change the Compatibility level of the "master" database.Don't use sql 2000.