Recovering using the transaction log

I have a database hosted on a comercial web server
I can access it using SQL server Entreprise Manager
I have never backed the database up though i copy it
regularly.
Exactly how do you recover the database to an earlier point using the
Transaction Log and can it be done to recover 'Dropped' objects
Help gratefully received regards EarnieMost probably you have to revert to one of your older copies. You *might* be
able to use any of the
log reader tools out there, but as you never backed up the database, then mo
st probably the log
records needed to undo the modifications aren't around anymore in the transa
ction log files of the
database. See my article on the subject at:
http://www.karaszi.com/SQLServer/in...veral_times.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Earnie" <Earnie@.discussions.microsoft.com> wrote in message
news:A6434B02-D7BA-4E6D-ABD7-E5D177DBAF4F@.microsoft.com...
>I have a database hosted on a comercial web server
> I can access it using SQL server Entreprise Manager
> I have never backed the database up though i copy it
> regularly.
> Exactly how do you recover the database to an earlier point using the
> Transaction Log and can it be done to recover 'Dropped' objects
> Help gratefully received regards Earniesql