RESTORE DATABASE is terminating abnormally. (Microsoft SQL Server, Error: 3154)
TITLE: Microsoft SQL Server Management Studio
------------------------------
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
ADDITIONAL INFORMATION:
The media family on device 'E:\DBBak\HTbak' is incorrectly formed. SQL Server cannot process this media family.
------------------------------
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
ADDITIONAL INFORMATION:
The media family on device 'E:\DBBak\HTbak' is incorrectly formed. SQL Server cannot process this media family.
RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3241)
USE master
RESTORE DATABASE History
FROM DISK = 'e:\DBBak\HT.bak'
WITH MOVE 'HT' TO 'e:\DB\History.mdf',
MOVE 'HT_Log' TO 'e:\DB\History_log.ldf',
STATS = 10, REPLACE
GO
USE master
RESTORE DATABASE 新建的沒有任何資料的資料庫名
FROM DISK = 'e:\資料庫備份檔案.bak'
WITH MOVE '原來的邏輯名稱' TO 'e:\新建的沒有任何資料的資料庫名.mdf',
MOVE '原來的邏輯名稱_log' TO 'e:\新建的沒有任何資料的資料庫名_log.ldf',
STATS = 10, REPLACE
GO
相關文章
- Microsoft SQL Server, Error: 15128 ()ROSSQLServerError
- SQL Server Backup & RestoreSQLServerREST
- Guide to Database Migration from Microsoft SQL Server using MySQL WorkbenchGUIIDEDatabaseROSServerMySql
- Microsoft SQL Server Trace FlagsROSSQLServer
- 網站報錯:“Database Server Error”網站DatabaseServerError
- Microsoft Sql Server 命令彙總ROSSQLServer
- Microsoft SQL Server,錯誤: 20582ROSSQLServer
- Moving the tempdb database(SQL server)DatabaseSQLServer
- restore database check readonlyRESTDatabase
- Cold backup and restore the entire databaseRESTDatabase
- XML Support in Microsoft SQL Server 2005XMLROSSQLServer
- Microsoft SQL Server Connector for Apache HadoopROSSQLServerApacheHadoop
- Sql Server系列:Microsoft SQL Server Management Studio模板資源管理器SQLServerROS
- Microsoft? ODBC Driver 11 for SQL Server? - RedHat LinuxROSSQLServerRedhatLinux
- Microsoft SQL Server查詢最佳化方法ROSSQLServer
- 無法開啟到SQL Server的連線 (Microsoft SQL Server, 錯誤:53) .SQLServerROS
- Close the Database by Terminating the Instance (304)Database
- How to prevent blocking in your SQL Server databaseBloCSQLServerDatabase
- PL/SQL package SYS.DBMS_BACKUP_RESTORE version 19.16.00.00 in TARGET database isSQLPackageRESTDatabase
- Microsoft SQL Server 2008中SQL Server服務啟動故障問題ROSSQLServer
- SQL SERVER – Attach mdf file without ldf file in DatabaseSQLServerDatabase
- SQL SERVER BACKUP DATABASE 加快備份速度方法SQLServerDatabase
- Microsoft SQL Server 遷移利器,Babelfish for Aurora PostgreSQL 上線!ROSSQLServerBabel
- Microsoft SQL Server 2005 中的國際功能ROSSQLServer
- 認識SQL Server2000 Server Role 和 Database RoleSQLServerDatabase
- 【RAC】PMON: terminating the instance due to error 481Error
- Crunchy PostgreSQL database restore via pgo commandSQLDatabaseRESTGo
- rman restore database(spfile,controlfile, datafile)RESTDatabase
- restore database報錯ora-19573RESTDatabase
- Unable to start HTTP server after restoreHTTPServerREST
- Kettle: pentaho-server-ce-9.4 : ERROR [SchemaUpdate] could not get database metadataServerErrorDatabase
- 恢復 Microsoft SQL Server SA 密碼的三種方法ROSSQLServer密碼
- 基於Microsoft SQL Server 2005安裝Teamcenter 8.3ROSSQLServer
- How to Restore the Database Using AMDU after Diskgroup CorruptionRESTDatabase
- How to restore and recover a database from an RMAN backup_881395.1RESTDatabase
- Manually Backup - Restore or Clone a Database to Another Node [ID 562556.1]RESTDatabase
- SQL Server database mail問題診斷一例SQLServerDatabaseAI
- Microsoft® SQL Server® 2008 R2 Best Practices AnalyzerROSSQLServer