Maintenance Plan - Not under Management Folder

Hi,

I installed the SQL Server Management Studio Express this morning and am able to attach to my SQL2000 instance runnng on my laptop. I wanted to confirm my database backup schedules but there is no Maintenance plan under the Management Folder in SQL Server Management Studio Express.

Can someone please assit me in wotking this out..

Regards..

Peter.

Is there a Legacy node (with its own Database Maintenance Plans node) under Management? I'm not sure what happens when you try to manage a SQL 2000 server, but when upgrading to 2005, that's where the 'safety copies' of the old maintenance plans live, since the ones in 2005 are so different that exact conversion isn't always possible.

Due to this, it may not be possible to manage SQL 2000 maintenance plans with the 2005 management tools -- again, this is just a guess from my side, as I just did away with my last SQL 2000 server last week, and can't check.

'//mdb

|||

Hi,

No there's no node under any folder fro even trying to setup maintenance plans, that's my main issue. I currently have scherduled backups performed on my databases each day and I noted when you right click a database you can back it up but not schedule backups so I wanted to look at perhaps setting up a mainteneace paln.

Regards..

Peter.

|||

The maintenance plan UI in Management Studio uses SQL Agent to run a periodic job to perform the maintenance. SQL Agent is not included in SQL Server Express, so Management Studio Express does not include maintenance plan UI.

You should be able to view existing maintenance plans on SQL Server 2000 servers though. Is this not working for you?

|||

Hi,

Yes I came to that conclusion as well after reviewing the comparisons between all versions of SQL 2005 on the Microsoft web site.

No there is no node to view any exisitng or setup any maintnence plans for my SQL2000 instance.

Regards..

Peter.

Maintenance Plan - Not under Management Folder

Hi,

I installed the SQL Server Management Studio Express this morning and am able to attach to my SQL2000 instance runnng on my laptop. I wanted to confirm my database backup schedules but there is no Maintenance plan under the Management Folder in SQL Server Management Studio Express.

Can someone please assit me in wotking this out..

Regards..

Peter.

Is there a Legacy node (with its own Database Maintenance Plans node) under Management? I'm not sure what happens when you try to manage a SQL 2000 server, but when upgrading to 2005, that's where the 'safety copies' of the old maintenance plans live, since the ones in 2005 are so different that exact conversion isn't always possible.

Due to this, it may not be possible to manage SQL 2000 maintenance plans with the 2005 management tools -- again, this is just a guess from my side, as I just did away with my last SQL 2000 server last week, and can't check.

'//mdb

|||

Hi,

No there's no node under any folder fro even trying to setup maintenance plans, that's my main issue. I currently have scherduled backups performed on my databases each day and I noted when you right click a database you can back it up but not schedule backups so I wanted to look at perhaps setting up a mainteneace paln.

Regards..

Peter.

|||

The maintenance plan UI in Management Studio uses SQL Agent to run a periodic job to perform the maintenance. SQL Agent is not included in SQL Server Express, so Management Studio Express does not include maintenance plan UI.

You should be able to view existing maintenance plans on SQL Server 2000 servers though. Is this not working for you?

|||

Hi,

Yes I came to that conclusion as well after reviewing the comparisons between all versions of SQL 2005 on the Microsoft web site.

No there is no node to view any exisitng or setup any maintnence plans for my SQL2000 instance.

Regards..

Peter.

sql

Maintenance Job not working properly

Hi,

I an new to the forum.

I am having some problems where my maintenance job is not backing up the user databases in SQL2000. Unfortunately, I found out the hard way as my payroll in GP did not run properly and I had to do a restore from the BAK file.

I am receiving the following error msg in the event log

Status: Failed - Invoked on: 2006-04-11 22:00:02 - Message: The job failed. The owner () of job DB Backup Job for DB Maintenance Plan 'Daily Backup of User Databases' does not have server access.

I cannot find where and how the user permission was chmaged on this job. I would like some assistance with this problem.

thanks

Raymond

Hi,

Go to Jobs list under SQL Server Agent in the Enterprise Manager.

Find the job for the maintenance plan you have created. Name of the job will include the name of the maintenance plan.

If you open the job properties screen and activate the Steps tab. You will see the "run as user" in the advanced tab of the edit job steps screen.

Check this user for necessary credentials.

Also control the owner of the job in the main job properties screen.

Eralper

Maintenance for SQL 2005 Express:

Maintenance for SQL 2005 Express:How to create a maintenance schedule for 2005 express. In SQL2000 there was Maintenance for creating schedules where did it get moved to in SQL 2.005 express?

since SSIS(SQLServer Integration Service) is not there in the Express, you can not create maintenance plan in SQL Serer Express. You can make your own script and call that using windows scheduler.

You have lot of limitation in Express. If you want more feature you may go for licensed versions

Madhu

|||

SQL Server Agent is NOT included with SQL Express.

You can use a combination of Stored Procedures, SQLCmd.exe, and the Windows Scheduler to create and run your maintenance routines.

And here are some open source projects and guidelines that seem to provide much of the SQL Agent service to SQL Express.

SQL Server 2005 Agent Equilevent for SQL Server 2005 Express
http://www.codeproject.com/vb/net/SQLAgent.asp
http://www.lazycoding.com/products.aspx
http://www.sqldbatips.com/showarticle.asp?ID=27
http://www.sqldbatips.com/showarticle.asp?ID=29

|||

Arnie,

Thanks for your reply it was very helpful.

Harry Gibson

Mail syntax interpreted by sp_processmail

Hello,
I desperately search for example of mail that can be send to an SQL2000 (SQLMAIL) and executed by the sp_processmail procedure.
I really don’t know how a mail intended to be executed be sp_processmail looks like?
Has someone any example?
Thanks
Eric K
Eric,
to get this going is quite straightforward - log onto the SQL Server box
with the same domain user as the SQL Server service. Set up an exchange
profile and set SQL Server to use this profile. From another box, using
another mail profile, send an email to this mailbox with a select statement
in it :
select * from northwind.dbo.region
Back on the SQL box, run sp_processmail.
BOL can explain the intricacies of the sp_processmail syntax, but this
should get you up and going.
HTH,
Paul Ibison
|||Thank for your answer Paul, I finally made this work. In fact I was stuck on a outlook 2000 problem with the password not retained for the access of the POP account: http://support.microsoft.com/default...b;en-us;259416
By
Erick

Mail syntax interpreted by sp_processmail

Hello
I desperately search for example of mail that can be send to an SQL2000 (SQLMAIL) and executed by the sp_processmail procedure
I really donâ't know how a mail intended to be executed be sp_processmail looks like
Has someone any example
Thank
EricEric,
to get this going is quite straightforward - log onto the SQL Server box
with the same domain user as the SQL Server service. Set up an exchange
profile and set SQL Server to use this profile. From another box, using
another mail profile, send an email to this mailbox with a select statement
in it :
select * from northwind.dbo.region
Back on the SQL box, run sp_processmail.
BOL can explain the intricacies of the sp_processmail syntax, but this
should get you up and going.
HTH,
Paul Ibison|||Thank for your answer Paul, I finally made this work. In fact I was stuck on a outlook 2000 problem with the password not retained for the access of the POP account: http://support.microsoft.com/default.aspx?scid=kb;en-us;25941
B
Eric