-
Apprentice
Not Shore How to Fix This Error

Would some one please explane to me how I can fix this error thank you.
-
-
Re: Not Shore How to Fix This Error
It's saying there is an existing Account database? Delete that first?
-
Apprentice
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.
-
Proficient Member
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