Actually...I am doing backups from a couple dozen servers...all .bak's ranging in size from 5-28GB. On average, I would say 15GB in size. I was...
Is there not a way to backup a database and compress the .mdf while it is backing up? Do I have to invest in a third party tool like Red-Gate's SQL...
Thanks for all your help everyone. I am going to take some time and examine the transactions. There has to be some long running transaction that is...
Thanks for your response. Quick question...I tried to run a trace in profiler to check out what commits/rollback/etc. if any were causing this. I got...
Thanks for the response Waqar. I can try this...but isn't this just a correction to the job I have scheduled? I'd like to see if I can just eliminate...
We only have a maintenance plan to backup one db. I had actually added a job every hour to do a dbcc shrinkfile (db_log, n) to keep the log file to a...
We actually have always had the recovery model set to simple. Sorry I didn't include that sooner.
We have an issue with a DB server's log file growing in large proportions. Current settings are to automatically grow/10 MB/unrestricted file growth....
Separate names with a comma.
