Backup across remote servers - SQL Server Forums

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

Backup across remote servers

Author

Topic

delpi767
Starting Member

11 Posts

Posted - 2009-09-07 : 11:26:16

Using Microsoft SQL Server Management Studio I am able to connect to my web host's SQL server and to my local SQL Server.

Is there a practical way to backup the host's database or at least tables to my local server?

Perhaps something like a "select into" across servers?

I know I can do this with the import/export wizard but, at least for me that's a bit time consuming. I want something a bit more streamlined.

Thanks,

Mac

Regards,

-dmd-

MonikaK
Starting Member

6 Posts

Posted - 2009-09-08 : 07:50:06

Hi,
there are following ways you can get the data from your server to your local database:
1. Detach/Attach
2. Copy Database Wizard
3. Restore

I strongly recommed backing up the database on the server, copy over the back up to your local machine and restore it on the local database.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources