Un avantaj al Full Recovery Model este posibilitatea efectuarii de Point-In-Time recovery. Personal, in cazul ilustrat, as face backup full in fiecare seara, as face truncate la log (mentinand evident Full Recovery Model). Daca totusi va permiteti sa pierdeti activitatea pe o zi atunci Simple Recovery Model e mai eficient.

LEAD Technologies Inc. V1.01

Va recomand sa incepeti cu: XML for Analysis, XML for Analysis Specification

Did you know?A ton of recycled paper is equivalent to recycling a newspaper and two white sheets daily for one year.A ton of recycled paper saves 20 trees, 3.800 kWh, 32.000L of water and prevents 27 kg of pollutants from being released into atmosphere.So why we recycle paper?To reduce deforestation, and this way there will be fewer: landslides, ...

Ce versiune de SQL Server folositi?

Evitati cursoarele. In situatia descrisa de dumneavoastra un ciclu while este mult mai eficient.

MSDN Virtual Lab: SQL Server 2005 Report Builder  http://go.microsoft.com/?linkid=4540578

Upgrade-ul de la SQL Server 2008 la SQL Server 2008 R2 este posibil.Folositi Upgrade Advisor - il gasiti pe distributia SQL Server 2008 R2 in folder-ul path\redist\upgrade advisor (unde path poate fi de exemplu pentru versiunea trial pe 32 de biti \1033_enu_lp\x86 ).