Restore through drive in other server

Hi all,
Does SQL Server 2000 allow restore through drive in other server?
This driver is in the Network.
Thanks for your help,
AlejandraYou can restore from a backup located on another server by specifying a UNC
path. For example:
RESTORE DATABASE MyDatabase
FROM DISK='\\MyOtherServer\MyBackups\MyDatabase.bak'
Note that the SQL Server service needs to be running under a domain account
with permissions to the share.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Alejandra Cornejo" <Alejandra Cornejo@.discussions.microsoft.com> wrote in
message news:00CD0253-9C2C-47A6-8C29-949C3B9606F9@.microsoft.com...
> Hi all,
> Does SQL Server 2000 allow restore through drive in other server?
> This driver is in the Network.
> Thanks for your help,
> Alejandra|||Hi Dan,
I had this error:
Server: Msg 3201, Level 16, State 2, Line 1
Cannot open backup device '\\server2\d$\Mssql\Backup\DB_1309.bak'. Device
error or device off-line. See the SQL Server error log for more details.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
In log:
2005-11-03 12:10:53.74 spid255 BackupDiskFile::OpenMedia: Backup device
'\\server2\d$\Mssql\Backup\DB_1309.bak' failed to open. Operating system
error = 5(Access is denied.).
Any idea?
thanks
"Dan Guzman" wrote:
> You can restore from a backup located on another server by specifying a UNC
> path. For example:
> RESTORE DATABASE MyDatabase
> FROM DISK='\\MyOtherServer\MyBackups\MyDatabase.bak'
> Note that the SQL Server service needs to be running under a domain account
> with permissions to the share.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Alejandra Cornejo" <Alejandra Cornejo@.discussions.microsoft.com> wrote in
> message news:00CD0253-9C2C-47A6-8C29-949C3B9606F9@.microsoft.com...
> > Hi all,
> >
> > Does SQL Server 2000 allow restore through drive in other server?
> >
> > This driver is in the Network.
> >
> > Thanks for your help,
> > Alejandra
>
>|||HowTo: Backup to UNC name using Database Maintenance Wizard
http://support.microsoft.com/?kbid=555128
This article covers backups, but the same requirements apply to restores.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Alejandra Cornejo" <AlejandraCornejo@.discussions.microsoft.com> wrote in
message news:71DBE4D4-95EB-401A-BBDB-F39783E68E42@.microsoft.com...
> Hi Dan,
> I had this error:
> Server: Msg 3201, Level 16, State 2, Line 1
> Cannot open backup device '\\server2\d$\Mssql\Backup\DB_1309.bak'. Device
> error or device off-line. See the SQL Server error log for more details.
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
> In log:
> 2005-11-03 12:10:53.74 spid255 BackupDiskFile::OpenMedia: Backup device
> '\\server2\d$\Mssql\Backup\DB_1309.bak' failed to open. Operating system
> error = 5(Access is denied.).
> Any idea?
> thanks
>
> "Dan Guzman" wrote:
>> You can restore from a backup located on another server by specifying a
>> UNC
>> path. For example:
>> RESTORE DATABASE MyDatabase
>> FROM DISK='\\MyOtherServer\MyBackups\MyDatabase.bak'
>> Note that the SQL Server service needs to be running under a domain
>> account
>> with permissions to the share.
>> --
>> Hope this helps.
>> Dan Guzman
>> SQL Server MVP
>> "Alejandra Cornejo" <Alejandra Cornejo@.discussions.microsoft.com> wrote
>> in
>> message news:00CD0253-9C2C-47A6-8C29-949C3B9606F9@.microsoft.com...
>> > Hi all,
>> >
>> > Does SQL Server 2000 allow restore through drive in other server?
>> >
>> > This driver is in the Network.
>> >
>> > Thanks for your help,
>> > Alejandra
>>|||Since you are using the administrative share (d$), the SQL Server account
needs to be a member of the administrators group on the server containing
the backup. Alternatively, you can create a new share on that server and
grant the SQL account permissions.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Alejandra Cornejo" <AlejandraCornejo@.discussions.microsoft.com> wrote in
message news:71DBE4D4-95EB-401A-BBDB-F39783E68E42@.microsoft.com...
> Hi Dan,
> I had this error:
> Server: Msg 3201, Level 16, State 2, Line 1
> Cannot open backup device '\\server2\d$\Mssql\Backup\DB_1309.bak'. Device
> error or device off-line. See the SQL Server error log for more details.
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
> In log:
> 2005-11-03 12:10:53.74 spid255 BackupDiskFile::OpenMedia: Backup device
> '\\server2\d$\Mssql\Backup\DB_1309.bak' failed to open. Operating system
> error = 5(Access is denied.).
> Any idea?
> thanks
>
> "Dan Guzman" wrote:
>> You can restore from a backup located on another server by specifying a
>> UNC
>> path. For example:
>> RESTORE DATABASE MyDatabase
>> FROM DISK='\\MyOtherServer\MyBackups\MyDatabase.bak'
>> Note that the SQL Server service needs to be running under a domain
>> account
>> with permissions to the share.
>> --
>> Hope this helps.
>> Dan Guzman
>> SQL Server MVP
>> "Alejandra Cornejo" <Alejandra Cornejo@.discussions.microsoft.com> wrote
>> in
>> message news:00CD0253-9C2C-47A6-8C29-949C3B9606F9@.microsoft.com...
>> > Hi all,
>> >
>> > Does SQL Server 2000 allow restore through drive in other server?
>> >
>> > This driver is in the Network.
>> >
>> > Thanks for your help,
>> > Alejandra
>>|||D$ is usually an administrative share, meaning you have to be in the
Administrator's group on the target box (in this case server2).
If your security people won't let you be an administrator on the box (as
opposed to in SQL Server), then make sure your account has read privilges on
the file/directory. You may need a non-administrative share.
Joseph R.P. Maloney, CSP,CCP,CDP
"Alejandra Cornejo" wrote:
> Hi Dan,
> I had this error:
> Server: Msg 3201, Level 16, State 2, Line 1
> Cannot open backup device '\\server2\d$\Mssql\Backup\DB_1309.bak'. Device
> error or device off-line. See the SQL Server error log for more details.
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
> In log:
> 2005-11-03 12:10:53.74 spid255 BackupDiskFile::OpenMedia: Backup device
> '\\server2\d$\Mssql\Backup\DB_1309.bak' failed to open. Operating system
> error = 5(Access is denied.).
> Any idea?
> thanks
>
> "Dan Guzman" wrote:
> > You can restore from a backup located on another server by specifying a UNC
> > path. For example:
> >
> > RESTORE DATABASE MyDatabase
> > FROM DISK='\\MyOtherServer\MyBackups\MyDatabase.bak'
> >
> > Note that the SQL Server service needs to be running under a domain account
> > with permissions to the share.
> >
> > --
> > Hope this helps.
> >
> > Dan Guzman
> > SQL Server MVP
> >
> > "Alejandra Cornejo" <Alejandra Cornejo@.discussions.microsoft.com> wrote in
> > message news:00CD0253-9C2C-47A6-8C29-949C3B9606F9@.microsoft.com...
> > > Hi all,
> > >
> > > Does SQL Server 2000 allow restore through drive in other server?
> > >
> > > This driver is in the Network.
> > >
> > > Thanks for your help,
> > > Alejandra
> >
> >
> >|||Hi all,
I had success with RESTORE.
But I didn't understand why after restart SQLServer the databases couldn't
open becase they were in "SUSPECT" state.
Any Idea?
Thanks
"jrpm" wrote:
> D$ is usually an administrative share, meaning you have to be in the
> Administrator's group on the target box (in this case server2).
> If your security people won't let you be an administrator on the box (as
> opposed to in SQL Server), then make sure your account has read privilges on
> the file/directory. You may need a non-administrative share.
>
> --
> Joseph R.P. Maloney, CSP,CCP,CDP
>
> "Alejandra Cornejo" wrote:
> > Hi Dan,
> >
> > I had this error:
> > Server: Msg 3201, Level 16, State 2, Line 1
> > Cannot open backup device '\\server2\d$\Mssql\Backup\DB_1309.bak'. Device
> > error or device off-line. See the SQL Server error log for more details.
> > Server: Msg 3013, Level 16, State 1, Line 1
> > RESTORE DATABASE is terminating abnormally.
> >
> > In log:
> > 2005-11-03 12:10:53.74 spid255 BackupDiskFile::OpenMedia: Backup device
> > '\\server2\d$\Mssql\Backup\DB_1309.bak' failed to open. Operating system
> > error = 5(Access is denied.).
> >
> > Any idea?
> >
> > thanks
> >
> >
> > "Dan Guzman" wrote:
> >
> > > You can restore from a backup located on another server by specifying a UNC
> > > path. For example:
> > >
> > > RESTORE DATABASE MyDatabase
> > > FROM DISK='\\MyOtherServer\MyBackups\MyDatabase.bak'
> > >
> > > Note that the SQL Server service needs to be running under a domain account
> > > with permissions to the share.
> > >
> > > --
> > > Hope this helps.
> > >
> > > Dan Guzman
> > > SQL Server MVP
> > >
> > > "Alejandra Cornejo" <Alejandra Cornejo@.discussions.microsoft.com> wrote in
> > > message news:00CD0253-9C2C-47A6-8C29-949C3B9606F9@.microsoft.com...
> > > > Hi all,
> > > >
> > > > Does SQL Server 2000 allow restore through drive in other server?
> > > >
> > > > This driver is in the Network.
> > > >
> > > > Thanks for your help,
> > > > Alejandra
> > >
> > >
> > >