December 10, 2012 at 8:57 am
Hi all,
Task: I need a T-SQL HTML script,fetch a file from different domain.For this I am working in different domains.
Domain 1: I am having my backup file.
Domain 2: I have to fetch that files from domain-1 to this domain-2.Backup file has to be present in this system drive(e.g D:\ drive)This step has to be run through job in regular bases.(Day to day it should happen).
Restore can be done by RESTORE statement.But I need that file from domain-1 how can fetch friends.
Can you kindly provide me how to fetch backup file from different domain.
Note : I cant use XP_CMDSHELL in my environment.So I am unable to use XP_CMDSHELL cmd in my script.Give me some good solution to this.
Thank You All.
December 10, 2012 at 9:37 am
So far as I know, there's no such thing as a T-SQL HTML script, so I'm not entirely clear on what you're trying to do.
From what I do understand, you need to get a backup file from a different server, and then restore that file on your server. Is that correct?
If so, then there are a lot of ways to do that. Probably the easiest is an SSIS package. Depending on where you are getting the file from, use either an FTP task to download it, or a file-system task to copy it, and then you can run the restore.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 12, 2012 at 1:51 pm
SSIS is the best tool for this.
-- Itzik Ben-Gan 2001
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply