SQL Server第三協力廠商管理工具介紹(1)

by adonis 14. 九月 2015 10:23

作    者:楊先民
審    稿:張智凱

前言
在上課時常被問到的問題,就是… SQL Server有沒有第三協力
廠商的管理工具?

答案當然是肯定的,只是上課的時後我們教的是微軟的教材,不可能介紹這些程式,不過倒是可以當作上課時的補充,各位可以參考看看。

第三協力廠商管理工具
所謂的「第三協力廠商」管理工具,顧名思意就是非原廠官方的管理工具,由其他民間業者所開發的,自認比原廠更好的管理工具。

原廠的管理工具價格都已經內含在產品裡面,所以無需再付費,而第三協力廠商的管理工具通常都是要另外付費的(不然他們賺什麼?)

這次介紹的第三協力廠商的管理工具,官方網址在

https://www.idera.com/

image

看起來是要付費的,不過看起來功能也頗多,還有試用版可以體驗,所以這次我就先來測試一下它的 SQL Safe Backup吧。

image

開始下載試用版試用…

image

在 Windows中的安裝畫面中,我選擇「All Components」
全部安裝完後,它會有一個 Management Console

image

其中就會跳出一個畫面,你可以選擇啟動備份精靈(Launch Backup Wizard),其實就算你不按這個地方,選管理工具上的資料庫按右鍵同樣也可以備份資料庫,同樣也是會出現精靈就是了。

image

感覺起來界面有點像維護計劃,要你選擇需要備份的資料庫。

image

選擇備份到一個檔案或是 Mirror備份,和 SQL Server自家的 Mirror backup一樣的感覺。

image

資料庫的壓縮與加密選項是一個也不少,感覺這點和 SQL Server自家的備份功能一樣,不過在 SQL Server中可是要先做一些設定的,而這個看起來只要勾勾精靈他就會自動幫你做。

image

備份失敗還可以設定通知機制,有點像把 SQL Server本家的自動化通知機制融合進來。

image

可以把檔案分散備份到多個地方,有點分散大備份檔的觀念,而且檔名還很好心的標示成(1 of total 5)這種,讓人可以清楚知道檔案是否有齊全。

image

開始備份,成功與失敗資訊都很輕楚呈現,失敗也會寫錯誤訊息,而且在備份的時後感覺起來像是在背景執行,當然實際如何則不得而知。

image

備份出來的檔案,附檔名為 safe,我企圖加入到 SQL Server的備份裝置想要觀看,發現這是它自己的格式,並不能讓 SQL Server認識。

image

如果需要 Restore,也只要按下資料庫右鍵即可選擇 restore,一開始就出現要 restore到哪一台,而且還會很貼心的問你是否要先把原來的資料庫離線(很多人其實不太會設定單一使用者模式,不誇張)。

image

把之前備份的完整資料庫還原。

不過這裡我企圖想營造 SQL Server上課時的環境,也就是有資料在還沒有備份 log之前就壞掉了,在微軟官方的做法是要先備份 tail-log,然後再從完整資料庫、差異以及 log一個個回復,但是這裡找不到有 tail-log備份的選項不說,如果你硬要 restore, SQL Server本身會傳出錯誤訊息要求你做 tail-log 備份,不然你只能使用 replace將制復原,但是這樣就很有可能資料無法百分之百救回。

image

選擇要 restore的資料庫並且還原。

我個人的心得是,如果純粹只是要備份還原資料庫,如果熟悉 SQL Server自家的備份還原方式的話(例如我),還是用微軟自家的工具吧,畢竟這套程式是要收費的,我是在試用 30天時間先看看好不好用的,其實各位也可以利用虛擬機器自己測試這些功能,像這家軟體還說可以使用使用它們家自訂的語法來控制資料庫的備份還原。

附帶一提,官網有提供一個和其他 3-party以及 SQL Server官方工具的比較圖,各位真的有興趣可以參考一樣。

image

LAST

Tags:

評論 (64) -

cours de theatre paris
cours de theatre paris United States
2017/9/30 上午 10:59:32 #

Appreciate you sharing, great post.Really looking forward to read more. Great.

回覆

can ho osimi
can ho osimi United States
2017/10/6 下午 10:40:50 #

Very informative article post.Thanks Again. Much obliged.

回覆

Buy illegal backlinks
Buy illegal backlinks United States
2017/10/9 下午 12:36:27 #

Very neat blog.Thanks Again. Really Cool.

回覆

tanie leki na potencje
tanie leki na potencje United States
2017/10/9 下午 02:15:23 #

