Home > Archive > MS SQL Server > November 2006 > excuse my ignornace on switching recovery models









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author excuse my ignornace on switching recovery models
JM

2006-11-30, 7:14 pm

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




Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2009 droptable.com