Hi all,
Does SQL Server 2000 allow restore through drive in other server?
This driver is in the Network.
Thanks for your help,
Alejandra
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 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...
>
>
|||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...[vbcol=seagreen]
> 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:
|||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...[vbcol=seagreen]
> 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:
|||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:
[vbcol=seagreen]
> 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:
|||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:
[vbcol=seagreen]
> 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:
Showing posts with label network. Show all posts
Showing posts with label network. Show all posts
Monday, March 26, 2012
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
> > >
> > >
> > >
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
> > >
> > >
> > >
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\MyDataba
se.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 UN
C
> path. For example:
> RESTORE DATABASE MyDatabase
> FROM DISK='\\MyOtherServer\MyBackups\MyDataba
se.bak'
> Note that the SQL Server service needs to be running under a domain accoun
t
> 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...
>
>|||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...[vbcol=seagreen]
> 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:
>|||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...[vbcol=seagreen]
> 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:
>|||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:
[vbcol=seagreen]
> 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:
>|||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:
[vbcol=seagreen]
> 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:
>
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\MyDataba
se.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 UN
C
> path. For example:
> RESTORE DATABASE MyDatabase
> FROM DISK='\\MyOtherServer\MyBackups\MyDataba
se.bak'
> Note that the SQL Server service needs to be running under a domain accoun
t
> 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...
>
>|||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...[vbcol=seagreen]
> 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:
>|||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...[vbcol=seagreen]
> 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:
>|||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:
[vbcol=seagreen]
> 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:
>|||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:
[vbcol=seagreen]
> 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:
>
Wednesday, March 21, 2012
Restore SQL database from a network drive
Hi there,
I have a copy of a database on a network drive.
How could restore this database into my local test box without copy the
database down first?
I tried to use UNC and map a drive using net use but none of these work.
I always get the 'Cannot open backup device 'Z:\mapdrive\databasename.bak'.
Device error or device off-line. See the SQL Server error log for more
details. RESTORE DATABASE is terminating abnormally.'
I go to the SQL server Error Log and it said 'The system cannot find the
path specified (if I use the map drive syntax) or Access is denied (if I use
the UNC syntax like \\server\drive\dir\my backup.bak)
Any idea of how to do this?
Thanks.
Abel Chan
You must:
1) Use the UNC name
2) Have SQL Server running under a domain account - not Local System
3) Have read permission on the share for the domain account in #1 above
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
..
"Abel Chan" <awong@.newsgroup.nospam> wrote in message
news:136DAF3F-B192-41C4-A819-D6BEC9CE1449@.microsoft.com...
Hi there,
I have a copy of a database on a network drive.
How could restore this database into my local test box without copy the
database down first?
I tried to use UNC and map a drive using net use but none of these work.
I always get the 'Cannot open backup device 'Z:\mapdrive\databasename.bak'.
Device error or device off-line. See the SQL Server error log for more
details. RESTORE DATABASE is terminating abnormally.'
I go to the SQL server Error Log and it said 'The system cannot find the
path specified (if I use the map drive syntax) or Access is denied (if I use
the UNC syntax like \\server\drive\dir\my backup.bak)
Any idea of how to do this?
Thanks.
Abel Chan
|||Tom,
Your solution works!!!
Thanks so mcuh Tom.
Abel
"Tom Moreau" wrote:
> You must:
> 1) Use the UNC name
> 2) Have SQL Server running under a domain account - not Local System
> 3) Have read permission on the share for the domain account in #1 above
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com
> ..
> "Abel Chan" <awong@.newsgroup.nospam> wrote in message
> news:136DAF3F-B192-41C4-A819-D6BEC9CE1449@.microsoft.com...
> Hi there,
> I have a copy of a database on a network drive.
> How could restore this database into my local test box without copy the
> database down first?
> I tried to use UNC and map a drive using net use but none of these work.
> I always get the 'Cannot open backup device 'Z:\mapdrive\databasename.bak'.
> Device error or device off-line. See the SQL Server error log for more
> details. RESTORE DATABASE is terminating abnormally.'
> I go to the SQL server Error Log and it said 'The system cannot find the
> path specified (if I use the map drive syntax) or Access is denied (if I use
> the UNC syntax like \\server\drive\dir\my backup.bak)
> Any idea of how to do this?
> Thanks.
> Abel Chan
>
I have a copy of a database on a network drive.
How could restore this database into my local test box without copy the
database down first?
I tried to use UNC and map a drive using net use but none of these work.
I always get the 'Cannot open backup device 'Z:\mapdrive\databasename.bak'.
Device error or device off-line. See the SQL Server error log for more
details. RESTORE DATABASE is terminating abnormally.'
I go to the SQL server Error Log and it said 'The system cannot find the
path specified (if I use the map drive syntax) or Access is denied (if I use
the UNC syntax like \\server\drive\dir\my backup.bak)
Any idea of how to do this?
Thanks.
Abel Chan
You must:
1) Use the UNC name
2) Have SQL Server running under a domain account - not Local System
3) Have read permission on the share for the domain account in #1 above
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
..
"Abel Chan" <awong@.newsgroup.nospam> wrote in message
news:136DAF3F-B192-41C4-A819-D6BEC9CE1449@.microsoft.com...
Hi there,
I have a copy of a database on a network drive.
How could restore this database into my local test box without copy the
database down first?
I tried to use UNC and map a drive using net use but none of these work.
I always get the 'Cannot open backup device 'Z:\mapdrive\databasename.bak'.
Device error or device off-line. See the SQL Server error log for more
details. RESTORE DATABASE is terminating abnormally.'
I go to the SQL server Error Log and it said 'The system cannot find the
path specified (if I use the map drive syntax) or Access is denied (if I use
the UNC syntax like \\server\drive\dir\my backup.bak)
Any idea of how to do this?
Thanks.
Abel Chan
|||Tom,
Your solution works!!!
Thanks so mcuh Tom.
Abel
"Tom Moreau" wrote:
> You must:
> 1) Use the UNC name
> 2) Have SQL Server running under a domain account - not Local System
> 3) Have read permission on the share for the domain account in #1 above
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com
> ..
> "Abel Chan" <awong@.newsgroup.nospam> wrote in message
> news:136DAF3F-B192-41C4-A819-D6BEC9CE1449@.microsoft.com...
> Hi there,
> I have a copy of a database on a network drive.
> How could restore this database into my local test box without copy the
> database down first?
> I tried to use UNC and map a drive using net use but none of these work.
> I always get the 'Cannot open backup device 'Z:\mapdrive\databasename.bak'.
> Device error or device off-line. See the SQL Server error log for more
> details. RESTORE DATABASE is terminating abnormally.'
> I go to the SQL server Error Log and it said 'The system cannot find the
> path specified (if I use the map drive syntax) or Access is denied (if I use
> the UNC syntax like \\server\drive\dir\my backup.bak)
> Any idea of how to do this?
> Thanks.
> Abel Chan
>
Restore SQL database from a network drive
Hi there,
I have a copy of a database on a network drive.
How could restore this database into my local test box without copy the
database down first?
I tried to use UNC and map a drive using net use but none of these work.
I always get the 'Cannot open backup device 'Z:\mapdrive\databasename.bak'.
Device error or device off-line. See the SQL Server error log for more
details. RESTORE DATABASE is terminating abnormally.'
I go to the SQL server Error Log and it said 'The system cannot find the
path specified (if I use the map drive syntax) or Access is denied (if I use
the UNC syntax like \\server\drive\dir\my backup.bak)
Any idea of how to do this?
Thanks.
Abel ChanYou must:
1) Use the UNC name
2) Have SQL Server running under a domain account - not Local System
3) Have read permission on the share for the domain account in #1 above
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
.
"Abel Chan" <awong@.newsgroup.nospam> wrote in message
news:136DAF3F-B192-41C4-A819-D6BEC9CE1449@.microsoft.com...
Hi there,
I have a copy of a database on a network drive.
How could restore this database into my local test box without copy the
database down first?
I tried to use UNC and map a drive using net use but none of these work.
I always get the 'Cannot open backup device 'Z:\mapdrive\databasename.bak'.
Device error or device off-line. See the SQL Server error log for more
details. RESTORE DATABASE is terminating abnormally.'
I go to the SQL server Error Log and it said 'The system cannot find the
path specified (if I use the map drive syntax) or Access is denied (if I use
the UNC syntax like \\server\drive\dir\my backup.bak)
Any idea of how to do this?
Thanks.
Abel Chan|||Tom,
Your solution works!!!
Thanks so mcuh Tom.
Abel
"Tom Moreau" wrote:
> You must:
> 1) Use the UNC name
> 2) Have SQL Server running under a domain account - not Local System
> 3) Have read permission on the share for the domain account in #1 above
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com
> ..
> "Abel Chan" <awong@.newsgroup.nospam> wrote in message
> news:136DAF3F-B192-41C4-A819-D6BEC9CE1449@.microsoft.com...
> Hi there,
> I have a copy of a database on a network drive.
> How could restore this database into my local test box without copy the
> database down first?
> I tried to use UNC and map a drive using net use but none of these work.
> I always get the 'Cannot open backup device 'Z:\mapdrive\databasename.bak'
.
> Device error or device off-line. See the SQL Server error log for more
> details. RESTORE DATABASE is terminating abnormally.'
> I go to the SQL server Error Log and it said 'The system cannot find the
> path specified (if I use the map drive syntax) or Access is denied (if I u
se
> the UNC syntax like \\server\drive\dir\my backup.bak)
> Any idea of how to do this?
> Thanks.
> Abel Chan
>
I have a copy of a database on a network drive.
How could restore this database into my local test box without copy the
database down first?
I tried to use UNC and map a drive using net use but none of these work.
I always get the 'Cannot open backup device 'Z:\mapdrive\databasename.bak'.
Device error or device off-line. See the SQL Server error log for more
details. RESTORE DATABASE is terminating abnormally.'
I go to the SQL server Error Log and it said 'The system cannot find the
path specified (if I use the map drive syntax) or Access is denied (if I use
the UNC syntax like \\server\drive\dir\my backup.bak)
Any idea of how to do this?
Thanks.
Abel ChanYou must:
1) Use the UNC name
2) Have SQL Server running under a domain account - not Local System
3) Have read permission on the share for the domain account in #1 above
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
.
"Abel Chan" <awong@.newsgroup.nospam> wrote in message
news:136DAF3F-B192-41C4-A819-D6BEC9CE1449@.microsoft.com...
Hi there,
I have a copy of a database on a network drive.
How could restore this database into my local test box without copy the
database down first?
I tried to use UNC and map a drive using net use but none of these work.
I always get the 'Cannot open backup device 'Z:\mapdrive\databasename.bak'.
Device error or device off-line. See the SQL Server error log for more
details. RESTORE DATABASE is terminating abnormally.'
I go to the SQL server Error Log and it said 'The system cannot find the
path specified (if I use the map drive syntax) or Access is denied (if I use
the UNC syntax like \\server\drive\dir\my backup.bak)
Any idea of how to do this?
Thanks.
Abel Chan|||Tom,
Your solution works!!!
Thanks so mcuh Tom.
Abel
"Tom Moreau" wrote:
> You must:
> 1) Use the UNC name
> 2) Have SQL Server running under a domain account - not Local System
> 3) Have read permission on the share for the domain account in #1 above
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com
> ..
> "Abel Chan" <awong@.newsgroup.nospam> wrote in message
> news:136DAF3F-B192-41C4-A819-D6BEC9CE1449@.microsoft.com...
> Hi there,
> I have a copy of a database on a network drive.
> How could restore this database into my local test box without copy the
> database down first?
> I tried to use UNC and map a drive using net use but none of these work.
> I always get the 'Cannot open backup device 'Z:\mapdrive\databasename.bak'
.
> Device error or device off-line. See the SQL Server error log for more
> details. RESTORE DATABASE is terminating abnormally.'
> I go to the SQL server Error Log and it said 'The system cannot find the
> path specified (if I use the map drive syntax) or Access is denied (if I u
se
> the UNC syntax like \\server\drive\dir\my backup.bak)
> Any idea of how to do this?
> Thanks.
> Abel Chan
>
Restore SQL database from a network drive
Hi there,
I have a copy of a database on a network drive.
How could restore this database into my local test box without copy the
database down first?
I tried to use UNC and map a drive using net use but none of these work.
I always get the 'Cannot open backup device 'Z:\mapdrive\databasename.bak'.
Device error or device off-line. See the SQL Server error log for more
details. RESTORE DATABASE is terminating abnormally.'
I go to the SQL server Error Log and it said 'The system cannot find the
path specified (if I use the map drive syntax) or Access is denied (if I use
the UNC syntax like \\server\drive\dir\my backup.bak)
Any idea of how to do this?
Thanks.
Abel ChanYou must:
1) Use the UNC name
2) Have SQL Server running under a domain account - not Local System
3) Have read permission on the share for the domain account in #1 above
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
.
"Abel Chan" <awong@.newsgroup.nospam> wrote in message
news:136DAF3F-B192-41C4-A819-D6BEC9CE1449@.microsoft.com...
Hi there,
I have a copy of a database on a network drive.
How could restore this database into my local test box without copy the
database down first?
I tried to use UNC and map a drive using net use but none of these work.
I always get the 'Cannot open backup device 'Z:\mapdrive\databasename.bak'.
Device error or device off-line. See the SQL Server error log for more
details. RESTORE DATABASE is terminating abnormally.'
I go to the SQL server Error Log and it said 'The system cannot find the
path specified (if I use the map drive syntax) or Access is denied (if I use
the UNC syntax like \\server\drive\dir\my backup.bak)
Any idea of how to do this?
Thanks.
Abel Chan|||Tom,
Your solution works!!!
Thanks so mcuh Tom.
Abel
"Tom Moreau" wrote:
> You must:
> 1) Use the UNC name
> 2) Have SQL Server running under a domain account - not Local System
> 3) Have read permission on the share for the domain account in #1 above
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com
> ..
> "Abel Chan" <awong@.newsgroup.nospam> wrote in message
> news:136DAF3F-B192-41C4-A819-D6BEC9CE1449@.microsoft.com...
> Hi there,
> I have a copy of a database on a network drive.
> How could restore this database into my local test box without copy the
> database down first?
> I tried to use UNC and map a drive using net use but none of these work.
> I always get the 'Cannot open backup device 'Z:\mapdrive\databasename.bak'.
> Device error or device off-line. See the SQL Server error log for more
> details. RESTORE DATABASE is terminating abnormally.'
> I go to the SQL server Error Log and it said 'The system cannot find the
> path specified (if I use the map drive syntax) or Access is denied (if I use
> the UNC syntax like \\server\drive\dir\my backup.bak)
> Any idea of how to do this?
> Thanks.
> Abel Chan
>sql
I have a copy of a database on a network drive.
How could restore this database into my local test box without copy the
database down first?
I tried to use UNC and map a drive using net use but none of these work.
I always get the 'Cannot open backup device 'Z:\mapdrive\databasename.bak'.
Device error or device off-line. See the SQL Server error log for more
details. RESTORE DATABASE is terminating abnormally.'
I go to the SQL server Error Log and it said 'The system cannot find the
path specified (if I use the map drive syntax) or Access is denied (if I use
the UNC syntax like \\server\drive\dir\my backup.bak)
Any idea of how to do this?
Thanks.
Abel ChanYou must:
1) Use the UNC name
2) Have SQL Server running under a domain account - not Local System
3) Have read permission on the share for the domain account in #1 above
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
.
"Abel Chan" <awong@.newsgroup.nospam> wrote in message
news:136DAF3F-B192-41C4-A819-D6BEC9CE1449@.microsoft.com...
Hi there,
I have a copy of a database on a network drive.
How could restore this database into my local test box without copy the
database down first?
I tried to use UNC and map a drive using net use but none of these work.
I always get the 'Cannot open backup device 'Z:\mapdrive\databasename.bak'.
Device error or device off-line. See the SQL Server error log for more
details. RESTORE DATABASE is terminating abnormally.'
I go to the SQL server Error Log and it said 'The system cannot find the
path specified (if I use the map drive syntax) or Access is denied (if I use
the UNC syntax like \\server\drive\dir\my backup.bak)
Any idea of how to do this?
Thanks.
Abel Chan|||Tom,
Your solution works!!!
Thanks so mcuh Tom.
Abel
"Tom Moreau" wrote:
> You must:
> 1) Use the UNC name
> 2) Have SQL Server running under a domain account - not Local System
> 3) Have read permission on the share for the domain account in #1 above
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com
> ..
> "Abel Chan" <awong@.newsgroup.nospam> wrote in message
> news:136DAF3F-B192-41C4-A819-D6BEC9CE1449@.microsoft.com...
> Hi there,
> I have a copy of a database on a network drive.
> How could restore this database into my local test box without copy the
> database down first?
> I tried to use UNC and map a drive using net use but none of these work.
> I always get the 'Cannot open backup device 'Z:\mapdrive\databasename.bak'.
> Device error or device off-line. See the SQL Server error log for more
> details. RESTORE DATABASE is terminating abnormally.'
> I go to the SQL server Error Log and it said 'The system cannot find the
> path specified (if I use the map drive syntax) or Access is denied (if I use
> the UNC syntax like \\server\drive\dir\my backup.bak)
> Any idea of how to do this?
> Thanks.
> Abel Chan
>sql
Friday, March 9, 2012
Restore of the SQL Server Program Files
Hello Group,
My Network Admin an myself are trying to come up with a way to quickly
restore our SQL Server in case of partial disk failure. What I am looking to
do is to resore only the Program Files Folder on the Database Server (if that
is possible). We have had good success with using NT Back Up and restoring
the complete server (OS and all).
What he wants me to do next is use a Shadow Copy to restore just the
Programs Folder holding the SQL Server install. This ahs not worked very
well. We can restore the folders and instances and databases but the SQL
Server Service does not start.
Does Microsoft have any instructions on this? The other option is I just
install SQL Server again and dump my BAK files back into the server but they
want a solution that does not include using the SQL Server install CD.
Rich
Hi
There are registry settings that need to come along too.
Files need to be registered also.
If you setup your SQL Server instances using the unattended install scripts
and you save them away, you could possibly install SQL Server from a scratch
faster than looking for a tape.
AFAIK, only full machine restores are supported to restore program files.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:C865BFA9-33DE-4E99-9CA3-42AE7DFF3F84@.microsoft.com...
> Hello Group,
> My Network Admin an myself are trying to come up with a way to quickly
> restore our SQL Server in case of partial disk failure. What I am looking
> to
> do is to resore only the Program Files Folder on the Database Server (if
> that
> is possible). We have had good success with using NT Back Up and
> restoring
> the complete server (OS and all).
> What he wants me to do next is use a Shadow Copy to restore just the
> Programs Folder holding the SQL Server install. This ahs not worked very
> well. We can restore the folders and instances and databases but the SQL
> Server Service does not start.
> Does Microsoft have any instructions on this? The other option is I just
> install SQL Server again and dump my BAK files back into the server but
> they
> want a solution that does not include using the SQL Server install CD.
> Rich
>
My Network Admin an myself are trying to come up with a way to quickly
restore our SQL Server in case of partial disk failure. What I am looking to
do is to resore only the Program Files Folder on the Database Server (if that
is possible). We have had good success with using NT Back Up and restoring
the complete server (OS and all).
What he wants me to do next is use a Shadow Copy to restore just the
Programs Folder holding the SQL Server install. This ahs not worked very
well. We can restore the folders and instances and databases but the SQL
Server Service does not start.
Does Microsoft have any instructions on this? The other option is I just
install SQL Server again and dump my BAK files back into the server but they
want a solution that does not include using the SQL Server install CD.
Rich
Hi
There are registry settings that need to come along too.
Files need to be registered also.
If you setup your SQL Server instances using the unattended install scripts
and you save them away, you could possibly install SQL Server from a scratch
faster than looking for a tape.
AFAIK, only full machine restores are supported to restore program files.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:C865BFA9-33DE-4E99-9CA3-42AE7DFF3F84@.microsoft.com...
> Hello Group,
> My Network Admin an myself are trying to come up with a way to quickly
> restore our SQL Server in case of partial disk failure. What I am looking
> to
> do is to resore only the Program Files Folder on the Database Server (if
> that
> is possible). We have had good success with using NT Back Up and
> restoring
> the complete server (OS and all).
> What he wants me to do next is use a Shadow Copy to restore just the
> Programs Folder holding the SQL Server install. This ahs not worked very
> well. We can restore the folders and instances and databases but the SQL
> Server Service does not start.
> Does Microsoft have any instructions on this? The other option is I just
> install SQL Server again and dump my BAK files back into the server but
> they
> want a solution that does not include using the SQL Server install CD.
> Rich
>
Restore of the SQL Server Program Files
Hello Group,
My Network Admin an myself are trying to come up with a way to quickly
restore our SQL Server in case of partial disk failure. What I am looking t
o
do is to resore only the Program Files Folder on the Database Server (if tha
t
is possible). We have had good success with using NT Back Up and restoring
the complete server (OS and all).
What he wants me to do next is use a Shadow Copy to restore just the
Programs Folder holding the SQL Server install. This ahs not worked very
well. We can restore the folders and instances and databases but the SQL
Server Service does not start.
Does Microsoft have any instructions on this? The other option is I just
install SQL Server again and dump my BAK files back into the server but they
want a solution that does not include using the SQL Server install CD.
RichHi
There are registry settings that need to come along too.
Files need to be registered also.
If you setup your SQL Server instances using the unattended install scripts
and you save them away, you could possibly install SQL Server from a scratch
faster than looking for a tape.
AFAIK, only full machine restores are supported to restore program files.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:C865BFA9-33DE-4E99-9CA3-42AE7DFF3F84@.microsoft.com...
> Hello Group,
> My Network Admin an myself are trying to come up with a way to quickly
> restore our SQL Server in case of partial disk failure. What I am looking
> to
> do is to resore only the Program Files Folder on the Database Server (if
> that
> is possible). We have had good success with using NT Back Up and
> restoring
> the complete server (OS and all).
> What he wants me to do next is use a Shadow Copy to restore just the
> Programs Folder holding the SQL Server install. This ahs not worked very
> well. We can restore the folders and instances and databases but the SQL
> Server Service does not start.
> Does Microsoft have any instructions on this? The other option is I just
> install SQL Server again and dump my BAK files back into the server but
> they
> want a solution that does not include using the SQL Server install CD.
> Rich
>
My Network Admin an myself are trying to come up with a way to quickly
restore our SQL Server in case of partial disk failure. What I am looking t
o
do is to resore only the Program Files Folder on the Database Server (if tha
t
is possible). We have had good success with using NT Back Up and restoring
the complete server (OS and all).
What he wants me to do next is use a Shadow Copy to restore just the
Programs Folder holding the SQL Server install. This ahs not worked very
well. We can restore the folders and instances and databases but the SQL
Server Service does not start.
Does Microsoft have any instructions on this? The other option is I just
install SQL Server again and dump my BAK files back into the server but they
want a solution that does not include using the SQL Server install CD.
RichHi
There are registry settings that need to come along too.
Files need to be registered also.
If you setup your SQL Server instances using the unattended install scripts
and you save them away, you could possibly install SQL Server from a scratch
faster than looking for a tape.
AFAIK, only full machine restores are supported to restore program files.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:C865BFA9-33DE-4E99-9CA3-42AE7DFF3F84@.microsoft.com...
> Hello Group,
> My Network Admin an myself are trying to come up with a way to quickly
> restore our SQL Server in case of partial disk failure. What I am looking
> to
> do is to resore only the Program Files Folder on the Database Server (if
> that
> is possible). We have had good success with using NT Back Up and
> restoring
> the complete server (OS and all).
> What he wants me to do next is use a Shadow Copy to restore just the
> Programs Folder holding the SQL Server install. This ahs not worked very
> well. We can restore the folders and instances and databases but the SQL
> Server Service does not start.
> Does Microsoft have any instructions on this? The other option is I just
> install SQL Server again and dump my BAK files back into the server but
> they
> want a solution that does not include using the SQL Server install CD.
> Rich
>
Restore of the SQL Server Program Files
Hello Group,
My Network Admin an myself are trying to come up with a way to quickly
restore our SQL Server in case of partial disk failure. What I am looking to
do is to resore only the Program Files Folder on the Database Server (if that
is possible). We have had good success with using NT Back Up and restoring
the complete server (OS and all).
What he wants me to do next is use a Shadow Copy to restore just the
Programs Folder holding the SQL Server install. This ahs not worked very
well. We can restore the folders and instances and databases but the SQL
Server Service does not start.
Does Microsoft have any instructions on this? The other option is I just
install SQL Server again and dump my BAK files back into the server but they
want a solution that does not include using the SQL Server install CD.
RichHi
There are registry settings that need to come along too.
Files need to be registered also.
If you setup your SQL Server instances using the unattended install scripts
and you save them away, you could possibly install SQL Server from a scratch
faster than looking for a tape.
AFAIK, only full machine restores are supported to restore program files.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:C865BFA9-33DE-4E99-9CA3-42AE7DFF3F84@.microsoft.com...
> Hello Group,
> My Network Admin an myself are trying to come up with a way to quickly
> restore our SQL Server in case of partial disk failure. What I am looking
> to
> do is to resore only the Program Files Folder on the Database Server (if
> that
> is possible). We have had good success with using NT Back Up and
> restoring
> the complete server (OS and all).
> What he wants me to do next is use a Shadow Copy to restore just the
> Programs Folder holding the SQL Server install. This ahs not worked very
> well. We can restore the folders and instances and databases but the SQL
> Server Service does not start.
> Does Microsoft have any instructions on this? The other option is I just
> install SQL Server again and dump my BAK files back into the server but
> they
> want a solution that does not include using the SQL Server install CD.
> Rich
>
My Network Admin an myself are trying to come up with a way to quickly
restore our SQL Server in case of partial disk failure. What I am looking to
do is to resore only the Program Files Folder on the Database Server (if that
is possible). We have had good success with using NT Back Up and restoring
the complete server (OS and all).
What he wants me to do next is use a Shadow Copy to restore just the
Programs Folder holding the SQL Server install. This ahs not worked very
well. We can restore the folders and instances and databases but the SQL
Server Service does not start.
Does Microsoft have any instructions on this? The other option is I just
install SQL Server again and dump my BAK files back into the server but they
want a solution that does not include using the SQL Server install CD.
RichHi
There are registry settings that need to come along too.
Files need to be registered also.
If you setup your SQL Server instances using the unattended install scripts
and you save them away, you could possibly install SQL Server from a scratch
faster than looking for a tape.
AFAIK, only full machine restores are supported to restore program files.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:C865BFA9-33DE-4E99-9CA3-42AE7DFF3F84@.microsoft.com...
> Hello Group,
> My Network Admin an myself are trying to come up with a way to quickly
> restore our SQL Server in case of partial disk failure. What I am looking
> to
> do is to resore only the Program Files Folder on the Database Server (if
> that
> is possible). We have had good success with using NT Back Up and
> restoring
> the complete server (OS and all).
> What he wants me to do next is use a Shadow Copy to restore just the
> Programs Folder holding the SQL Server install. This ahs not worked very
> well. We can restore the folders and instances and databases but the SQL
> Server Service does not start.
> Does Microsoft have any instructions on this? The other option is I just
> install SQL Server again and dump my BAK files back into the server but
> they
> want a solution that does not include using the SQL Server install CD.
> Rich
>
Monday, February 20, 2012
Restore master & msdb without backup files
Hi,
I need to restore mater and msdb database on SQL Server.
When the network guy upgrade server from Windows NT 4.0 to
Windows 2000 Server, he massed up the C: drive so the
SQL installation is gone.
Because I've installed sql on D:\MSSQL folder,
necessary .mdf & .ldf files are in there.
However, because I didn't create backup file.
I'm trouble to restore master & msdb file.
The BOL said that I cannot attach database unless I
detached that database.
And also master & msdb databases are not allowed to detach.
I didn't tryed yet, but Can I just install SQL again and
overwrite .mdf & .ldf from old installation?
Does anyone successfully restored master without backup?
Any tip or advice would be helpful.
Thank you.
- Hyung -Make sure you save those files somewhere safe before doing anything to start
with. Have a look here. These explain how to fix most of your issues:
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
--
Andrew J. Kelly
SQL Server MVP
"hrhoe" <hrhoe@.hotmail.com> wrote in message
news:01e401c39f0b$9658e250$a301280a@.phx.gbl...
> Hi,
> I need to restore mater and msdb database on SQL Server.
> When the network guy upgrade server from Windows NT 4.0 to
> Windows 2000 Server, he massed up the C: drive so the
> SQL installation is gone.
> Because I've installed sql on D:\MSSQL folder,
> necessary .mdf & .ldf files are in there.
> However, because I didn't create backup file.
> I'm trouble to restore master & msdb file.
> The BOL said that I cannot attach database unless I
> detached that database.
> And also master & msdb databases are not allowed to detach.
> I didn't tryed yet, but Can I just install SQL again and
> overwrite .mdf & .ldf from old installation?
> Does anyone successfully restored master without backup?
> Any tip or advice would be helpful.
> Thank you.
> - Hyung -|||Thank you,
I'll try those as soon as the Server is recovered.
- Hyung -|||Andrew,
I tried to rebuild master database after new SQL setup,
I got the error message:
"rebuild Master failed with error -1:
Do you know what this mean?|||No I don't. If you did a new install then why do you need to rebuild
Master?
--
Andrew J. Kelly
SQL Server MVP
"hrhoe" <hrhoe@.hotmail.com> wrote in message
news:020b01c39f31$3aa34ba0$a601280a@.phx.gbl...
> Andrew,
> I tried to rebuild master database after new SQL setup,
> I got the error message:
> "rebuild Master failed with error -1:
> Do you know what this mean?
>
I need to restore mater and msdb database on SQL Server.
When the network guy upgrade server from Windows NT 4.0 to
Windows 2000 Server, he massed up the C: drive so the
SQL installation is gone.
Because I've installed sql on D:\MSSQL folder,
necessary .mdf & .ldf files are in there.
However, because I didn't create backup file.
I'm trouble to restore master & msdb file.
The BOL said that I cannot attach database unless I
detached that database.
And also master & msdb databases are not allowed to detach.
I didn't tryed yet, but Can I just install SQL again and
overwrite .mdf & .ldf from old installation?
Does anyone successfully restored master without backup?
Any tip or advice would be helpful.
Thank you.
- Hyung -Make sure you save those files somewhere safe before doing anything to start
with. Have a look here. These explain how to fix most of your issues:
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
--
Andrew J. Kelly
SQL Server MVP
"hrhoe" <hrhoe@.hotmail.com> wrote in message
news:01e401c39f0b$9658e250$a301280a@.phx.gbl...
> Hi,
> I need to restore mater and msdb database on SQL Server.
> When the network guy upgrade server from Windows NT 4.0 to
> Windows 2000 Server, he massed up the C: drive so the
> SQL installation is gone.
> Because I've installed sql on D:\MSSQL folder,
> necessary .mdf & .ldf files are in there.
> However, because I didn't create backup file.
> I'm trouble to restore master & msdb file.
> The BOL said that I cannot attach database unless I
> detached that database.
> And also master & msdb databases are not allowed to detach.
> I didn't tryed yet, but Can I just install SQL again and
> overwrite .mdf & .ldf from old installation?
> Does anyone successfully restored master without backup?
> Any tip or advice would be helpful.
> Thank you.
> - Hyung -|||Thank you,
I'll try those as soon as the Server is recovered.
- Hyung -|||Andrew,
I tried to rebuild master database after new SQL setup,
I got the error message:
"rebuild Master failed with error -1:
Do you know what this mean?|||No I don't. If you did a new install then why do you need to rebuild
Master?
--
Andrew J. Kelly
SQL Server MVP
"hrhoe" <hrhoe@.hotmail.com> wrote in message
news:020b01c39f31$3aa34ba0$a601280a@.phx.gbl...
> Andrew,
> I tried to rebuild master database after new SQL setup,
> I got the error message:
> "rebuild Master failed with error -1:
> Do you know what this mean?
>
Subscribe to:
Posts (Atom)