Post reply

Detach/Attach_db

  • August 4, 2007 at 12:32 pm

    #153728

    I had detach a user database using sp_detach_db, then copy the data files & log to the new location Next re-attach the database pointing the files to the new location and now I can't get into the user database, Or get the Agent to start

    Errors:

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

    2) Unable to start service SQLSERVERAGENT on server ABASDSQLTEST.

    ===================================

    The SQLSERVERAGENT service on ABASDSQLTEST started and then stopped. (ObjectExplorer)

     

  • August 6, 2007 at 12:09 am

    #724755

    Umm... you didn't by chance delete or move the msdb for your instance of sql server did you?

     

  • August 6, 2007 at 9:06 am

    #724863

    You need to find you master and msdb files and move them back to the original location.  Move only the user database mdf, ldf and if any ndf files to the new location.

     

    [font="Arial"]Clifton G. Collins III[/font]

Viewing 3 posts - 1 through 2 (of 2 total)

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