Awesome blog.Thanks Again. Want more.

回覆

Osimi sea view
Osimi sea view United States
2017/10/9 下午 04:31:34 #

Thanks again for the blog article.Thanks Again. Much obliged.

回覆

solarmovie
solarmovie United States
2017/10/10 下午 06:18:21 #

wow, awesome blog article.Thanks Again. Fantastic.

回覆

Nathan Coombe
Nathan Coombe United States
2017/10/10 下午 08:26:59 #

I really like and appreciate your blog post.Thanks Again. Much obliged.

回覆

pirater un compte facebook
pirater un compte facebook United States
2017/10/10 下午 10:44:47 #

Thanks for the post. Will read on...

回覆

Google new cheat hacklinks
Google new cheat hacklinks United States
2017/10/12 下午 07:09:41 #

Very good blog post. Much obliged.

回覆

Look At This
Look At This United States
2017/10/14 下午 01:49:38 #

Thanks a lot for the blog post.Really looking forward to read more. Keep writing.

回覆

dragon city hack game
dragon city hack game United States
2017/10/15 下午 01:50:10 #

I value the blog.Really looking forward to read more.

回覆

omega xl
omega xl United States
2017/10/15 下午 06:33:41 #

I appreciate you sharing this article post. Cool.

回覆

this hyperlink
this hyperlink United States
2017/10/17 下午 01:08:00 #

Thanks-a-mundo for the blog article.Really thank you! Fantastic.

回覆

sletrokor review
sletrokor review United States
2017/10/17 下午 06:41:03 #

Major thankies for the article post. Awesome.

回覆

officetel
officetel United States
2017/10/19 上午 04:03:44 #

I really liked your post. Really Cool.

回覆

VigRx Plus
VigRx Plus United States
2017/10/19 上午 05:44:25 #

Appreciate you sharing, great blog post.Thanks Again. Much obliged.

回覆

go now
go now United States
2017/10/19 下午 04:27:39 #

Thanks for sharing, this is a fantastic blog. Keep writing.

回覆

pure slim 1000
pure slim 1000 United States
2017/10/20 上午 01:57:39 #

wow, awesome blog post.Really thank you! Want more.

回覆

DIC Phoenix
DIC Phoenix United States
2017/10/21 上午 01:33:26 #

Really informative blog post.Really thank you! Fantastic.

回覆

carte grise en ligne
carte grise en ligne United States
2017/10/21 上午 05:15:28 #

Great article.

回覆

elakekassa suomi
elakekassa suomi United States
2017/10/21 下午 03:40:04 #

Looking forward to reading more. Great blog article.Really looking forward to read more. Great.

回覆

Turbotax customer service
Turbotax customer service United States
2017/10/24 上午 06:09:21 #

I cannot thank you enough for the blog. Want more.

回覆

osimi seaview
osimi seaview United States
2017/10/28 上午 07:30:52 #

A big thank you for your article.Much thanks again. Much obliged.

回覆

EZ Battery Reconditioning
EZ Battery Reconditioning United States
2017/10/30 上午 06:26:40 #

Thank you for your article.Really looking forward to read more. Really Great.

回覆

pogoda plock
pogoda plock United States
2017/10/30 下午 02:11:09 #

I loved your blog.Thanks Again. Cool.

回覆

life leadership
life leadership United States
2017/11/1 上午 06:38:33 #

wow, awesome blog post.

回覆

phenocal
phenocal United States
2017/11/1 下午 01:59:07 #

Thanks for sharing, this is a fantastic blog. Want more.

回覆

phentaslim review
phentaslim review United States
2017/11/3 下午 12:46:37 #

Very neat article. Great.

回覆

sciatica pain solutions
sciatica pain solutions United States
2017/11/15 上午 06:41:20 #

Muchos Gracias for your blog article.Thanks Again. Cool.

回覆

avocat criminel quebec
avocat criminel quebec United States
2017/11/16 下午 05:16:33 #

Thanks so much for the article post.Really thank you! Cool.

回覆

Very informative article.Thanks Again. Really Cool.

回覆

autocad autodesk 360
autocad autodesk 360 United States
2017/11/22 上午 01:48:42 #

This is one awesome post.Thanks Again. Keep writing.

回覆

bikinis
bikinis United States
2017/11/23 下午 08:42:14 #

Awesome blog article.Really thank you! Keep writing.

回覆

Web Design Auckland
Web Design Auckland United States
2017/11/25 下午 05:41:08 #

Thank you ever so for you article post. Want more.

回覆

Chad Boonswang SEO
Chad Boonswang SEO United States
2017/11/26 下午 10:52:19 #

I appreciate you sharing this article.Thanks Again. Want more.

回覆

Osimi Tower
Osimi Tower United States
2017/11/29 下午 09:49:55 #

A round of applause for your post.Thanks Again. Much obliged.

回覆

aged corporations
aged corporations United States
2017/11/30 下午 11:42:53 #

wow, awesome article.Thanks Again. Fantastic.

回覆

porno
porno United States
2017/12/1 下午 03:22:44 #

Thanks again for the article.Much thanks again. Really Cool.

回覆

primary trade lines
primary trade lines United States
2017/12/3 上午 03:41:11 #

Thanks for sharing, this is a fantastic article post.Much thanks again. Really Great.

回覆

mika tan
mika tan United States
2017/12/5 上午 08:27:51 #

Fantastic article post.Really looking forward to read more. Much obliged.

回覆

Really enjoyed this article post.Really thank you! Really Great.

回覆

dorty lawyer
dorty lawyer United States
2017/12/10 下午 06:06:34 #

Great, thanks for sharing this post.Really thank you! Really Cool.

回覆

Laurice Turntine
Laurice Turntine United States
2017/12/14 上午 08:13:47 #

A round of applause for your blog.Thanks Again. Cool.

回覆

review
review United States
2017/12/14 下午 03:04:46 #

Looking forward to reading more. Great blog post.Really thank you! Great.

回覆

Hanukkah
Hanukkah United States
2017/12/14 下午 09:34:50 #

Looking forward to reading more. Great blog.Really thank you! Great.

回覆

canon driver software
canon driver software United States
2017/12/16 下午 04:47:39 #

Im grateful for the article.Really looking forward to read more. Much obliged.

回覆

Thanks-a-mundo for the article. Great.

回覆

Awesome article.Really thank you! Fantastic.

回覆

Analytical
Analytical United States
2017/12/17 下午 04:29:58 #

I truly appreciate this blog post.Really looking forward to read more. Great.

回覆

read the full info here
read the full info here United States
2017/12/17 下午 11:30:51 #

I loved your blog.Really looking forward to read more. Much obliged.

回覆

paid to click
paid to click United States
2017/12/20 下午 05:40:15 #

Thank you for your blog article.Much thanks again. Will read on...

回覆

canon drivers
canon drivers United States
2017/12/23 上午 06:48:28 #

Thank you ever so for you article.Really looking forward to read more. Much obliged.

回覆

Darwin Horan
Darwin Horan United States
2017/12/23 下午 05:16:56 #

A round of applause for your blog post. Awesome.

回覆

driver hp
driver hp United States
2017/12/25 下午 06:49:49 #

Major thankies for the article post.Much thanks again. Want more.

回覆

I cannot thank you enough for the post.Really thank you! Really Cool.

回覆

آینه
آینه United States
2017/12/26 上午 06:40:44 #

Thanks again for the blog article.Thanks Again. Great.

回覆

SOCCER HIGHLIGHTS
SOCCER HIGHLIGHTS United States
2017/12/26 下午 02:03:05 #

Very neat article post.Really thank you! Will read on...

回覆

canon drivers
canon drivers United States
2017/12/27 下午 08:40:33 #

Thanks again for the article post.Much thanks again. Awesome.

回覆

drivers hp
drivers hp United States
2018/1/2 上午 11:15:11 #

Wow, great blog article.Thanks Again.

回覆

take a look at the site here
take a look at the site here United States
2018/1/2 下午 07:24:01 #

Im obliged for the blog article. Will read on...

回覆

printer drivers
printer drivers United States
2018/1/3 上午 10:37:40 #

Thanks for the post.Really looking forward to read more. Keep writing.

回覆

colocation miami
colocation miami United States
2018/1/10 上午 11:43:00 #

Muchos Gracias for your post. Cool.

回覆

新增評論




  Country flag
biuquote
  • 評論
  • 線上預覽
Loading






NET Magazine國際中文電子雜誌

NET Magazine國際中文電子版雜誌,由恆逸資訊創立於2000,自發刊日起迄今已發行超過500篇.NET相關技術文章,擁有超過40000名註冊讀者群。NET Magazine國際中文電子版雜誌希望藉於電子雜誌與NET Developer達到共同學習與技術新知分享,歡迎每一位對.NET 技術有興趣的朋友們多多支持本雜誌,讓作者群們可以有持續性的動力繼續爬文。<請加入免費訂閱>

月分類Month List