http://sqlserver.ro/forums/16/ShowForum.aspxenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlserver.ro/forums/thread/8911.aspxWed, 17 Aug 2011 10:56:44 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:8911buciutacalin0http://sqlserver.ro/forums/thread/8911.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=8911Si eu multumesc pt. sugestii.http://sqlserver.ro/forums/thread/8910.aspxWed, 17 Aug 2011 10:45:53 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:8910Diana0http://sqlserver.ro/forums/thread/8910.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=8910Multumesc pentru update :)http://sqlserver.ro/forums/thread/8909.aspxWed, 17 Aug 2011 08:17:19 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:8909buciutacalin0http://sqlserver.ro/forums/thread/8909.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=8909In final am reusit sa recuperez o parte din date. <br />Am creat o noua baza de date si am copiat toate datele din fiecare tabel din DB-ul defect in cel nou. <br />Doar 2 tabele au fost afectate, adica ultimele inregistrari din acestea erau pierdute, dar am reusit sa selectez cu comanda "SELECT TOP" doar inregistrarile bune.http://sqlserver.ro/forums/thread/8908.aspxTue, 16 Aug 2011 16:18:47 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:8908Diana0http://sqlserver.ro/forums/thread/8908.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=8908Ce mesaje de eroare ai primit?http://sqlserver.ro/forums/thread/8907.aspxTue, 16 Aug 2011 14:11:38 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:8907buciutacalin0http://sqlserver.ro/forums/thread/8907.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=8907-baza de date (fisierul .mdf) are o marime de 720 MB. <br />-nu exista backup <br />-CHECKDB l-am rulat azi dimineata dar a lucrat timp de o ora dupa care l-am oprit fortat, in Event Viewer apareau mesaje de disk erorr din 3 in 3 secunde in timpul acestei operatii <br /> <br />http://sqlserver.ro/forums/thread/8906.aspxTue, 16 Aug 2011 14:06:09 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:8906Diana0http://sqlserver.ro/forums/thread/8906.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=8906Si cand ai rulat ultima data DBCC CHECKDB?http://sqlserver.ro/forums/thread/8905.aspxTue, 16 Aug 2011 14:02:21 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:8905Diana0http://sqlserver.ro/forums/thread/8905.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=8905Ai veun backup "curat" si rezonabil de recent? <br />"Prim ajutor" de aici: <br />http://www.sqlservercentral.com/articles/Corruption/65804/ <br />Pentru mai incolo: <br />http://www.sqlskills.com/BLOGS/PAUL/category/CHECKDB-From-Every-Angle.aspx <br />Cat de mare e baza de date? Ce "rezultat pozitiv" astepri? <br />http://sqlserver.ro/forums/thread/8904.aspxTue, 16 Aug 2011 13:36:21 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:8904buciutacalin0http://sqlserver.ro/forums/thread/8904.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=8904Buna! <br /> <br />Stie cineva cum as putea repara/recupera datele dintr-un fisier .mdf ? <br />Mentionez ca fisierul nu mai poate fi copiat, afisand eroarea: cyclic redundancy. <br />Marimea fisierului 720 MB. <br /> <br />In MS SQL Management Studio am incercat cu comanda: <br /> <br />EXEC SP_RESETSTATUS 'mydatabase' <br />ALTER DATABASE mydatabase SET EMERGENCY <br />dbcc checkdb ('mydatabase') <br />ALTER DATABASE mydatabase SET SINGLE_USER WITH ROLLBACK IMMEDIATE <br />dbcc checkdb ('mydatabase', REPAIR_ALLOW_DATA_LOSS) <br />ALTER DATABASE mydatabase SET MULTI_USER <br /> <br />dar a rulat timp de o ora, fara nici un rezultat pozitiv. <br /> <br />Va multumesc.