Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Resoring SQL svr DB without backups of MDF file

0 views
Skip to first unread message

kcup

unread,
Apr 10, 2002, 8:46:20 AM4/10/02
to
Can you restore / rollback to a certain point using your live MDF and
LDF files? I.e. If you're thick enough NOT To have any backup of
either file?

Alexander Chigrik

unread,
Apr 10, 2002, 12:46:40 PM4/10/02
to
No, you cannot. After transaction was committed, you cannot rollback it.
You should have backup to restore/rollback to a certain point.

With best regards,
Alexander Chigrik
http://www.MSSQLCity.com/ - all about MS SQL
(SQL Server Articles, FAQ, Scripts, Tips and Test Exams).


"kcup" <kett...@tesco.net> ???????/???????? ? ???????? ?????????:
news:e0964ec8.02041...@posting.google.com...

BP Margolin

unread,
Apr 10, 2002, 6:42:11 PM4/10/02
to
kcup,

See if Log Explorer from www.lumigent.com can help you.

-------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.

"kcup" <kett...@tesco.net> wrote in message
news:e0964ec8.02041...@posting.google.com...

0 new messages