CariDotMy

 Forgot password?
 Register

ADVERTISEMENT

View: 2815|Reply: 2

SQL Server 2000-Backup

[Copy link]
Post time 9-11-2006 03:17 PM | Show all posts |Read mode
Boleh terangkan secara ringkas tentang backup dalam SQL Server. Perbezaan jenis backup macam full, differential dan faedah yang kita dapat. Apa strategi/plan you all bila buat backup? Help please. TQVM.
Reply

Use magic Report


ADVERTISEMENT


Post time 11-11-2006 04:16 PM | Show all posts
Originally posted by ng58339 at 9-11-2006 03:17 PM
Boleh terangkan secara ringkas tentang backup dalam SQL Server. Perbezaan jenis backup macam full, differential dan faedah yang kita dapat. Apa strategi/plan you all bila buat backup? Help please.  ...



ni, secara ringkas apa yang oobi tau. katakan you run daily backup. kalau you set full backup, everyday your backup software akan backup the whole database. kalau you set to differential, initially your backup software akan run full backup. next job ia akan backup apa yang berubah dalam database tu. full backup lambat sikit nak habis while differential cepat. so, kalau your database is really big, kalau nak cepat backup, gunakan differential method. tapi, bagi oobi, kalau oobi boleh fit the whole data dalam satu tape, oobi akan run full backup tiap-tiap hari. kalau tak, oobi akan gunakan differential (but not preferable). oobi biasanya akan siapkan 2 weeks tape rotation for monday thru thursday, 4 tapes for friday backup (rotate every 4 weeks) and 1 end of the month tape backup (total 12 for the year) - this is for archive.

also, kalau your backup server is separate than your sql server, make sure you install sql agent of your backup software on your sql server (nak cepatkan backup process). and it's best to run backup overnight (masa tak de orang access the server at all).
Reply

Use magic Report

 Author| Post time 13-11-2006 04:59 PM | Show all posts
wah tenkiu very much. it helps.
Reply

Use magic Report

You have to log in before you can reply Login | Register

Points Rules

 

ADVERTISEMENT


Forum Hot Topic
...BYE 2024, HELLO 2025...
seribulan...BYE 2024, HELLO 2025...
Views : 54993 Replies : 13
...AZAM TAHUN 2025...
seribulan...AZAM TAHUN 2025...
Views : 55522 Replies : 25
[Netflix 2021] SQUID GAME Season 1,2,3 - Lee Jung Jae, Lee Byung Hun, Wi Ha Joon, Gong Yoo ~ 26 Dec 2024 (Season 2), 2025 (Final Season)
Rahah[Netflix 2021] SQUID GAME Season 1,2,3 -
Views : 29125 Replies : 254
...CHAT HUMANITARY...HAPPY NEW YEAR...
seribulan...CHAT HUMANITARY...HAPPY NEW YEAR...
Views : 44248 Replies : 29
V82: HANIS HAIZI B. ABD HAMID Melarikan Diri Dari Bayar Cukai LHDN Ke Los Angeles CA
anony-mousV82: HANIS HAIZI B. ABD HAMID Melarikan
Views : 11125 Replies : 449
New Chapter 01: FATTAH AMIN ~ Bebaskanlah mimpi-mimpi terindah
codenamedreamNew Chapter 01: FATTAH AMIN ~ Bebaskanla
Views : 47200 Replies : 1958
siri ikonik Korea, Squid Game 2 ditayangkan di Neflix hari ini
YgBenarsiri ikonik Korea, Squid Game 2 ditayang
Views : 13087 Replies : 5
Instafamous Rempit (kak yah, kak zah & the geng) part 3
hotmakInstafamous Rempit (kak yah, kak zah & t
Views : 232317 Replies : 1832
madu gula tok matahari
aaanf14madu gula tok matahari
Views : 109982 Replies : 1152
Acikpor vs. Ngai, isu tajaan MARA dikorek
maklukpenggodaAcikpor vs. Ngai, isu tajaan MARA dikore
Views : 52274 Replies : 1477

 

ADVERTISEMENT


 


ADVERTISEMENT
Follow Us

ADVERTISEMENT


Mobile|Archiver|Mobile*default|About Us|CariDotMy

28-12-2024 08:18 AM GMT+8 , Processed in 0.035123 second(s), 16 queries , Gzip On, Redis On.

Powered by Discuz! X3.4

Copyright © 2001-2021, Tencent Cloud.

Quick Reply To Top Return to the list