http://sqlserver.ro/forums/22/ShowForum.aspxenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlserver.ro/forums/thread/749.aspxSun, 05 Nov 2006 14:33:18 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:749xmldeveloper0http://sqlserver.ro/forums/thread/749.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=22&PostID=749Pe aceeasi tema un tutorial realizat in 2005: <a href="http://sqlserver.ro/files/folders/tutorials/entry748.aspx">http://sqlserver.ro/files/folders/tutorials/entry748.aspx</a>http://sqlserver.ro/forums/thread/341.aspxThu, 12 Oct 2006 13:20:17 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:341xmldeveloper0http://sqlserver.ro/forums/thread/341.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=22&PostID=341<p class="MsoNormal" style="margin:0in 0in 0pt;"><strong><span style="font-size:10pt;font-family:Arial;">Database Snapshots</span></strong></p><p class="MsoNormal" style="margin:0in 0in 0pt;"><span style="font-size:9pt;font-family:Arial;">&nbsp;</span></p><p class="MsoNormal" style="margin:0in 0in 0pt;"><span style="font-size:9pt;font-family:Arial;"><strong>Database Snapshots</strong> ofera posibilitatea de a obtine rapid o imagine consistenta si read-only a unei baze de date.</span></p><p class="MsoNormal" style="margin:0in 0in 0pt;"><span style="font-size:9pt;font-family:Arial;">Aceasta facilitate nu inlocuieste o strategie de backup/restore fiind un mecanism pentru protectie impotriva erorilor generate de aplicatii sau utilizatori.</span></p><p class="MsoNormal" style="margin:0in 0in 0pt;"><span style="font-size:9pt;font-family:Arial;">Se poate folosi&nbsp;</span></p><ul><li><div class="MsoNormal" style="margin:0in 0in 0pt;"><span style="font-size:9pt;font-family:Arial;"></span><span style="font-size:9pt;font-family:Arial;">pentru obtinerea unei baze de raportare</span></div></li><li><div class="MsoNormal" style="margin:0in 0in 0pt;"><span style="font-size:9pt;font-family:Arial;"></span><span style="font-size:9pt;font-family:Wingdings;"><span><span style="font:7pt 'Times New Roman';">&nbsp;</span></span></span><span style="font-size:9pt;font-family:Arial;">ca baza de test</span></div></li><li><div class="MsoNormal" style="margin:0in 0in 0pt;"><span style="font-size:9pt;font-family:Arial;"></span><span style="font-size:9pt;font-family:Arial;">ca metoda complementara de recuperare a datelor </span></div></li></ul><p class="MsoNormal" style="margin:0in 0in 0pt;"><span style="font-size:9pt;font-family:Arial;">SQL 20005 foloseste un mecanism de tip<span>&nbsp; </span>copiere la scriere pentru a implementa un snapshot. Aceasta implementare a avut ca scop principal performanta deoarece la crearea unui snapshot exista doar unul sau mai multe fisiere goale iar paginile de date sunt copiate doar daca sunt modificate.</span></p><p class="MsoNormal" style="margin:0in 0in 0pt;"><span style="font-size:9pt;font-family:Arial;">Cand o pagina este modificata pentru prima data in baza de date sursa , este copiata si in database snapshot-ul creat, iar modificarile ulterioare sunt ignorate.</span></p><p class="MsoNormal" style="margin:0in 0in 0pt;"><span style="font-size:9pt;font-family:Arial;">La citirea din database snapshot, paginile nemodificate vor fi citite din baza de date sursa iar paginile modificate vor fi citite din database snapshot.</span></p><p class="MsoNormal" style="margin:0in 0in 0pt;"><span style="font-size:9pt;font-family:Arial;">Pentru crearea unui snapshot cu numele snapshot_name se foloseste sintaxa:</span></p><p class="MsoNormal" style="margin:0in 0in 0pt;"><span style="font-size:8pt;font-family:'Courier New';">&nbsp;</span></p><p class="MsoNormal" style="margin:0in 0in 0pt;"><span style="font-size:8pt;font-family:'Courier New';">&nbsp;</span></p><p class="MsoNormal" style="margin:0in 0in 0pt;"><span style="font-size:8pt;font-family:'Courier New';">CREATE DATABASE snapshot_name</span></p><p class="MsoNormal" style="margin:0in 0in 0pt;"><span style="font-size:8pt;font-family:'Courier New';"><span>&nbsp;</span>ON</span></p><p class="MsoNormal" style="margin:0in 0in 0pt;"><span style="font-size:8pt;font-family:'Courier New';"><span>&nbsp;&nbsp; </span>(</span></p><p class="MsoNormal" style="margin:0in 0in 0pt;"><span style="font-size:8pt;font-family:'Courier New';"><span>&nbsp;&nbsp;&nbsp; </span>NAME=logical_file_name</span></p><p class="MsoNormal" style="margin:0in 0in 0pt;"><span style="font-size:8pt;font-family:'Courier New';"><span>&nbsp;&nbsp;&nbsp; </span>FILENAME=&#39;os_file_name&#39;</span></p><p class="MsoNormal" style="margin:0in 0in 0pt;"><span style="font-size:8pt;font-family:'Courier New';"><span>&nbsp;&nbsp;&nbsp; </span>) [,...n]</span></p><p class="MsoNormal" style="margin:0in 0in 0pt;"><span style="font-size:8pt;font-family:'Courier New';">AS SNAPSHOT OF source_database_name[;]</span></p>