Viewing 15 posts - 23,611 through 23,625 (of 39,944 total)
Here's the other issue. If you find errors in DBCC, and you've just run your backup, it might be useless. I'd argue you should get the integrity checks done, and...
June 11, 2009 at 1:53 pm
That's a fair point and I'll reword the question and answer and award points back.
Most people working with SQL Server, are laypeople, and to them, Unicode is UCS-2, 2 bytes...
June 11, 2009 at 1:52 pm
That is in vague.
Does the file reside on the SQL Server? Does it need to? Typically SQL Server doesn't write to the file system. It can, but that's not something...
June 11, 2009 at 1:49 pm
Did you add the new disk as a clustered resource? I'm not sure it shows up automatically.
June 11, 2009 at 9:28 am
I would use the T-SQL script that Mani provided. Get used to using scripts, and you could easily set this to run at the end of other maintenance operations that...
June 11, 2009 at 9:24 am
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
Viewing 15 posts - 23,611 through 23,625 (of 39,944 total)