MSSQL 2005 Error

Results 1 to 8 of 8
  1. #1
    Member GreenRibbon is offline
    MemberRank
    Jun 2010 Join Date
    San Leandro CALocation
    89Posts

    MSSQL 2005 Error

    Hey Im getting this error, I have tryed many things, can someone help me out with fixing it? Thanks in advance.

    TITLE: Microsoft SQL Server Management Studio Express
    ------------------------------

    Restore failed for Server 'UBERWARE1-1\SQLEXPRESS'. (Microsoft.SqlServer.Express.Smo)

    For help, click: Source: ID: ( ) - Events And Errors Message Center: Message Details

    ------------------------------
    ADDITIONAL INFORMATION:

    System.Data.SqlClient.SqlError: The operating system returned the error '5(error not found)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\ACCOUNT_DBF.mdf'. (Microsoft.SqlServer.Express.Smo)

    For help, click: Source: ID: (SQL Server 9.00.4035.00) - Events And Errors Message Center: Message Details

    ------------------------------
    BUTTONS:

    OK
    ------------------------------


  2. #2
    ASDFGHJKL RckyCls is offline
    MemberRank
    Apr 2010 Join Date
    At your back!Location
    730Posts

    Re: MSSQL 2005 Error

    is this in restoring database?

  3. #3
    Member GreenRibbon is offline
    MemberRank
    Jun 2010 Join Date
    San Leandro CALocation
    89Posts

    Re: MSSQL 2005 Error

    Yeah, Just like Dell Honne said to do on the thread for the v15 files.

  4. #4
    ASDFGHJKL RckyCls is offline
    MemberRank
    Apr 2010 Join Date
    At your back!Location
    730Posts

    Re: MSSQL 2005 Error

    in the Restore Database Window.

    General:
    Destination for restore-

    To database : ACCOUNT_DBF
    To a point in time : Most recent possible

    Source for restore
    Click From device > click ... > Add > choose the .bak file. > Ok.

    Select the backup sets to restore
    Put a check in Restore.


    Then Click Options on the left.
    Check Overwrite the existing database.

    In Restore the database file as.
    click the (...) then C://Program files/Microsoft SQL Server/MSQQL.1/MSSQL/Data/Account_mdf > Ok.

    Do in the following lines.

    Try these.

  5. #5
    Member GreenRibbon is offline
    MemberRank
    Jun 2010 Join Date
    San Leandro CALocation
    89Posts

    Re: MSSQL 2005 Error

    I dont have a Account_mdf O.o only, ACCOUNT_DBF and when I have it selected it shows a ACCOUNT_DBF_log. I still get that error

    ---------- Post added at 07:01 AM ---------- Previous post was at 06:36 AM ----------

    Im going another route with just going and adding the db's through the just a database download.

  6. #6
    Account Upgraded | Title Enabled! onemorejosh is offline
    MemberRank
    Apr 2009 Join Date
    BC, CanadaLocation
    246Posts

    Re: MSSQL 2005 Error

    Try attaching it instead of restoring it

  7. #7
    ASDFGHJKL RckyCls is offline
    MemberRank
    Apr 2010 Join Date
    At your back!Location
    730Posts

    Re: MSSQL 2005 Error

    What i mean is Account_DBF.mdf and ACCOUNT_DBF_LOG.ldf. IDK the exact name

  8. #8
    Member GreenRibbon is offline
    MemberRank
    Jun 2010 Join Date
    San Leandro CALocation
    89Posts

    Re: MSSQL 2005 Error

    Heres the thing, I don't have a mdf >.> and log only shows up when trying to recover it. I have even tryed going in, uninstalling sql and everything about 4 times and reinstalled it and tryed to get a clean slate, seems not to though, still know my info



Advertisement