Drop Table
Support Forum for database administrators and web based access to important newsgroups related to databaseshello, 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
Post Follow-up to this messageFollowing 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 > > >
Post Follow-up to this messagegreat 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... > >
Post Follow-up to this message
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread