Restore from MDF file  
Author Message
kmaki





PostPosted: Tue Oct 26 06:59:21 CDT 2004 Top

SQL Server >> Restore from MDF file

I'm using 2000 version and trying to recover data from MDF file but the
message shows up:

Error 5172: The header for file 'x.mdf' is not a valid database file header.
The FILE SIZE property is incorrect.

SQL Server186  
 
 
swati





PostPosted: Tue Oct 26 06:59:21 CDT 2004 Top

SQL Server >> Restore from MDF file HI!

I want to audit some collumns of one of my huge table . I wrote a trigger
for copying updated data and original data in audit table.
But when I try to update multiple rows , it gives error of "cannot update
multiple rows. "

Is there any easy way of auditing tables without using triggers . I donot
want to use C2-audit .

Regards,
Swati





 
 
Uri





PostPosted: Tue Oct 26 06:55:16 CDT 2004 Top

SQL Server >> Restore from MDF file Hi
How did you try to recover it?
Have you detached the datafile properly?






> I'm using 2000 version and trying to recover data from MDF file but the
> message shows up:
>
> Error 5172: The header for file 'x.mdf' is not a valid database file
header.
> The FILE SIZE property is incorrect.


 
 
Uri





PostPosted: Tue Oct 26 07:04:41 CDT 2004 Top

SQL Server >> Restore from MDF file swati
create trigger tru_MyTable on MyTable after update
as


return

insert MyAuditTable
select
i.ID
, d.MyColumn
, i.MyColumn
from
inserted i
join
deleted d on d.ID = o.Id
go



> HI!
>
> I want to audit some collumns of one of my huge table . I wrote a trigger
> for copying updated data and original data in audit table.
> But when I try to update multiple rows , it gives error of "cannot
update
> multiple rows. "
>
> Is there any easy way of auditing tables without using triggers . I donot
> want to use C2-audit .
>
> Regards,
> Swati
>
>
>
>
>


 
 
swati





PostPosted: Tue Oct 26 08:00:25 CDT 2004 Top

SQL Server >> Restore from MDF file Thanks!! It works properly .

Regards,
Swati



> swati
> create trigger tru_MyTable on MyTable after update
> as
>

> return
>
> insert MyAuditTable
> select
> i.ID
> , d.MyColumn
> , i.MyColumn
> from
> inserted i
> join
> deleted d on d.ID = o.Id
> go
>


> > HI!
> >
> > I want to audit some collumns of one of my huge table . I wrote a
trigger
> > for copying updated data and original data in audit table.
> > But when I try to update multiple rows , it gives error of "cannot
> update
> > multiple rows. "
> >
> > Is there any easy way of auditing tables without using triggers . I
donot
> > want to use C2-audit .
> >
> > Regards,
> > Swati
> >
> >
> >
> >
> >
>
>