SQL 2008 - DB Backup over the web

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.

All Forums

General SQL Server Forums

New to SQL Server Administration

SQL 2008 - DB Backup over the web

Author

Topic

gman2010
Starting Member

3 Posts

Posted - 2010-03-01 : 13:35:36

Hi Forum,

I'm trying to find out if it is possible to backup a remote SQL 2008 database over the internet to my local machine using server management studio or any 3rd party utility.

I need to ensure that I obtain a full backup of the database with data and table structure etc. To date, I have only been able to backup the database to the local machine it is hosted on and unfortunately I am unable to gain FTP access to this file.

I've tried using the import and export 32 bit utility and although this completes successfully there is a huge difference in size between the two DB's. Our live online database is around 650MB and after the import/export process is complete the new database it has imported to on my machine is only 35MB so there is obviously something missing here. I thought this utility would create a copy database that I could then backup but I am obviously missing something

Comments welcome and thanks in advance, your help is appreciated.

gman2010
Starting Member

3 Posts

Posted - 2010-03-02 : 05:56:54

Can anyone please point me in the right direction here...I've been searching the net for hours now. Thanks in advance.