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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment