http://sqlserver.ro/forums/14/ShowForum.aspxenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlserver.ro/forums/thread/439.aspxThu, 19 Oct 2006 09:35:37 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:439ggciubuc0http://sqlserver.ro/forums/thread/439.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=14&PostID=439<p>Legat de &quot;pedeapsa&quot; - a se vedea interventia mea de mai sus <img src="http://sqlserver.ro/emoticons/emotion-1.gif" alt="Smile" /></p><p>Ideea e ca e bine sa stim si de existenta unor scule third-party care ne-ar putea rezolva problema mai bine, poate decat cele clasice!<br /></p>http://sqlserver.ro/forums/thread/437.aspxThu, 19 Oct 2006 09:20:47 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:437sorinh0http://sqlserver.ro/forums/thread/437.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=14&PostID=437offtopic: Si care ar fi pedeapsa :D ? ontopic: Intradevar am rezolvat cu asistenta din partea Cristi folosind RESTORE LOG , WITH STOPAT ........http://sqlserver.ro/forums/thread/413.aspxTue, 17 Oct 2006 08:22:42 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:413ggciubuc0http://sqlserver.ro/forums/thread/413.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=14&PostID=413Rugamintea mea e o &quot;pedeapsa&quot; pentru neglijenta!http://sqlserver.ro/forums/thread/411.aspxTue, 17 Oct 2006 08:07:46 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:411xmldeveloper0http://sqlserver.ro/forums/thread/411.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=14&PostID=411<p>Am fost contactat ieri pe telefon de Sorin: problema a fost rezolvata intre timp prin clasicul RESTORE LOG ... WITH STOPAT <img src="http://sqlserver.ro/emoticons/emotion-1.gif" alt="Smile" /></p>http://sqlserver.ro/forums/thread/410.aspxTue, 17 Oct 2006 07:45:13 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:410ggciubuc0http://sqlserver.ro/forums/thread/410.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=14&PostID=410<strong><font color="#003399">SQL-BackTrack for Microsoft SQL Server (5.5.00)&nbsp; este un produs third-party (vezi la <a href="http://shop.bmc.com/product_moreinfo.cfm?id=1E6693">http://shop.bmc.com/product_moreinfo.cfm?id=1E6693</a>) daca aveti timp poate testati cum v-ar fi rezolvat problema si ne dati si noua un semnal.</font></strong>http://sqlserver.ro/forums/thread/392.aspxMon, 16 Oct 2006 14:32:16 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:392xmldeveloper0http://sqlserver.ro/forums/thread/392.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=14&PostID=392<p>Sau aici: <a href="http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_bkprst_0cvi.asp">http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_bkprst_0cvi.asp</a></p><p>Din discutiile offline am inteles ca aveti un full backup si atat iar problema a avut loc la 15:58. In acest caz faceti backup la transaction log conform descrierii de mai sus iar pe urma rulati:</p><p>RESTORE DATABASE myDB FROM DISK=&#39;C:\fisierfullbackup.bak&#39; WITH NO RECOVERY<br />RESTORE LOG MyDB FROM DISK=&#39;C:\log.bak&#39; WITH RECOVERY STOPAT = &#39;2006/10/16 15:57:00&#39;</p>http://sqlserver.ro/forums/thread/391.aspxMon, 16 Oct 2006 14:26:18 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:391xmldeveloper0http://sqlserver.ro/forums/thread/391.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=14&PostID=391- Verificati recovery model al bazei de date din Enterprise Manager <br />- Urmati pasii descrisi aici: <a href="http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlbackuprest.mspx#EY3AE">http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlbackuprest.mspx#EY3AE</a>http://sqlserver.ro/forums/thread/390.aspxMon, 16 Oct 2006 14:25:15 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:390sorinh0http://sqlserver.ro/forums/thread/390.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=14&PostID=390<p>Am facut o mare timpenie. Am facut un update pe o tabela cu multe inregistrari si am omis ... cauza de where. Drept urmare updateul a fost facut pe toate inregistarile. Este vreo posibilitate de rollback ? Nu am un backup satsifacator de nou.</p><p>&nbsp;multumiri in avans.</p>