Newbie Spellweaver
- Joined
- Jan 6, 2008
- Messages
- 83
- Reaction score
- 1
I am trying to restore the DB's, can someone please help me?
Maybe I overlooked something?
Also, thanks Dan for sharing the file you coded.
Edit Node Info:
12 GB Ram DDR3 ECC
2.63 Ghz 2 Processor x 4 CPU Each = 8 Cores
2 x 2000 GB SAS
Windows 2008 Standard 64bit (Licensed Genuine)
1 GBPS on 10 GBPS Switch Port
(100% sure has nothing to do with the error)
Thank you in Advance!
Maybe I overlooked something?
Also, thanks Dan for sharing the file you coded.
Edit Node Info:
12 GB Ram DDR3 ECC
2.63 Ghz 2 Processor x 4 CPU Each = 8 Cores
2 x 2000 GB SAS
Windows 2008 Standard 64bit (Licensed Genuine)
1 GBPS on 10 GBPS Switch Port
(100% sure has nothing to do with the error)
Code:
===================================
Restore failed for Server 'WIN-181XAVUE45F\SQLEXPRESS'. (Microsoft.SqlServer.SmoExtended)
------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.2531.0+((Katmai_PCU_Main).090329-1045+)&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.SqlRestoreDatabaseOptions.RunRestore()
===================================
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.ExecutionManager.ExecuteNonQueryWithMessage(StringCollection queries, ServerMessageEventHandler dbccMessageHandler, Boolean errorsAsMessages)
at Microsoft.SqlServer.Management.Smo.BackupRestoreBase.ExecuteSql(Server server, StringCollection queries)
at Microsoft.SqlServer.Management.Smo.Restore.SqlRestore(Server srv)
===================================
The code page 936 is not supported by the server. (.Net SqlClient Data Provider)
------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.00.2531&EvtSrc=MSSQLServer&EvtID=2775&LinkId=20476
------------------------------
Server Name: WIN-181XAVUE45F\SQLEXPRESS
Error Number: 2775
Severity: 17
State: 2
Line Number: 1
------------------------------
Program Location:
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
Thank you in Advance!
Last edited: