還原 MSSQL 單一資料表記錄
學校行政系統科目資料表 BSUBJET 的一些設定科目記錄不知為何不見了,想說如果將資料庫還原回到今天早上的備份,那今天同事們所 KEY 入的資料將會完全不見,要重新來一次,想說用匯入資料的方式,將 BSUBJECT 匯入就好(因為匯入的方式可以選擇要匯入那些資料表,不用全部還原),可是不知是否下班時間到了,想說要兩個資料庫,只好明天回電腦教室,重電腦教室的資料庫,匯回行政系統的資料庫,回家一想,其實每天都有備份,只要將備份檔還原成另個資料庫名稱,再重它匯入原資料庫就好了,這樣還可以先檢查還原的 HSDB_BAK 下的資料表是否正確,像這一次還原前二天的備份檔,資料才正確,做法如下:
- SQL Server Enterprise => 資料庫 => HSDB => 所有工作 => 還原資料庫 => 選擇如下圖 => 點選確定 => 產生 HSDB_BAK 資料庫
- 從 HSDB_BAK 資料庫 => 所有工作 => 匯入資料 => 如下圖,一直下一步下去 => 完成
迴響
還原 MSSQL 單一資料表記錄 | 豬窩
I do not even know how I ended up here, but I thought this post was
good. I don't know who you are but certainly you are going to a famous blogger if
you aren't already ;) Cheers!
還原 MSSQL 單一資料表記錄 | 豬窩
Wonderful site. Plenty of helpful information here. I am
sending it to some pals ans also sharing in delicious.
And certainly, thank you for your sweat!
還原 MSSQL 單一資料表記錄 | 豬窩
We absolutely love your blog and find a lot of your post's to
be exactly what I'm looking for. Would you offer guest writers to write content for you
personally? I wouldn't mind producing a post or elaborating on many of the subjects you
write about here. Again, awesome blog!
還原 MSSQL 單一資料表記錄 | 豬窩
Currently it sounds like Drupal is the top blogging platform out there right now.
(from what I've read) Is that what you're using on your blog?
還原 MSSQL 單一資料表記錄 | 豬窩
Attractive section of content. I just stumbled upon your website and in accession capital to assert that I acquire actually enjoyed
account your blog posts. Anyway I will be subscribing to your feeds and even I
achievement you access consistently quickly.