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.
No comments:
Post a Comment