Mackin, Christopher
CMackin at Quiznos.com
Wed Jul 14 08:55:24 CDT 2004
You can look at the Jobs and verify the schedule the parts of the plan should be running on and some other info you can verify. -Chris Mackin -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of paul.hartland at fsmail.net Sent: Wednesday, July 14, 2004 3:33 AM To: dba-sqlserver at databaseadvisors.com Subject: Re: RE: [dba-SQLServer] Maintenance Plans Thanks, will have a look at that. Paul Message date : Jul 14 2004, 10:00 AM >From : "Billy Pang" To : dba-sqlserver at databaseadvisors.com Copy to : Subject : RE: [dba-SQLServer] Maintenance Plans perhaps the security login context does not allow the maintenance plans to execute. not sure about ss7.0 but check the sql server agent job history logs to find anything suspicous. >From: paul.hartland at fsmail.net >Reply-To: dba-sqlserver at databaseadvisors.com >To: dba-sqlserver >Subject: [dba-SQLServer] Maintenance Plans >Date: Wed, 14 Jul 2004 10:04:51 +0200 (CEST) > >To all, > >Hope someone can come up with a solution, I have SQL Server 7.0 running on >a Windows 2000 server I also have two of my own database's that I have just >finished transferring to SQL Server. But before I start any front-end work >I decided to use a maintenance plan using the wizard, have just checked the >backup directory where the backups should be and nothing there at all and >the backups don't seem to be anywhere else. > >Why would a maintenance plan not run, anything I can do to check what >happening. > >Thanks in advance for any help. > >Paul Hartland > >-- > >Whatever you Wanadoo: >http://www.wanadoo.co.uk/time/ > >This email has been checked for most known viruses - find out more at: >http://www.wanadoo.co.uk/help/id/7098.htm >_______________________________________________ >dba-SQLServer mailing list >dba-SQLServer at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/dba-sqlserver >http://www.databaseadvisors.com > _________________________________________________________________ MSN Premium includes powerful parental controls and get 2 months FREE* http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=http://hotmail.com/enca&HL=Market_MSNIS_Taglines _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com -- Whatever you Wanadoo: http://www.wanadoo.co.uk/time/ This email has been checked for most known viruses - find out more at: http://www.wanadoo.co.uk/help/id/7098.htm _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com