View Complete Post
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.
I get the following error when this perl script tries to backup the database using ASCMD.exe 2008 command line tool
<return xmlns="urn:schemas-microsoft-com:xml-analysis"><root xmlns="urn:schemas-
l-analysis:exception" /><Messages xmlns="urn:schemas-microsoft-com:xml-analysis:
exception"><Error ErrorCode="3239313412" Description="Errors in the metadata man
ager. Either the database with the ID of 'xyz_old' does not exi
st in the server with the ID of 'ABCD\Sql_AS', or the user doe
s not have permissions to access the object." Source="Microsoft SQL Server 2008
Analysis Services" HelpFile="" /></Messages></root></return>
I have tried using different account for impersonation but everything fails.
Any help would be really appreciated.
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 am running a maintenance plan (Sql Server 2008 Enterprise) every night at mid-night. All the plan entails is doing a full backup of one database (about a 3GB database). We are getting timeouts on our site at exactly that point when the database is being backed up and they last up to 20min. I was under the impression that doing backups this way does not take the db down? Or am I wrong about this?
Has anyone else experienced this and if so what steps did you take to rectify it? Sorry if I have not provided other information, just let me know and I will give it to you.
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.
The SA is trying to backup the config manager under the maintenance plan. However, she is getting an error saying it cannot find the path under that backup file. I was wondering if she even needs to backup the config manager since it is part
of the management studio application. Does anyone know if it needs to be backed up or not?
Thank you for your help.
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.