I'll try to keep this as simple but clear as i can.
i have a backup on an SDLT tape taken from a SQL server using the SQL backup
to a locally attached device. i now want to restore the *.BAK file from this
tape to another server, but this server isnt running SQL.
i'm trying to use native NT2000 backup but it doesnt seam to like the tape,
as i kind of expected. does anyone know how i can restore this data without
having to use a SQL server (i.e. just a standard NT2000 server with local
SDLT drive)?
many thanks in advance for your helpThe backup made from SQL Server can only be used by SQL Server to restore a
database.
--
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://blogs.msdn.com/weix
This posting is provided "AS IS" with no warranties, and confers no rights.
"J Hotch" <jonathan.hotchkiss-remove-@.tesco.net> wrote in message
news:B5422198-6C81-427F-B9BA-DC0AAC0CBA92@.microsoft.com...
> I'll try to keep this as simple but clear as i can.
> i have a backup on an SDLT tape taken from a SQL server using the SQL
> backup
> to a locally attached device. i now want to restore the *.BAK file from
> this
> tape to another server, but this server isnt running SQL.
> i'm trying to use native NT2000 backup but it doesnt seam to like the
> tape,
> as i kind of expected. does anyone know how i can restore this data
> without
> having to use a SQL server (i.e. just a standard NT2000 server with local
> SDLT drive)?
> many thanks in advance for your help|||thanks Wei, not the answer i was hoping for but at least it means i dont hav
e
to spend ages trying to find a solution that doesnt exist.
thanks again.
"wei xiao [MSFT]" wrote:
> The backup made from SQL Server can only be used by SQL Server to restore
a
> database.
> --
> Wei Xiao [MSFT]
> SQL Server Storage Engine Development
> http://blogs.msdn.com/weix
>
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> "J Hotch" <jonathan.hotchkiss-remove-@.tesco.net> wrote in message
> news:B5422198-6C81-427F-B9BA-DC0AAC0CBA92@.microsoft.com...
>
>|||I don't know what you want to achieve with this operation, but there're no
problem in restoring the .BAK file as such to a server that doesn't run SQL.
To do that you just restore it like every other file. To get the BAK file
"back" to your database and logfiles will require SQL Server, but I don't
know if that's what you want? Also there're no problem in restoring from a
BAK file that's placed on a different server than the one that runs SQL. You
just specify the UNC path of the BAK file in your restore command.
Regards
Steen
J Hotch wrote:[vbcol=seagreen]
> thanks Wei, not the answer i was hoping for but at least it means i
> dont have to spend ages trying to find a solution that doesnt exist.
> thanks again.
> "wei xiao [MSFT]" wrote:
>sql
Showing posts with label sdlt. Show all posts
Showing posts with label sdlt. Show all posts
Friday, March 23, 2012
restoring SQL backup on non SQL server??
I'll try to keep this as simple but clear as i can.
i have a backup on an SDLT tape taken from a SQL server using the SQL backup
to a locally attached device. i now want to restore the *.BAK file from this
tape to another server, but this server isnt running SQL.
i'm trying to use native NT2000 backup but it doesnt seam to like the tape,
as i kind of expected. does anyone know how i can restore this data without
having to use a SQL server (i.e. just a standard NT2000 server with local
SDLT drive)?
many thanks in advance for your help
The backup made from SQL Server can only be used by SQL Server to restore a
database.
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://blogs.msdn.com/weix
This posting is provided "AS IS" with no warranties, and confers no rights.
"J Hotch" <jonathan.hotchkiss-remove-@.tesco.net> wrote in message
news:B5422198-6C81-427F-B9BA-DC0AAC0CBA92@.microsoft.com...
> I'll try to keep this as simple but clear as i can.
> i have a backup on an SDLT tape taken from a SQL server using the SQL
> backup
> to a locally attached device. i now want to restore the *.BAK file from
> this
> tape to another server, but this server isnt running SQL.
> i'm trying to use native NT2000 backup but it doesnt seam to like the
> tape,
> as i kind of expected. does anyone know how i can restore this data
> without
> having to use a SQL server (i.e. just a standard NT2000 server with local
> SDLT drive)?
> many thanks in advance for your help
|||thanks Wei, not the answer i was hoping for but at least it means i dont have
to spend ages trying to find a solution that doesnt exist.
thanks again.
"wei xiao [MSFT]" wrote:
> The backup made from SQL Server can only be used by SQL Server to restore a
> database.
> --
> Wei Xiao [MSFT]
> SQL Server Storage Engine Development
> http://blogs.msdn.com/weix
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "J Hotch" <jonathan.hotchkiss-remove-@.tesco.net> wrote in message
> news:B5422198-6C81-427F-B9BA-DC0AAC0CBA92@.microsoft.com...
>
>
|||I don't know what you want to achieve with this operation, but there're no
problem in restoring the .BAK file as such to a server that doesn't run SQL.
To do that you just restore it like every other file. To get the BAK file
"back" to your database and logfiles will require SQL Server, but I don't
know if that's what you want? Also there're no problem in restoring from a
BAK file that's placed on a different server than the one that runs SQL. You
just specify the UNC path of the BAK file in your restore command.
Regards
Steen
J Hotch wrote:[vbcol=seagreen]
> thanks Wei, not the answer i was hoping for but at least it means i
> dont have to spend ages trying to find a solution that doesnt exist.
> thanks again.
> "wei xiao [MSFT]" wrote:
i have a backup on an SDLT tape taken from a SQL server using the SQL backup
to a locally attached device. i now want to restore the *.BAK file from this
tape to another server, but this server isnt running SQL.
i'm trying to use native NT2000 backup but it doesnt seam to like the tape,
as i kind of expected. does anyone know how i can restore this data without
having to use a SQL server (i.e. just a standard NT2000 server with local
SDLT drive)?
many thanks in advance for your help
The backup made from SQL Server can only be used by SQL Server to restore a
database.
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://blogs.msdn.com/weix
This posting is provided "AS IS" with no warranties, and confers no rights.
"J Hotch" <jonathan.hotchkiss-remove-@.tesco.net> wrote in message
news:B5422198-6C81-427F-B9BA-DC0AAC0CBA92@.microsoft.com...
> I'll try to keep this as simple but clear as i can.
> i have a backup on an SDLT tape taken from a SQL server using the SQL
> backup
> to a locally attached device. i now want to restore the *.BAK file from
> this
> tape to another server, but this server isnt running SQL.
> i'm trying to use native NT2000 backup but it doesnt seam to like the
> tape,
> as i kind of expected. does anyone know how i can restore this data
> without
> having to use a SQL server (i.e. just a standard NT2000 server with local
> SDLT drive)?
> many thanks in advance for your help
|||thanks Wei, not the answer i was hoping for but at least it means i dont have
to spend ages trying to find a solution that doesnt exist.
thanks again.
"wei xiao [MSFT]" wrote:
> The backup made from SQL Server can only be used by SQL Server to restore a
> database.
> --
> Wei Xiao [MSFT]
> SQL Server Storage Engine Development
> http://blogs.msdn.com/weix
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "J Hotch" <jonathan.hotchkiss-remove-@.tesco.net> wrote in message
> news:B5422198-6C81-427F-B9BA-DC0AAC0CBA92@.microsoft.com...
>
>
|||I don't know what you want to achieve with this operation, but there're no
problem in restoring the .BAK file as such to a server that doesn't run SQL.
To do that you just restore it like every other file. To get the BAK file
"back" to your database and logfiles will require SQL Server, but I don't
know if that's what you want? Also there're no problem in restoring from a
BAK file that's placed on a different server than the one that runs SQL. You
just specify the UNC path of the BAK file in your restore command.
Regards
Steen
J Hotch wrote:[vbcol=seagreen]
> thanks Wei, not the answer i was hoping for but at least it means i
> dont have to spend ages trying to find a solution that doesnt exist.
> thanks again.
> "wei xiao [MSFT]" wrote:
restoring SQL backup on non SQL server??
I'll try to keep this as simple but clear as i can.
i have a backup on an SDLT tape taken from a SQL server using the SQL backup
to a locally attached device. i now want to restore the *.BAK file from this
tape to another server, but this server isnt running SQL.
i'm trying to use native NT2000 backup but it doesnt seam to like the tape,
as i kind of expected. does anyone know how i can restore this data without
having to use a SQL server (i.e. just a standard NT2000 server with local
SDLT drive)?
many thanks in advance for your helpThe backup made from SQL Server can only be used by SQL Server to restore a
database.
--
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://blogs.msdn.com/weix
This posting is provided "AS IS" with no warranties, and confers no rights.
"J Hotch" <jonathan.hotchkiss-remove-@.tesco.net> wrote in message
news:B5422198-6C81-427F-B9BA-DC0AAC0CBA92@.microsoft.com...
> I'll try to keep this as simple but clear as i can.
> i have a backup on an SDLT tape taken from a SQL server using the SQL
> backup
> to a locally attached device. i now want to restore the *.BAK file from
> this
> tape to another server, but this server isnt running SQL.
> i'm trying to use native NT2000 backup but it doesnt seam to like the
> tape,
> as i kind of expected. does anyone know how i can restore this data
> without
> having to use a SQL server (i.e. just a standard NT2000 server with local
> SDLT drive)?
> many thanks in advance for your help|||thanks Wei, not the answer i was hoping for but at least it means i dont have
to spend ages trying to find a solution that doesnt exist.
thanks again.
"wei xiao [MSFT]" wrote:
> The backup made from SQL Server can only be used by SQL Server to restore a
> database.
> --
> Wei Xiao [MSFT]
> SQL Server Storage Engine Development
> http://blogs.msdn.com/weix
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "J Hotch" <jonathan.hotchkiss-remove-@.tesco.net> wrote in message
> news:B5422198-6C81-427F-B9BA-DC0AAC0CBA92@.microsoft.com...
> > I'll try to keep this as simple but clear as i can.
> >
> > i have a backup on an SDLT tape taken from a SQL server using the SQL
> > backup
> > to a locally attached device. i now want to restore the *.BAK file from
> > this
> > tape to another server, but this server isnt running SQL.
> >
> > i'm trying to use native NT2000 backup but it doesnt seam to like the
> > tape,
> > as i kind of expected. does anyone know how i can restore this data
> > without
> > having to use a SQL server (i.e. just a standard NT2000 server with local
> > SDLT drive)?
> >
> > many thanks in advance for your help
>
>|||I don't know what you want to achieve with this operation, but there're no
problem in restoring the .BAK file as such to a server that doesn't run SQL.
To do that you just restore it like every other file. To get the BAK file
"back" to your database and logfiles will require SQL Server, but I don't
know if that's what you want? Also there're no problem in restoring from a
BAK file that's placed on a different server than the one that runs SQL. You
just specify the UNC path of the BAK file in your restore command.
Regards
Steen
J Hotch wrote:
> thanks Wei, not the answer i was hoping for but at least it means i
> dont have to spend ages trying to find a solution that doesnt exist.
> thanks again.
> "wei xiao [MSFT]" wrote:
>> The backup made from SQL Server can only be used by SQL Server to
>> restore a database.
>> --
>> Wei Xiao [MSFT]
>> SQL Server Storage Engine Development
>> http://blogs.msdn.com/weix
>>
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "J Hotch" <jonathan.hotchkiss-remove-@.tesco.net> wrote in message
>> news:B5422198-6C81-427F-B9BA-DC0AAC0CBA92@.microsoft.com...
>> I'll try to keep this as simple but clear as i can.
>> i have a backup on an SDLT tape taken from a SQL server using the
>> SQL backup
>> to a locally attached device. i now want to restore the *.BAK file
>> from this
>> tape to another server, but this server isnt running SQL.
>> i'm trying to use native NT2000 backup but it doesnt seam to like
>> the tape,
>> as i kind of expected. does anyone know how i can restore this data
>> without
>> having to use a SQL server (i.e. just a standard NT2000 server with
>> local SDLT drive)?
>> many thanks in advance for your help
i have a backup on an SDLT tape taken from a SQL server using the SQL backup
to a locally attached device. i now want to restore the *.BAK file from this
tape to another server, but this server isnt running SQL.
i'm trying to use native NT2000 backup but it doesnt seam to like the tape,
as i kind of expected. does anyone know how i can restore this data without
having to use a SQL server (i.e. just a standard NT2000 server with local
SDLT drive)?
many thanks in advance for your helpThe backup made from SQL Server can only be used by SQL Server to restore a
database.
--
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://blogs.msdn.com/weix
This posting is provided "AS IS" with no warranties, and confers no rights.
"J Hotch" <jonathan.hotchkiss-remove-@.tesco.net> wrote in message
news:B5422198-6C81-427F-B9BA-DC0AAC0CBA92@.microsoft.com...
> I'll try to keep this as simple but clear as i can.
> i have a backup on an SDLT tape taken from a SQL server using the SQL
> backup
> to a locally attached device. i now want to restore the *.BAK file from
> this
> tape to another server, but this server isnt running SQL.
> i'm trying to use native NT2000 backup but it doesnt seam to like the
> tape,
> as i kind of expected. does anyone know how i can restore this data
> without
> having to use a SQL server (i.e. just a standard NT2000 server with local
> SDLT drive)?
> many thanks in advance for your help|||thanks Wei, not the answer i was hoping for but at least it means i dont have
to spend ages trying to find a solution that doesnt exist.
thanks again.
"wei xiao [MSFT]" wrote:
> The backup made from SQL Server can only be used by SQL Server to restore a
> database.
> --
> Wei Xiao [MSFT]
> SQL Server Storage Engine Development
> http://blogs.msdn.com/weix
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "J Hotch" <jonathan.hotchkiss-remove-@.tesco.net> wrote in message
> news:B5422198-6C81-427F-B9BA-DC0AAC0CBA92@.microsoft.com...
> > I'll try to keep this as simple but clear as i can.
> >
> > i have a backup on an SDLT tape taken from a SQL server using the SQL
> > backup
> > to a locally attached device. i now want to restore the *.BAK file from
> > this
> > tape to another server, but this server isnt running SQL.
> >
> > i'm trying to use native NT2000 backup but it doesnt seam to like the
> > tape,
> > as i kind of expected. does anyone know how i can restore this data
> > without
> > having to use a SQL server (i.e. just a standard NT2000 server with local
> > SDLT drive)?
> >
> > many thanks in advance for your help
>
>|||I don't know what you want to achieve with this operation, but there're no
problem in restoring the .BAK file as such to a server that doesn't run SQL.
To do that you just restore it like every other file. To get the BAK file
"back" to your database and logfiles will require SQL Server, but I don't
know if that's what you want? Also there're no problem in restoring from a
BAK file that's placed on a different server than the one that runs SQL. You
just specify the UNC path of the BAK file in your restore command.
Regards
Steen
J Hotch wrote:
> thanks Wei, not the answer i was hoping for but at least it means i
> dont have to spend ages trying to find a solution that doesnt exist.
> thanks again.
> "wei xiao [MSFT]" wrote:
>> The backup made from SQL Server can only be used by SQL Server to
>> restore a database.
>> --
>> Wei Xiao [MSFT]
>> SQL Server Storage Engine Development
>> http://blogs.msdn.com/weix
>>
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "J Hotch" <jonathan.hotchkiss-remove-@.tesco.net> wrote in message
>> news:B5422198-6C81-427F-B9BA-DC0AAC0CBA92@.microsoft.com...
>> I'll try to keep this as simple but clear as i can.
>> i have a backup on an SDLT tape taken from a SQL server using the
>> SQL backup
>> to a locally attached device. i now want to restore the *.BAK file
>> from this
>> tape to another server, but this server isnt running SQL.
>> i'm trying to use native NT2000 backup but it doesnt seam to like
>> the tape,
>> as i kind of expected. does anyone know how i can restore this data
>> without
>> having to use a SQL server (i.e. just a standard NT2000 server with
>> local SDLT drive)?
>> many thanks in advance for your help
Subscribe to:
Posts (Atom)