The log scan number (288175:365436:0) passed to log scan in database is not valid. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf). If this error occurred during replication, re-create the publication. Otherwise, restore from backup if the problem results in a failure during startup.
Error: 9003, Severity: 20, State: 9.
how to truncate all tables
摘要:[SQL SERVER] 實戰紀錄 處理大量平行處理(Parallelism)、鎖定(lock)等待
摘要:[SQL SERVER] 查詢資料表(TABLE)的修改日期、使用空間大小、未使用空間、筆數
摘要:[SQL SERVER] 如何開啟SQL SERVER 1433 PORT允許遠端登入 (HOW TO OPEN FIREWALL PORT FOR SQL SERVER)
摘要:[SQL SERVER] SQLEXPRESS 無法連線，記得開啟TCP PORT呀
摘要:[Reporting Service] 啟動Reporting Service服務逾時 (The service did not respond to the start or control request in a timely fashion.)
摘要:[Reporting Service] Report Builder 3.0 連接Oracle出現ORA-12154: TNS:無法解析指定的連線ID
摘要:[SQL SERVER] 交易記錄檔無法truncate shrink , log滿、太大、無法縮小 (log_reuse_wait_desc replication)
摘要:[SQL SERVER] 常用 DBCC Command
摘要:[SQL SERVER] 什麼是參數探測 (Parameter Sniffing)
摘要:[SQL SERVER] PAGELATCH_*，等待類型
摘要:[SQL SERVER] AlwaysOn ReadOnlyRouting分流 (Load Balancing)
摘要:[SQL SERVER] infinite recompile 無限重新編譯 (SQL Server 2005)
摘要:[SQL SERVER] Always On Step by Step ~ 三. Always On 唯讀路由、其他備註、注意事項
摘要:[SQL SERVER] Always On Step by Step ~ 二. 建立Always On環境
摘要:[SQL SERVER] Always On Step by Step ~ 一. 安裝與建立Windows Server Failover Clustering
摘要:[SQL SERVER] xp_cmdshell 與 安全性問題
摘要:[SQL SERVER] 基礎 DBCC CHECKDB 在做什麼、要花多久時間、大型資料庫執行CHECKDB方法