-
Mike737
  - Joined on 04-06-2009
- Posts 1
|
SQL Server 2008 database backup exception
When I try to run a backup on a database from the SQL server 2008 database menu it displays the following error. The database uncompressed is over 400mb. Other smaller databases seem to work fine. Does anyone know how to fix this or have any suggestions where I should start looking?
The options selected were; Zip backup & copy to folder. | Page URL:
|
http://mydomain.com/Default.aspx?pid=SpaceMsSql2008&mid=62&ctl=backup&ItemID=405&SpaceID=6
|
|
Stack Trace:
|
System.Web.Services.Protocols.SoapException:
System.Web.Services.Protocols.SoapException: Server was unable to
process request. ---> System.Exception: Error executing 'BACKUP'
task on 'myDatabase' SQL_DATABASE --->
System.Web.Services.Protocols.SoapException:
System.Web.Services.Protocols.SoapException: Server was unable to
process request. ---> System.Data.SqlClient.SqlException: The backup
data at the end of "C:\Windows\TEMP\myDatabase.bak" is incorrectly
formatted. Backup sets on the media might be damaged and unusable. To
determine the backup sets on the media, use RESTORE HEADERONLY. To
determine the usability of the backup sets, run RESTORE VERIFYONLY. If
all of the backup sets are incomplete, reformat the media using BACKUP
WITH FORMAT, which destroys all the backup sets.
BACKUP DATABASE is terminating abnormally.
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 DotNetPanel.Providers.Database.MsSqlServer.ExecuteNonQuery(String commandText)
at DotNetPanel.Providers.Database.MsSqlServer.BackupBak(String databaseName, String backupName)
at
DotNetPanel.Providers.Database.MsSqlServer.BackupDatabase(String
databaseName, String backupFileName, Boolean zipBackupFile)
at DotNetPanel.Server.DatabaseServer.BackupDatabase(String databaseName, String backupName, Boolean zipBackup)
--- End of inner exception stack trace ---
at
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
message, WebResponse response, Stream responseStream, Boolean
asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[ parameters)
at DotNetPanel.Providers.Database.DatabaseServer.BackupDatabase(String databaseName, String backupName, Boolean zipBackup)
at
DotNetPanel.EnterpriseServer.DatabaseServerController.BackupSqlDatabase(Int32
itemId, String backupName, Boolean zipBackup, Boolean download, String
folderName)
--- End of inner exception stack trace ---
at
DotNetPanel.EnterpriseServer.DatabaseServerController.BackupSqlDatabase(Int32
itemId, String backupName, Boolean zipBackup, Boolean download, String
folderName)
at
DotNetPanel.EnterpriseServer.esDatabaseServers.BackupSqlDatabase(Int32
itemId, String backupName, Boolean zipBackup, Boolean download, String
folderName)
--- End of inner exception stack trace ---
at
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
message, WebResponse response, Stream responseStream, Boolean
asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[ parameters)
at
DotNetPanel.EnterpriseServer.esDatabaseServers.BackupSqlDatabase(Int32
itemId, String backupName, Boolean zipBackup, Boolean download, String
folderName)
at DotNetPanel.Portal.SqlBackupDatabase.BackupDatabase()
|
Windows 2008 Web Server x64 / DotNetPanel 2.8.2
|
|