Minatanace plan for backup
-
yes i can make a back up without backup device....
but my problem is with maintenance plan I cannot make a plan to schedule a backup, as example (make full back up in every Sunday) it gives an error.....that i sent it before..
-
Can you do a maint plan to backup to disk (not to a backup device)?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
no i cannot make a plaint even without a backup device.....
-
Can you check the versions that I asked about above?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
OK sure thank you for your replay... but please let me till tomorrow because i am out of office now i can access it now till tomorrow... I can post the version of SQL Server tomorrow....
-
This the version:
Microsoft SQL Server 2005 - 9.00.3068.00 (Intel X86) Feb 26 2008 18:15:01 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
-
And what's the version of your client tools? Help - about management studio.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
Actually in our system we use the SQl server to store the spatial data (geodatabase) , so clients are using the ArcEditor (ESRI product) to connect to the SQL server..... we are not installed the client toll in there machine because thy don't need it....
-
So where did you set the maintenance plan up from?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
On the server directly...
-
Just check the version of that management studio, make sure that the patch did successfully patch the client tools.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
Microsoft SQL Server Management Studio version:9.00.3042.00
-
Do you have more sql 2005 sp 2 server from which you can connect? If the answer is "yes", you can try to create a maintenance plan from one of these servers.
-
no we have one SQL server ,actually i downloaded the patch but it still have same problem with the maintanant plan....and the version of the SQL server still same not change even after applying the patch...
-
Did the installation of the patch give any errors?
I think you may want to take this issue to Microsoft's customer support. They're probably going to be able to help you more.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass
Viewing 15 posts - 16 through 30 (of 33 total)
You must be logged in to reply to this topic. Login to reply