Haslett, Andrew
andrew.haslett at ilc.gov.au
Wed Sep 8 22:34:37 CDT 2004
It depends on what type of recovery requirements you have: * If you wish to restore to any 'point in time' then you should use the FULL recovery model * If you wish to restore to any 'point in time' except those transactions that are not fully logged using BULK Recovery mode, use the BULK-LOGGED recovery model * If you wish to restore only to the times when you've run a Full Database Backup, use the SIMPLE Recovery model. If not already done so, I suggest downloading and reading the applicable sections in 'Books On Line'. It will explain it better than most of us can (for once its actually a pretty decent Microsoft Reference!) Recovery models & logging is an important aspect be understood in SS - It would have decreased your import times if you'd used the SIMPLE recovery model instead of BULK-LOGGED for example... Cheers, A -----Original Message----- From: John W. Colby [mailto:jwcolby at colbyconsulting.com] Sent: Thursday, 9 September 2004 12:43 PM To: dba-sqlserver at databaseadvisors.com Subject: RE: [dba-SQLServer] Gigabit switch The last file imported early this morning so the data is in! Next question, do I need to leave logging off (it's set to bulk actually) until I add the Identity PK? How does logging work in a case like that? Does SQL Server add a log entry for each record that it adds the value into? John W. Colby www.ColbyConsulting.com -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of John W. Colby Sent: Wednesday, September 08, 2004 12:51 AM To: dba-sqlserver at databaseadvisors.com Subject: RE: [dba-SQLServer] Gigabit switch In fact I gave up on bcp because the data is surrounded by quotes. DTS strips them off but I can't for the life of me figure out how to have BCP do that. I'm almost done importing at this point. The imports are (crossing my fingers) proceeding smoothly, I am currently processing file 18 of 22, thus by tomorrow morning I should have them all in. Then I have to figure out backup. IMMEDIATELY! I do NOT want to lose this stuff and have to do it again. John W. Colby www.ColbyConsulting.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com IMPORTANT - PLEASE READ ******************** This email and any files transmitted with it are confidential and may contain information protected by law from disclosure. If you have received this message in error, please notify the sender immediately and delete this email from your system. No warranty is given that this email or files, if attached to this email, are free from computer viruses or other defects. They are provided on the basis the user assumes all responsibility for loss, damage or consequence resulting directly or indirectly from their use, whether caused by the negligence of the sender or not.