Post reply

Msg 911, Level 16, State 1, Line 1

  • June 29, 2010 at 9:35 am

    #141143

    When I run the following

    exec [ABC\ABC1].[BizTalkMgmtDb].[dbo].[sp_BackupAllFull_Schedule] 'd' /* Frequency */, 'BTS' /* Name */, '\\abc1234\Backup_Weekly\MSSQLPRDBTS\BizTalk\FullBackup' /* location of backup files */,1

    I get the following error **"Could not locate entry in sysdatabases for database 'BAMPrimaryImport'"

    so I run the following and I gets results

    Select * From Sysdatabases where name='BAMPrimaryImport'

    namedbidsid

    BAMPrimaryImport10

    Any Ideas!!!

    THANKS

  • June 29, 2010 at 9:44 am

    #1186476

    The command and the query you show are two different databases.

    Are you running this from a command line or SSMS? A job?

    Is this a linked server?

    I'm trying to understand the context under which you are using the four part naming?

    Also, do you have rights to access this database?

  • June 29, 2010 at 9:56 am

    #1186481

    Hi Steve,

    This a Sql Agent job I am running( have treid to run it from a Query window as well) ,

    I have SA rights.

    This is for a "biztalk back up Job" so the job backsup a few DB'd at on etime

    I orginally just had this, tried adding the full name out there just make sure the server new which instance

    exec dbo].[sp_BackupAllFull_Schedule] 'd' /* Frequency */, 'BTS' /* Name */, '\\abc123\Backup_Weekly\MSSQLPRDBTS\BizTalk\FullBackup' /* location of backup files */,1

  • June 29, 2010 at 10:13 am

    #1186498

    It looks like you are missing a bracket here. If you are posting stuff, be sure that you cut/paste, not type so that we can get an idea.

    SQL Agent will log into an instance, so you don't need to include that. In terms of executing this, I'd set the database context for this procedure in SQL Agent (pick the db) and just run it with dbo.sp_name.

  • June 29, 2010 at 10:28 am

    #1186513

    thanks STEVE

    the exact code is this (below)---

    the SP (sp_BackupAllFull_Schedule) is canned logshipping SP for biztalk, which uses DTS for backups, it places a mark on all DB's and then backs them up as a group.

    This worked fine for a day then I started getting this error... so added the instance name just with an attemp to elimante any variables that might exist...I am out of ideas now

    exec [dbo].[sp_BackupAllFull_Schedule] 'd' /* Frequency */, 'BTS' /* Name */, '\\SANdbmsPRD02\Backup_Weekly\MSSQLPRDBTS\BizTalk\FullBackup' /* location of backup files */,1

    Msg 911, Level 16, State 1, Line 1

    Could not locate entry in sysdatabases for database 'BAMPrimaryImport'. No entry found with that name. Make sure that the name is entered correctly.

    I then ran

    Select * From Sysdatabases where name='BAMPrimaryImport'

    --which returns results

    think I am going to run the confige.exe file and start over at this point....I have not other idea

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply