I am lookinh for an example of how to use XML Bulk Load to load data to a sql table. I have a url access that returns mutiple rows of data that I wish to load to a table. when I access the url I get this back in a browser window:
<?xml version="1.0" ?>
- <zip-three-coverage...
Ned some ideas, when ever I try to use the built in wizard to move/copy a database from one sql server to another it fails with a general error message:
Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description:Unspecified error
Step Error code: 80004005...
Thanks for the quick reply, I too assumed you could backup to anywhere on the network. I am using the enterprise manager interface and it only sees the local drives.
Do you run your back ups from the command line?
using something like :
-- Create the backup device for the full MyNwind...
I am afraid I know the answer but just in case here is my dilemma:
I have a lot of network storage but I also have a sql server that has a 60bg drive holding a 40gb database. So far I can find no way to back up this db except by doing a file copy. I really need to backup this data along with...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.