Viewing 15 posts - 23,491 through 23,505 (of 39,819 total)
I would not back up to remote drives directly. If there is any network hiccup, your backup will fail, and that will be the day Mr. Murphy fails one of...
June 11, 2009 at 9:23 am
I haven't seen log corruption before.
Can you make a log backup directly to a new file name?
If not, can you run a full backup? If you can, try BACKUP LOG...
June 11, 2009 at 9:23 am
SQL Server uses the resources it needs for queries. Any query could run the CPU to 100%, and that's fine for short periods of time. If it lasted more than...
June 11, 2009 at 9:19 am
Be sure that you don't need old versions of the packages. Likely you don't, but be sure that people are aware you are getting rid of these.
June 11, 2009 at 9:18 am
That would be a great enhancement for authors. I'll log this and email you your results.
June 11, 2009 at 8:53 am
I'd be happy to host a user group list if anyone wants to let me know. Actually, I'll make an announcement.
June 11, 2009 at 8:48 am
bmitchell (6/11/2009)
Along the lines of writing better software, my manager sent out this piece by Charles Fishman yesterday. He notes that errors are ultimately the result of the process.
Excellent...
June 11, 2009 at 8:47 am
Strange, it seems as though it has to be security/permissions then for the main package. Is there a proxy account you can set just for a test?
June 11, 2009 at 8:46 am
What step is failing? Have you gotten a detailed debug log from SSIS?
June 11, 2009 at 7:40 am
The criteria comes from the scientific method. Take some data about people that left, people that didn't, build a model. It will be wrong, gather more data, tweak, etc.
Will managers...
June 10, 2009 at 9:42 pm
There are tables in msdb that hold some details, but most of the stuff that helps you debug or find issues will be in the logs, which are text files...
June 10, 2009 at 9:33 pm
Mad Hacker (6/10/2009)
My fear is that it could actually contribute to deterioration of the people skills of some managers.
I have no doubt that will happen with some people. Not sure...
June 10, 2009 at 5:12 pm
Correction noted and the explanation fixed.
I'd have thought msdb could be encrypted, though that would add complexity for SQL Agent.
June 10, 2009 at 12:28 pm
Hmm, I was thinking more Barbarians at the Gate, but I guess that works.
June 10, 2009 at 12:26 pm
Viewing 15 posts - 23,491 through 23,505 (of 39,819 total)