Welcome to
Sign in
|
Help
in
Intrebari (forum)
Romanian Section (group)
(Entire Site)
Search
Home
Blogs
External Feeds
Forums
Photos
Downloads
About Us
»
Romanian Section
»
Intrebari
»
Re: marime baza de date
marime baza de date
Last post 08-23-2010, 4:14 PM by
Diana
. 3 replies.
Sort Posts:
Oldest to newest
Newest to oldest
Previous
Next
08-13-2010, 4:10 PM
8394
Abadon83
Joined on 08-16-2007
Daniel
db_owner
marime baza de date
Reply
Quote
Am o baza de date sql care a ajuns la 52 Gb. In fiecare luna, creste cu cate 1 Gb.
Cam ce solutii as avea pt backup ?
Momentan arhivez bak-ul ,dar si acela ajunge la 4-5 Gb.
Multumesc.
Report abuse
08-14-2010, 12:57 AM
8395
in reply to
8394
Diana
Joined on 03-21-2006
sysadmin
Re: marime baza de date
Reply
Quote
Pentru bazele de date mari poate fi utila o organizare pe files / filegroups cu posibilitatea de a face backup "pe bucati":
http://msdn.microsoft.com/en-us/library/ms189860%28v=SQL.90%29.aspx
SQL 2008 Enterprise si 2008 R2 Standard & Enterprise ofera "backup compression" - http://technet.microsoft.com/en-us/library/bb964719.aspx.
Pentru SQL 2005 poti folosi un 3rd party - http://www.mssqltips.com/tip.asp?tip=930 - de exemplu RedGate.
Timpul necesar pentru restore poate deveni si el o problema. Te-ar ajuta aici backup-ul diferential.
Report abuse
08-19-2010, 5:23 PM
8403
in reply to
8395
Abadon83
Joined on 08-16-2007
Daniel
db_owner
Re: marime baza de date
Reply
Quote
problema e ca am cateva tabele imense
cev de genul backup table cu conditie where data > 01.01.2010
sau ceva asemanator,daca e posibil
Report abuse
08-23-2010, 4:14 PM
8408
in reply to
8403
Diana
Joined on 03-21-2006
sysadmin
Re: marime baza de date
Reply
Quote
Cred ca te-ar ajuta partitionarea tabelului dupa data, cu arhivarea datelor mai vechi (de exemplu, mai vechi de 01.01.2010).
http://msdn.microsoft.com/en-us/library/ms345146%28SQL.90%29.aspx#sql2k5parti_topic13
Report abuse