January 5, 2010 at 1:56 pm
Hello -
I'm trying to create a new backup job for a sql server 2000 db in Sql Server Management Studio 2008. I keep getting error messages that point to the Plan ID being wrong. Can someone please help me understand how I get a new plan id or edit the current one?
Thank you in-advance.
David
January 5, 2010 at 4:04 pm
david.ostrander (1/5/2010)
Hello -I'm trying to create a new backup job for a sql server 2000 db in Sql Server Management Studio 2008. I keep getting error messages that point to the Plan ID being wrong. Can someone please help me understand how I get a new plan id or edit the current one?
Thank you in-advance.
David
There are "bugs" non-supported things when using SSMS 2008 with a previous version database engine, such as 2000 and 2005. The plan ID is generated by SQL when you create a new job. You cannot change or edit it.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
January 5, 2010 at 7:29 pm
Hi Shawn -
Thank you for the response. How would you suggest I create the the backup for the SQL 2000 DB using the SSMS 08? I new to the DBA world. My company kinda approached me to ask if I wanted to advance my career.
thanks
David
January 5, 2010 at 8:07 pm
david.ostrander (1/5/2010)
Hi Shawn -Thank you for the response. How would you suggest I create the the backup for the SQL 2000 DB using the SSMS 08? I new to the DBA world. My company kinda approached me to ask if I wanted to advance my career.
thanks
David
David, your best option would be to use the SQL Server 2000 tools to build a maintenance plan for a 2000 system. I am going to guess that you don't have those tools available - if so, then search this site for backup scripts and implement the backups manually using SQL Agent jobs.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 5, 2010 at 9:11 pm
In agreement with Jeffrey, use the tools that came with the version of SQL Server 2000. If the you don't have access from your desktop they would be accessible from the server the instance is running on.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
January 6, 2010 at 5:46 pm
See if you can connect to the server through Remote Desktop, you can access all the tools.
What version of SQL server is installed on the server? and What is installed on your local machine?
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply