New answers tagged

6

Is there any way at all to restore these files? No. The long answer is like this: you first will have to fix the MDFs. Attempt to attach it with ATTACH_REBUILD_LOG as you encounter errors (like incorrect pageid (expected 1:134; actual 0:0). It occurred during a read of page (1:134)) you have to edit the file and fix it. This, of course, requires you ...


2

@RayofCommand, has already given an appropriate answer, but will like to add more which is very helpful and easy to track for any corrupt databases using SQL Server Integrity Check from ola hallengren. Is the maintenance plan Check Database Integrity Task enough ? Well, for this should check some more details on this as explained by Kendra on DBCC ...


4

Good question. The integrity check in the maintenance plan is enough since it will run a dbcc checkdb. From MSDN: integrity check The Check Database Integrity task encapsulates the DBCC CHECKDB statement. Running this task will be resource intensive. You don't want to do this in prod. servers if you don't have a maintenance window. The common way is ...



Top 50 recent answers are included