March 20, 2014 at 8:53 am
I am currently running SQL Server 2008R2 on Windows Server 2008R2.
I am remotely connected to a Windows 2003 Server that has SQL Server 2000 databases via a VPN. (I have tried to get them to upgrade SQL Server but they simply refuse to consider it).
I know that I can successfully connect via my SQL Server 2008R2 SSMS to the remote SQL Server 2000 database and perform queries.
My question is does anyone know if there are any problems with creating new Maintenance Plans on the SQL Server 2000 databases via my SQL Server 2008R2 SSMS?
Thanks
Howard
March 20, 2014 at 8:55 am
The maintenance plans between versions are significantly different.
You won't be able to create those plans in that way.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 20, 2014 at 9:02 am
Jason:
Thank you for the fast reply.
What are your thoughts on me installing the old SQL Server Enterprise Manager on my Windows 7 computer (if that is even possible) and handling the Maintenance Plans that way?
I am looking for a way to handle the maintenance plans remotely.
Thanks
Howard
March 20, 2014 at 9:17 am
That should work.
I have installed EM on Win7 in the past and gotten it to work.
Another option would be to convert those MPs to script based routines.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 20, 2014 at 9:27 am
Jason:
Wouldn't script based routines still have to be installed as a maintenance plan?
Howard
March 20, 2014 at 10:40 am
No.
You just add the sql agent job to execute each of your required scripts.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 20, 2014 at 10:49 am
Jason:
Pardon my ignorance on this but I just want to make certain I understand you.
Are you saying that I can do the following:
Using SSMS connect to the remote SQL Server 2000,
In Object Explorer click on SQL Server Agent,
Right click on Jobs under SQL Server Agent,
Click on New Job and enter the new scheduled job information,
and this should work with any problems.
Thanks
Howard
March 20, 2014 at 11:04 am
hmbtx (3/20/2014)
Jason:Pardon my ignorance on this but I just want to make certain I understand you.
Are you saying that I can do the following:
Using SSMS connect to the remote SQL Server 2000,
In Object Explorer click on SQL Server Agent,
Right click on Jobs under SQL Server Agent,
Click on New Job and enter the new scheduled job information,
and this should work with any problems.
Thanks
Howard
I have done that many times.
You can create a new job for sql 2000 from the 2008 SSMS to run your individual maintenance scripts. As a script goes, you write a tsql script to perform the index maintenance or the backups or to do any of the routine things to keep your database fit and proper. That is completely possible.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 20, 2014 at 11:10 am
Jason:
Thank you again for taking the time to answer my questions.
It is greatly appreciated.
Howard
March 20, 2014 at 11:18 am
You are welcome.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply