Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
RathDragon
Starting Member
3 Posts |
Posted - 2012-10-20 : 12:43:02
|
Restore failed for Server '8888888888888888888'. (Microsoft.SqlServer.SmoExtended)------------------------------For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600.1+((KJ_RTM).100402-1539+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476------------------------------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: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600&EvtSrc=MSSQLServer&EvtID=3154&LinkId=20476------------------------------Server Name: 8888888888888888888Error Number: 3154Severity: 16State: 4Line 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)I googled it and found nothing but dead ends please explan to my how I can fix this error I tryed everying and nothings working I'm very comfused.Thank you. |
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-10-20 : 12:55:02
|
If you're trying to restore over an existing database, you need to use the REPLACE clause of the RESTORE command. Are you restoring using the SSMS GUI or another program that uses SMO? |
|
|
RathDragon
Starting Member
3 Posts |
Posted - 2012-10-20 : 13:32:48
|
i have 2 on my system but i'm not shore why or wich to ues Here a screen. How do I replace stuff I'm new to this progrem but willing to luren. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-10-20 : 14:50:51
|
Those are 2 connections to the same server, you can close/disconnect one of them.Expand the Databases folder, you should see a database in there named Account. Right click it and choose Tasks->Restore->Database. Select the backup file or device you want to restore. On the Options tab, check the box that says "Overwrite....REPLACE". |
|
|
RathDragon
Starting Member
3 Posts |
Posted - 2012-10-20 : 17:24:16
|
I did that there 5 driffent fines I'm restoreing but every time I try it loop restores over the last file i restored I end up restoring over top of the file I just did wen I mover to do the next one. Is there any way to brack this loop and make them restore as sninlge files rader the restoring over top each orther? |
|
|
|
|
|
|
|