April 13, 2009 at 11:02 am
Hi,
My problem is quite simple, previously we used to back up our database in 160 GB external hard drive and now I want to backup all those database in new 1 TB external hard drive. In order to do so I wanted to use Maintenance plan, but unfortunately there is no Maintenance plan under my Management folder.
But under SQL Server Agent/ Jobs there are jobs that make previous daily backups. Those jobs were created by previous Administrator so I don't know how he created.
Are there any way through which I can get back Maintenance plan or create new job that can make backup each day.
Please look at the screen shot that I have attached
Thanks
April 13, 2009 at 11:12 am
Maintenance plans are only available on SQL Server 2005 and greater. Looks like you are connecting to a SQL Server 2000 system.
Try opening the Legacy folder and see if you can find any legacy maintenance plans. But, I would guess that the backups were not done with maintenance plans. In that case, you will need to modify the agent jobs directly.
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
April 13, 2009 at 11:41 am
I am pretty sure it is MS SQL 2005 and and I tried to edit the jobs but there was nothing to edit.
April 13, 2009 at 11:49 am
Can you run SELECT @@VERSION to verify?
Or, look to the right of the server name and verify the server you are connected to has a version of 9.0.xxxx or greater and not 8.0.xxxx.
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
April 13, 2009 at 11:54 am
After running SELECT @@VERSION Query I got the following result.
Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48 Copyright (c) 1988-2000 Microsoft Corporation Developer Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
And it shows it is SQL 2000, but my SQL Server Management Studio is 2005.
I think the previous administrator upgraded the SQL Server to 2005 from 2000.
Now what are my options.
Can you please help me.
April 13, 2009 at 11:59 am
The server you are running is 2000 - you can modify the agent jobs as needed. You should look at upgrading to SQL Server 2008, but that really depends upon whether or not your system will work after it has been upgraded.
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
April 13, 2009 at 12:12 pm
Thank you very much I think I can figure it out how to change the job logs.
I have access to SQL 2008 but I am not sure all will work perfectly.
If this process doesn't go through, then I will surely try to resolve the problem by installing SQL 2008.
Thanks again.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply