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 checkingFollowing 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...
>> 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
>>
>sql