March 22, 2009 at 3:43 am
Hi
I have a database hosted remote, where I have access in Management Studio etc, but not to the file-system of the server.
I want daily backups or more, but cant access the filesystem to download the backups, I create.
What are my options? Can I setup something locally, that backs up my remote database?
March 22, 2009 at 6:29 am
DonKraft (3/22/2009)
HiI have a database hosted remote, where I have access in Management Studio etc, but not to the file-system of the server.
I want daily backups or more, but cant access the filesystem to download the backups, I create.
What are my options? Can I setup something locally, that backs up my remote database?
You dont have to have any access to the file system. What permissions have u got on the database? At the least you should have db_backupoperator?
March 22, 2009 at 6:36 am
I do have db_backupoperator rights.
March 23, 2009 at 11:20 pm
This remote server what kind of control or access can you get to it? Where is it located? Same network or on-line service provider?
If you don't have access to the file system on the server; then doing backups become difficult. But you can backup directly to a network UNC path, but thats where the server location question comes in...
Thanks.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 24, 2009 at 2:24 am
It is a remotely hosted somewhere on the net, I don't have LAN-access to it, unfortunately.
It looks like I will have to rely on my providers backup-services (one time a day) until I move the database to something I control myself.
March 24, 2009 at 7:25 am
Sorry ...
But if you can connect to it using SSMS and you database is not very big maybe exporting a copy for your safety might be an option..
Mohit.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply