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!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by 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...- DBASkippack
- Post #4
- Forum: Microsoft SQL Server: Setup and Administration
-
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 --...- DBASkippack
- Post #2
- Forum: Microsoft SQL Server: Setup and Administration
