還原 MSSQL 單一資料表記錄
學校行政系統科目資料表 BSUBJET 的一些設定科目記錄不知為何不見了,想說如果將資料庫還原回到今天早上的備份,那今天同事們所 KEY 入的資料將會完全不見,要重新來一次,想說用匯入資料的方式,將 BSUBJECT 匯入就好(因為匯入的方式可以選擇要匯入那些資料表,不用全部還原),可是不知是否下班時間到了,想說要兩個資料庫,只好明天回電腦教室,重電腦教室的資料庫,匯回行政系統的資料庫,回家一想,其實每天都有備份,只要將備份檔還原成另個資料庫名稱,再重它匯入原資料庫就好了,這樣還可以先檢查還原的 HSDB_BAK 下的資料表是否正確,像這一次還原前二天的備份檔,資料才正確,做法如下:
- SQL Server Enterprise => 資料庫 => HSDB => 所有工作 => 還原資料庫 => 選擇如下圖 => 點選確定 => 產生 HSDB_BAK 資料庫
- 從 HSDB_BAK 資料庫 => 所有工作 => 匯入資料 => 如下圖,一直下一步下去 => 完成
迴響
還原 MSSQL 單一資料表記錄 | 豬窩
Hurrah! After all I got a webpage from where I can really obtain helpful information regarding my study
and knowledge.
還原 MSSQL 單一資料表記錄 | 豬窩
Hi to every one, the contents existing at this web site are in fact
remarkable for people knowledge, well, keep up the good work fellows.
還原 MSSQL 單一資料表記錄 | 豬窩
Hello my friend! I want to say that this post is amazing,
great written and come with approximately all vital
infos. I would like to see more posts like this .
還原 MSSQL 單一資料表記錄 | 豬窩
What's up, all is going nicely here and ofcourse every one
is sharing information, that's actually fine, keep up writing.
還原 MSSQL 單一資料表記錄 | 豬窩
I really love your site.. Excellent colors & theme.
Did you build this website yourself? Please reply back as I'm trying to
create my own website and would like to know where you got this from or what the theme is called.
Cheers! adreamoftrains website host