View Complete Post
Following this thread: Any plans on releasing the source code for WebMatrix itself?
How about those Helpers code?
I tried reflecting into WebMatrix.exe but was unable. I'm interested on how you integrated the WPF Ribbon & the Office-style sidebar.
I have a job that backs up transaction logs and then there is another job within that plan that cleans up .trn files that are older than 48 hours. This job points to the directory where the transaction logs are backed up to. I just created a seperate
maintenance plan to backup transaction logs for a different database. Will the cleanup job for the first backup job also clean up the logs from the second plan or do I need to create another job to cleanup the logs from the
second backup job. My confusion is that the first backup job has specific databases that it is backing up and I'm wondering if that limits what the cleanup job does as well.
After I clicked New Maintenance Plans and filled in <Maintenance Plans Name>, an error appeared like below: General access denied error, my account is already sysadmin and public, and agent service has started.
TITLE: Microsoft SQL Server Management Studio
General access denied error
General access denied error
I have a maintenance plan built on a SQL Server 2005 instance that rebuilds indexes, rebuilds statistics, checks for database integrity, performs a maintenance cleanup, and performs a history cleanup. This job runs once per week.
In the "Reporting and Logging" section I have the following options:
- Generate a text file report is checked
- Create a new file is selected
- A valid destination folder is identified
- Send report to an email recipient is checked
- A valid agent operator is selected
- Log extended information is checked
The job seems to complete successfully and a report is created and emailed, but the only information in the report is as follows:
Quest SLSSQLMaint Utility.
Logging on to SQL Server 'DEVSQL01' with Windows Authentication
Logged on to SQL Server 'DEVSQL01'
 Delete old text report files...
 Execution Time: 0 hrs, 0 mins, 0 secs.
 Send DBMail or SendMail report file....
 Execution Time: 0 hrs, 0 mins, 1 secs.
End of maintenance plan 'DB Maintenance Plan (No Backups) [DB Maintenance]' on 9/29/2010 8:40:49 PM (Success)
C:\Program Files\Microsoft SQL Server\MSSQL.4\MSSQL\Binn\slssqlmaint.exe Process Exit Code: 0 (Success)
Where is the information about the rest of the maintenance plan?&nbs
i've read a few related themes, but i cannot find the one, i hope you can answer my question.
I just cannot see the title to create a maintenance plan. i've read you create one following this steps:
3. In SQL Server Management Studio, expand the Management node, rightclick Maintenance Plans, and then select Maintenance Plan Wizard.
4. On the Maintenance Plan Wizard welcome page, click Next.
5. On the Select Plan Properties page, type a name for the maintenance plan, click Next.
the problem is that i don't have de Maintenance Plans title. My menu node expands like this:
->SQL Server Logs
i need to create a new maintenance plan, but only appear the old m. plan.
I have a Maintenance Plan that have various other subplans. Each subplan has its own schedule. For instance, one will be an hourly log backup, a daily complete backup and a weekly maintenance subplan. Now when ever the log backup takes place, say subplan1
succeeds HOWEVER, the other Subplans subplan 2 and subplan 3 show errors on the error logs. I know that these messages dont matter, however the GLARING X's marks on the Maintenance Plan History does not do service. This way i will have to go in and check each
history. Definitely not as simple as looking at Tick marks on the work well done.
IS there a solution. (other than creating a separate maintenance plan for each subplan)!!!
PLease HELP. Thanks.
Does anyone have any more details on this KB? MS states this happens when you set max memory to a "large value". A hard cutoff here would be more helpful. Also, on the versions list in the KB, SQL2008 Std is not listed, although SQL2005
Std edition is listed. Any help here would be great. Thanks.
I noticed that a stored procedure takes excessively long when it's called from within an application/management studio. I understand what is actually happening, but I do not have a reason for why this is happening.
The difference between the query plan are as follows
ANSI_NULLS: True, ANSI_PADDING: True, ANSI_WARNINGS: True, ARITHABORT: False, CONCAT_NULL_YIELDS_NULL: True, NUMERIC_ROUNDABORT: False, QUOTED_IDENTIFIER: True
ANSI_NULLS: True, ANSI_PADDING: True, ANSI_WARNINGS: True, ARITHABORT: True, CONCAT_NULL_YIELDS_NULL: True, NUMERIC_ROUNDABORT: False, QUOTED_IDENTIFIER: True
The difference here is that ARITH ABORT is on within one plan and is not on with the other one. ARITH ABORT on tends to be faster. Any ideas on how we are encountering this problem and a long term fix. One fix is to alter the procedure and set ARITH ABORT
on, but i am thinking there may be a reason for this.
We've have recently moved a SQL Server database from a local server to a dedicated server. On our local server we had maintenance plans setup to backup the database and they ran fine. The local server had SQL Server 2008 Standard Edition. However on the
dedicated server, although we can successfully set maintenance plans, they are not executing. We are getting the following error message:
"The SQL Server Execute Package Utility requires Integration Services to be installed by one of these editions of SQL Server 2008: Standard, Enterprise, Developer, or Evaluation. To install Integration Services, run SQL Server Setup and select Integration
Services. The package execution failed. The step failed."
The dedicated server has SQL Server 2008 Web Edition and we do not current have a spare license key for a Standard Edtion.
I have read some post on these forums that say if you install Service Pack 2 then maintenance plans will run without using Integration Services, however, we have installed Service Pack 2 and it still does not run.
So a few questions:
- other posts suggest installing the Integration Services component from the Standard Edition we have locally, but does this then become a breach of the licensing for the Web Edition?
- is it possible to purchase just the Integration Services