I have a script that restores a SQL 2000 db from server A on the network to
server B on the network without any hickups.
Now I have the challeng to restore a db from Server B which is NOT on the
network to server A which is on the network.
Any ideas on how I can connect to a server that is not on the network to
restore a backup to one that is on the network. I have a local account to
that computer.
Thanks in advance
ChanderI'm not sure what exactly you meant by 'not on the network'. If it is not on
the network as in not having any network connectivity to it, you would have
to copy the backup file using some detached media such as a tape or CD if
it's small enough.
But if it meant not in the same domain but reachable on the network, the
solution is easy. You can always create an authenticated session first using
NET USE with your local user account (assuming necessary ports are not
blocked) before you copy the file or do the restore.
Linchi
"stoney" wrote:
> I have a script that restores a SQL 2000 db from server A on the network to
> server B on the network without any hickups.
> Now I have the challeng to restore a db from Server B which is NOT on the
> network to server A which is on the network.
> Any ideas on how I can connect to a server that is not on the network to
> restore a backup to one that is on the network. I have a local account to
> that computer.
> Thanks in advance
> Chander|||Thx linchi.
Not on the network meaning it is not on any domain period. Standalone
server. So I need to restore the back up from there approx 5GB to another
computer
thx again
"Linchi Shea" wrote:
> I'm not sure what exactly you meant by 'not on the network'. If it is not on
> the network as in not having any network connectivity to it, you would have
> to copy the backup file using some detached media such as a tape or CD if
> it's small enough.
> But if it meant not in the same domain but reachable on the network, the
> solution is easy. You can always create an authenticated session first using
> NET USE with your local user account (assuming necessary ports are not
> blocked) before you copy the file or do the restore.
> Linchi
> "stoney" wrote:
> > I have a script that restores a SQL 2000 db from server A on the network to
> > server B on the network without any hickups.
> >
> > Now I have the challeng to restore a db from Server B which is NOT on the
> > network to server A which is on the network.
> >
> > Any ideas on how I can connect to a server that is not on the network to
> > restore a backup to one that is on the network. I have a local account to
> > that computer.
> >
> > Thanks in advance
> >
> > Chander|||In that case, use NET USE to autneticate first, then copy and/or restore.
So for instance, you can do the following:
EXEC master..xp_cmdshell 'net use \\serverB\d$ /user:serverB\localuser
password'
restore database test
from disk='\\serverB\d$\temp\test_db.bak' with recovery, replace
I'd add a bit more error checking to use in production.
Linchi
"stoney" wrote:
> Thx linchi.
> Not on the network meaning it is not on any domain period. Standalone
> server. So I need to restore the back up from there approx 5GB to another
> computer
> thx again
> "Linchi Shea" wrote:
> > I'm not sure what exactly you meant by 'not on the network'. If it is not on
> > the network as in not having any network connectivity to it, you would have
> > to copy the backup file using some detached media such as a tape or CD if
> > it's small enough.
> >
> > But if it meant not in the same domain but reachable on the network, the
> > solution is easy. You can always create an authenticated session first using
> > NET USE with your local user account (assuming necessary ports are not
> > blocked) before you copy the file or do the restore.
> >
> > Linchi
> >
> > "stoney" wrote:
> >
> > > I have a script that restores a SQL 2000 db from server A on the network to
> > > server B on the network without any hickups.
> > >
> > > Now I have the challeng to restore a db from Server B which is NOT on the
> > > network to server A which is on the network.
> > >
> > > Any ideas on how I can connect to a server that is not on the network to
> > > restore a backup to one that is on the network. I have a local account to
> > > that computer.
> > >
> > > Thanks in advance
> > >
> > > Chander|||stoney
How about compressing the .BAK file (WINRAR,WINZIP) , then copy it to the
destination SERVER and then perfom RESTORE command
"stoney" <stoney@.discussions.microsoft.com> wrote in message
news:DC9570F7-3C8D-4421-B013-F236ACDD40CF@.microsoft.com...
> Thx linchi.
> Not on the network meaning it is not on any domain period. Standalone
> server. So I need to restore the back up from there approx 5GB to another
> computer
> thx again
> "Linchi Shea" wrote:
>> I'm not sure what exactly you meant by 'not on the network'. If it is not
>> on
>> the network as in not having any network connectivity to it, you would
>> have
>> to copy the backup file using some detached media such as a tape or CD if
>> it's small enough.
>> But if it meant not in the same domain but reachable on the network, the
>> solution is easy. You can always create an authenticated session first
>> using
>> NET USE with your local user account (assuming necessary ports are not
>> blocked) before you copy the file or do the restore.
>> Linchi
>> "stoney" wrote:
>> > I have a script that restores a SQL 2000 db from server A on the
>> > network to
>> > server B on the network without any hickups.
>> >
>> > Now I have the challeng to restore a db from Server B which is NOT on
>> > the
>> > network to server A which is on the network.
>> >
>> > Any ideas on how I can connect to a server that is not on the network
>> > to
>> > restore a backup to one that is on the network. I have a local account
>> > to
>> > that computer.
>> >
>> > Thanks in advance
>> >
>> > Chander|||Thx Linchi&URI
Linchi your suggestion on 'net use' did the trick. very good.
now how about your email add for future refernce on picking your brain:-)
stoney
"stoney" wrote:
> I have a script that restores a SQL 2000 db from server A on the network to
> server B on the network without any hickups.
> Now I have the challeng to restore a db from Server B which is NOT on the
> network to server A which is on the network.
> Any ideas on how I can connect to a server that is not on the network to
> restore a backup to one that is on the network. I have a local account to
> that computer.
> Thanks in advance
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment