Remote database backup -- sql server dts

Kevin3NF
5/27/2005 9:32:01 AM

You do backups to network shares using UNC as the device:

\\server\share\whatever.bak

Or try the copy objects selection in the DTS wizard to get all objects.
Backup/restore is preferred :-)

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

www.experts-exchange.com - experts compete for points to answer your
questions

[quoted text, click to view]

Jordan
5/27/2005 2:06:19 PM

I need to backup a database on another server. And, unfortunately, I don't
have permission to write to the hard drive on that server.

The only way I can think to do it is table by table, using DTS. I would
need to keep the DDL and sync and then for each table, truncate the
destination and use a Transform Data Task to pull the data across.

Does that sound like a good approach?

Are there any simpler approaches I'm missing?

Thanks!

sql server dts : Remote database backup