Not Shore How to Fix This Error

Results 1 to 4 of 4
  1. #1
    Apprentice RathDude is offline
    MemberRank
    Oct 2012 Join Date
    14Posts

    Not Shore How to Fix This Error


    Would some one please explane to me how I can fix this error thank you.


  2. #2
    Rada Rada. Delius is offline
    MemberRank
    Jul 2012 Join Date
    AustraliaLocation
    431Posts

    Re: Not Shore How to Fix This Error

    It's saying there is an existing Account database? Delete that first?

  3. #3
    Apprentice RathDude is offline
    MemberRank
    Oct 2012 Join Date
    14Posts

    Re: Not Shore How to Fix This Error

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

    Restore failed for Server 'HPDRAGON\SQLEXPRESS'. (Microsoft.SqlServer.SmoExtended)

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

    ------------------------------
    Program Location:

    at Microsoft.SqlServer.Management.Smo.Restore.SqlRestore(Server srv)
    at Microsoft.SqlServer.Management.SqlManagerUI.RestoreFilegroupsPropertiesTask.ApplyChanges(RunType runType, ExecutionMode& executionResult)
    at Microsoft.SqlServer.Management.SqlManagerUI.RestoreFilegroupsProperties.DoPreProcessExecution(RunType runType, ExecutionMode& executionResult)

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

    An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

    ------------------------------
    Program Location:

    at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
    at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType)
    at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(StringCollection queries)
    at Microsoft.SqlServer.Management.Smo.BackupRestoreBase.ExecuteSql(Server server, StringCollection queries)
    at Microsoft.SqlServer.Management.Smo.Restore.SqlRestore(Server srv)

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

    The backup set holds a backup of a database other than the existing 'Account' database.
    RESTORE DATABASE is terminating abnormally. (.Net SqlClient Data Provider)

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

    ------------------------------
    Server Name: HPDRAGON\SQLEXPRESS
    Error Number: 3154
    Severity: 16
    State: 4
    Line Number: 1


    ------------------------------
    Program Location:

    at Microsoft.SqlServer.Management.Common.ConnectionManager.ExecuteTSql(ExecuteTSqlAction action, Object execObject, DataSet fillDataSet, Boolean catchException)
    at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)

    Here the extended error.
    I tryed Deleteing it that did nothing I played around with it abit that did nothing. everything is installed how it shode be idk I'll google it I got a feeling this is't your every day error around these parts.

  4. #4
    Proficient Member xWhiteCore is offline
    MemberRank
    Jun 2012 Join Date
    193Posts

    Re: Not Shore How to Fix This Error

    No Read rights on your folder that includet your Database backup...

    Put Account.bak AccountLog.bak, Statist....... on your backup folder in the MSSQL Folder xD

    i've forgot how it's called .. i can you say it when i'm at home

    Some like this...

    C:\ProgramFiles\Micrsoft SQL Server\xxxxxxx.SQLEXPRESS\Backup


    EDIT:

    <drive>\ProgramFiles\Microsoft SQL Server\MSSQL10.<InstanceID>\ Backup



Advertisement