Viewing 15 posts - 61 through 75 (of 101 total)
My work around was to make the owner of the package the same as the account running the package. I have Admin level rights and so did the agent but...
August 15, 2007 at 1:10 pm
A very helpful tool in this is the help button in the tool bar. It allows for one to select "How do I" and then once it is open type...
August 15, 2007 at 1:03 pm
Another option is to do a full backup of the database. Remove the database from the system and do a restore from your backup to the correct drives.
You may not...
July 31, 2007 at 7:14 am
What version of SQL2k5 are you on? That could be an issue. I have run into this issue when a process is still holding on to some process while the...
July 17, 2007 at 2:57 pm
Also view and install from KB934458 at the very minimum for running maintenance plans. This should bring you up to 9.00.3054.
July 6, 2007 at 6:26 am
What version are you on? Do you do a verify backup? Did you set up for reports to be generated and emailed to you? Sometimes looking at that will show you...
July 6, 2007 at 6:18 am
After you shrink your databases why not change recovery mode from full to simple as you say you don't need them in a development database.
July 6, 2007 at 6:15 am
I also am confused as to why to change database mode from full to simple and back again. I keep some of my databases as simple recovery as the requirements...
July 5, 2007 at 8:20 am
Did you disable all the sql services before doing the install?
June 27, 2007 at 7:41 am
I had to write a custom script to shrink the log files also. The only options in the maint plans was to shrinkdatabase! No Thanks!
June 15, 2007 at 9:32 am
Is there any real need to do your rebuild of the indexes and reindexing nightly? It is a process heavy routine. Would once a week work for your enviornment? The...
June 14, 2007 at 6:22 am
Through trial and error this is what my solution is at our location. DB's are required 24/7 availablity. 27 databases on one server range from 2GB to 40GB so this...
June 8, 2007 at 6:58 am
Greg
They are stored under local packages, we don't have anything stored in Meta Data Services.
May 10, 2007 at 2:33 pm
The jobs are all there, and no other oddities. Additionally if the DTS package shows up blank on the EM on the server, the jobs run for 1 second and...
May 10, 2007 at 1:54 pm
The Packages are stored on the server and have not been altered for a long time.
May 10, 2007 at 11:59 am
Viewing 15 posts - 61 through 75 (of 101 total)