|
|
Posted by Simon Hayes on 05/25/05 20:52
<mark_drewersback@yahoo.co.uk> wrote in message
news:1117042116.016174.212890@g49g2000cwa.googlegroups.com...
> Hi All
>
> Bit of a situation so hopefully someone can advise.
>
> I've a client who has a sql 2000 database that *unfortunately* hasn't
> had a backup procedure in place. Its been running for just over a year
> and on Monday it got, well, screwed. They have a 50 gig ldf file.
> Yes, 50 gig. Is it possible to put in place a database maintenance
> plan that will allow me to roll back to, say, last friday just from the
> ldf file?
>
> Thoughts? Any advice would be welcome.
>
> MTIA
>
> Mark
>
Most of the transactions in the log have presumably already been committed
to the database, so you could try sp_attach_db and/or
sp_attach_single_file_db, but there's no guarantee they will work (and you
don't say exactly what "screwed" means, so you might not even have the .mdf
anyway).
Apart from that, your most best option is probably to call Microsoft and see
what they can do - there's no other way to recover data directly from
unattached mdf/ldf files. If there's a year's worth of business data in
there, then the cost of getting Microsoft involved is most likely negligible
compared to the value of the data.
Simon
Navigation:
[Reply to this message]
|