I'm having difficulties to setup a daily backup schedule in SSMS 2008 R2 Developer Edition.
This is exactly what I'm trying to achieve: My SSMS connect to my DB (remotely), which located at some hosting service.
I'm looking for some script (or other way) to get into the query(in the SSMS, or even better - in "MyLittleAdmin" tool) that will backup my DB in a daily basis.
I'll appreciate any further help.
I'm sorry for the disinformation, I'll answer all of the questions that showed up:
@DaniSQL - Yes. I got access to the DB through my hosting service tool from Rackspace (MyLittleAdmin) and through SSMS.
- In SSMS for some reason the "Maintenance Plans" folder doesn't shows up in the Object Explorer when I'm connecting (remotely) to the DB which located at my hosting service servers. But, when I download the bak file locally to my PC, and connect him to SSMS, it shows up.
(I assume that the hosting service doesn't allow me to create plans/jobs?)
@ Chris S - As I wrote above, the maintenance plan disappears when I connect to the DB remotely (By entering the IP&PORT of the server to the SSMS)
And for the last answer from @DaniSQL:
This is look good enough, though it seems that I can't run jobs in SSMS. If I'll put this script in a new query through Rackspace SQL Management tool (MyLittleAdmin), it will work?
I just want to automatically backup and restore my DB on a daily basis.
Thank you very much for your help guys!