I have some Log files that are getting extremely large as I teach myself the importing/Exporting/Tranformation 's and such. I need to shrink the Log file to a manageable size. The data file is 16gig and the log file is 16gig. Help..dbcc shrinkfile(...) Look it up in BOL|||Consider also:
1. Backup the database and then make log file backups. Run a log file backup after doing an import.
2. Or, set your recovery model to SIMPLE (SQL 2000) or Trunc. Log on Checkpoint (SQL 7).
Regards,
hmscott
Showing posts with label tranformation. Show all posts
Showing posts with label tranformation. Show all posts
Wednesday, March 21, 2012
Subscribe to:
Posts (Atom)