Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
KJensen
Starting Member
12 Posts |
 Posted - 2009-03-21 : 17:13:24
|
| 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, but cant access the filesystem to download the backups, I create.What are my options? Can I setup something remote, that backs it up? |
|
|
KJensen
Starting Member
12 Posts |
Posted - 2009-03-21 : 17:56:33
|
| I placed this in the wrong subforum, sorry! Mods feel free to move it. |
 |
|
|
cshah1
Constraint Violating Yak Guru
347 Posts |
Posted - 2009-03-21 : 20:32:18
|
| Create a scheduled SQL Server job that will perform a backup (I believe you will save it on the remote sql server machine) |
|
|
|
KJensen
Starting Member
12 Posts |
Posted - 2009-03-22 : 05:25:03
|
| ...But I don't have access to the filesystem on the remote server, so I have no way of getting a backup out (that I know of). |
|
|
|
matty
Posting Yak Master
161 Posts |
Posted - 2009-03-23 : 01:26:50
|
| You may create a job to perform back up on local machine as follows.declare @f sysnameset @f =N'\\yourmachinename\foldername\dbname.bak'BACKUP DATABASE dbname TO DISK = @f |
|
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2009-03-23 : 05:29:54
|
| Link below has an interesting alternative for <1GB backups by saving backup to a table and retrieving data from table:1.Make a backup on a swap file on the server 2.Create a temporary table with a varbinary field 3.Insert the backup into the table 4.Fetch column data using ADO.NET 5.Save the stream in a file http://www.codeproject.com/KB/database/afplocalbackupfromremote.aspx |
|
|
|
|
|
|
Backup database hosted remote