Viewing 15 posts - 5,821 through 5,835 (of 19,564 total)
It appears that the backup was not a complete backup and just had file fragments. Did you format because of checkdisk or scandisk errors?
July 31, 2012 at 4:32 pm
Nope. I mean the location on disk where the maint plan is trying to access to write backups, logs, or delete files. Have you tried running the steps...
July 31, 2012 at 4:30 pm
Well, since you can't alter the database, I don't think there is a good way to solve this issue.
Personally, I would opt for an attribute or for an additional table...
July 31, 2012 at 4:28 pm
I presume you are able to create, delete, alter files in the location referenced in the maintenance plan?
July 31, 2012 at 4:21 pm
Michael Valentine Jones (7/31/2012)
Lynn Pettis (7/31/2012)
July 31, 2012 at 4:06 pm
Same versions exist on the other servers that work?
Do you have access to a different installer to test that?
July 31, 2012 at 4:04 pm
mrtrich99 (7/31/2012)
Messages
Execution failed. See the maintenance plan and SQL Server Agent job history logs for details."
There was no log file in the maintenance plan...
July 31, 2012 at 4:02 pm
Grant Fritchey (7/31/2012)
July 31, 2012 at 4:01 pm
What version of .Net is installed?
July 31, 2012 at 3:55 pm
how frequent is your log backup being performed?
July 31, 2012 at 12:48 pm
Rather than reorganizing all indexes every sunday, why not break it up into smaller pieces and do a bit of the re-org on multiple nights?
July 31, 2012 at 12:07 pm
Sean Lange (7/31/2012)
July 31, 2012 at 12:02 pm
MyDoggieJessie (7/31/2012)
Start SQL with the /f parameter and traceflag 3608 on.
eg net start mssqlserver /f /T3608
however,
Connect to SQL via the...
July 31, 2012 at 11:59 am
GilaMonster (7/31/2012)
SQLRNNR (7/31/2012)
GilaMonster (7/31/2012)
Grant Fritchey (7/31/2012)
GilaMonster (7/31/2012)
Brandie Tarvin (7/31/2012)
Gail, got any completed science fiction / fantasy novels in your dresser drawer?No, nothing at the moment.
But you have a vaca coming...
July 31, 2012 at 11:23 am
Viewing 15 posts - 5,821 through 5,835 (of 19,564 total)