excuse my ignornace on switching recovery models

hello,
i just swtiched a database from Full to simple...
1) backed up the database,
2)ran truncate Log in SQl analyser
3) switched to simple
4) ran DBCC shrinkfile
i have a 20 mb database that had a transaction log that grew to 500MB -- i
do no need the logs because this database does not change often... i can
deal with losing one days worth of data.
my question is, Did I mess up anything by doing the steps above? I just want
to be able to restore the main database (no logs) in the event of a
disaster.
i am not sure if somehow i may have lost data...just checking
Following the steps you outlined, you should not have 'lost' any data.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"JM" <j_nospaM> wrote in message
news:OAnsiJKFHHA.2452@.TK2MSFTNGP06.phx.gbl...
> hello,
> i just swtiched a database from Full to simple...
> 1) backed up the database,
> 2)ran truncate Log in SQl analyser
> 3) switched to simple
> 4) ran DBCC shrinkfile
> i have a 20 mb database that had a transaction log that grew to 500MB -- i
> do no need the logs because this database does not change often... i can
> deal with losing one days worth of data.
> my question is, Did I mess up anything by doing the steps above? I just
> want to be able to restore the main database (no logs) in the event of a
> disaster.
> i am not sure if somehow i may have lost data...just checking
>
>
|||great thanks
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:%23gh2gMKFHHA.3540@.TK2MSFTNGP02.phx.gbl...
> Following the steps you outlined, you should not have 'lost' any data.
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to
> the top yourself.
> - H. Norman Schwarzkopf
>
> "JM" <j_nospaM> wrote in message
> news:OAnsiJKFHHA.2452@.TK2MSFTNGP06.phx.gbl...
>