April 3, 2014 at 1:19 pm
We are trying to restore a .BAK from another domain. There are no trusts created and we are told it will stay that way. We don't have enough room to copy the backup file to within the other domain. Is there another way to restore a database using a .BAK from another domain?
Perhaps Proxies?
Thanks.
DentalDBA
April 3, 2014 at 1:46 pm
The same problem I had at my previous job. I solved it by copying .bak file to external hard-drive, brought it to my domain, inserted to a server at my domain and restored it from there. But it was very slow. External hard-drives now available up to 2 TB, hope your backup will fit in there.
April 3, 2014 at 3:59 pm
Best thing to do is get that thing local. Any cross network process you go through is going to be extremely painful.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 7, 2014 at 12:23 pm
Unfortunately copying the backup or creating a trust is not going to happen. I was wondering if there is a way to restore from another domain without a trust? One of the Admins mentioned Proxies, but I don't see how that by itself will work without a trust.
April 7, 2014 at 10:59 pm
You can use tape drive to take backup. Once backup is done in one domain you can use same tape to restore into another domain.
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 8, 2014 at 6:11 am
The only solutions I can think of are these:
1) Air gap the backup file. Copy the backup file to an external hard drive from the source system and restore it to the destination system.
2) Set up an FTP or Secured FTP site at the destination and use FTP to transfer the file from the source to destination.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply