RE: Maintenance Plan
From: Ananth Padmanabham [MSFT] (ananthp_at_online.microsoft.com)
Date: 10/08/04
- Next message: Ananth Padmanabham [MSFT]: "RE: problem installing client (Windows 2000 machine)"
- Previous message: Ananth Padmanabham [MSFT]: "RE: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection"
- In reply to: Thom: "Maintenance Plan"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 08 Oct 2004 22:24:27 GMT
The best way to get sarted with Maint Wizard (or any of these admin tasks)
is to start playing with it and get a feel of the things it can do and
cannot do. In this case, the DB Maint Wizard is used to for performing
backups/restores/checkdbs/dbreindexes etc. Also you can schedule these same
basic tasks for recurrence through SQL Agent jobs.
Database Maintenance on SQL Server 7.0/2000 (875193)
http://support.microsoft.com/?id=875193
You might need this one too :)
INF: Troubleshooting Database Maintenance Plan Failures (288577)
http://support.microsoft.com/?id=288577
Thanks,
Ananth Padmanabham
Microsoft SQL Support
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
--------------------
| Content-Class: urn:content-classes:message
| From: "Thom" <anonymous@discussions.microsoft.com>
| Sender: "Thom" <anonymous@discussions.microsoft.com>
| Subject: Maintenance Plan
| Date: Tue, 5 Oct 2004 14:45:59 -0700
| Lines: 9
| Message-ID: <2d0f01c4ab24$b3d9bc20$a501280a@phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Thread-Index: AcSrJLPZ8sRSKi5zRJiEJxAoHFb/Pw==
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Newsgroups: microsoft.public.sqlserver.setup
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.setup:66841
| NNTP-Posting-Host: tk2msftngxa13.phx.gbl 10.40.1.165
| X-Tomcat-NG: microsoft.public.sqlserver.setup
|
| I posted this in tools, but decided this is probably
| where it should be.
|
| I am new to SQL Server and am wondering if there is a
| step by step guide on setting up the Maintenance Plans
| and what the difference options are used for.
|
| Thom
|
|
- Next message: Ananth Padmanabham [MSFT]: "RE: problem installing client (Windows 2000 machine)"
- Previous message: Ananth Padmanabham [MSFT]: "RE: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection"
- In reply to: Thom: "Maintenance Plan"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
