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