Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: DBASkippack
  • Order by date
  1. DBASkippack

    How to get the least amount of transaction log activity

    I had a very similar situation as you. I also opted to BCP OUT, TRUNCATE, DROP, BCP IN - yaddy ya. Then I stumbled across this simple solution: If you have a datetime to work with, use the SET ROWCOUNT feature to do a Transactional DELETE. I was able to DELETE about 1M rows / minute using...
  2. DBASkippack

    Backup 120 databases - Script?

    I recommend creating SQL Maintenance Plan (read BOL - Simple to Set up in SQL Server) But if you really want a stored proc, I've attached one -- this will backup your LOGS & Databases w/out any downtime. You can execute this concurrent w/ your online & batch applications. Here ya go --...

Part and Inventory Search

Back
Top