Welcome to Sign in | Join | Help
in Search

Baza de date prea mare

Last post 12-07-2010, 10:35 AM by cosmin.luca. 3 replies.
Sort Posts: Previous Next
  •  12-02-2010, 10:18 AM 8538

    Baza de date prea mare

    Salut! Am o baza de date de 5.7 GB (mdf). Am rulat pe ea un script pentru defragmentarea indecsilor si a ajuns la 8.4 GB si log la 3.4 GB. Mie mi se pare prea mult. I-am dat shrink, a ajuns la 4 GB (mdf, logul 1MB) dar indecsii s-au fragmentat la loc. Nu am mai lucrat cu baze de date asa de mari. Exista vreo posibilitate de a avea indecsii defragmentati si baza de date sa ocupe mai putin spatiu?
  •  12-02-2010, 10:42 AM 8539 in reply to 8538

    Re: Baza de date prea mare

    Ce probleme ai cu aceasta dimensiune?
    Te-ai convins singur de "avantajele" shrink in cazul tau. Totusi uite si aici
    http://www.sqlskills.com/BLOGS/PAUL/category/Shrink.aspx#p7
  •  12-03-2010, 12:11 PM 8544 in reply to 8538

    Re: Baza de date prea mare

    Ce recovery model are baza de date?
    1
    2
    3
    4
    SELECT
    recovery_model_desc
    FROM sys.databases
    WHERE [name]='MyDatabase';

    Cum ati facut shrink? Daca doar este trunchiat log-ul nu ar trebui sa va afecteze indecsii.






    Cristian Andrei Lefter, SQL Server MVP
    MCT, MCSA, MCDBA, MCAD, MCSD .NET,
    MCTS, MCITP - Database Administrator SQL Server 2005
    http://sqlserver.ro
  •  12-07-2010, 10:35 AM 8550 in reply to 8544

    Re: Baza de date prea mare

    Baza de date are model full de recovery. Shrink am facut la ambele fisiere, ceea ce nu e indicat.
View as RSS news feed in XML
Powered by Community Server (Commercial Edition), by Telligent Systems