Showing posts with label clear. Show all posts
Showing posts with label clear. 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 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

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:

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

Tuesday, February 21, 2012

Restoring database in SQL - 7

Hi,
Some times, I am getting problem when I am restoring my SQL - 7 database ,
is there any web page which can clear the concept of restore/backup.
Thanks in advance
Hardik ShahBooks Online (the documentation that comes with SQL Server) is the best plac
e to start.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"h" <har_sha_99@.hotmail.com> wrote in message news:ud68KAGaGHA.3896@.TK2MSFTNGP05.phx.gbl...[
vbcol=seagreen]
> Hi,
> Some times, I am getting problem when I am restoring my SQL - 7 database ,
> is there any web page which can clear the concept of restore/backup.
> Thanks in advance
> Hardik Shah
>[/vbcol]|||h wrote:
> Hi,
> Some times, I am getting problem when I am restoring my SQL - 7 database ,
> is there any web page which can clear the concept of restore/backup.
> Thanks in advance
> Hardik Shah
>
As Tibor mentions, Books On Line is a good place to start, but you could
also try to describe the problems you have - then there might be
somebody in here that can help you.
Regards
Steen|||Hi,
my problem is :-
I have installed SQL - 7 at my home and work. instance name of both SQL is
differ.
I have created mydata.bak file at home and trying to restore at work, but I
am fail .
Any hints will be sincerly appreciated.
Hardik Shah
"Steen Persson (DK)" <spe@.REMOVEdatea.dk> wrote in message
news:#3D9oKHaGHA.428@.TK2MSFTNGP02.phx.gbl...
> h wrote:
,[vbcol=seagreen]
> As Tibor mentions, Books On Line is a good place to start, but you could
> also try to describe the problems you have - then there might be
> somebody in here that can help you.
> Regards
> Steen|||h wrote:
> Hi,
> my problem is :-
> I have installed SQL - 7 at my home and work. instance name of both SQL is
> differ.
> I have created mydata.bak file at home and trying to restore at work, but
I
> am fail .
> Any hints will be sincerly appreciated.
> Hardik Shah
>
It would still be a lot easier to give you some hints if you could tell
how you're doing the restore and which error message you get.
Regards
Steen

Restoring database in SQL - 7

Hi,
Some times, I am getting problem when I am restoring my SQL - 7 database ,
is there any web page which can clear the concept of restore/backup.
Thanks in advance
Hardik ShahBooks Online (the documentation that comes with SQL Server) is the best place to start.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"h" <har_sha_99@.hotmail.com> wrote in message news:ud68KAGaGHA.3896@.TK2MSFTNGP05.phx.gbl...
> Hi,
> Some times, I am getting problem when I am restoring my SQL - 7 database ,
> is there any web page which can clear the concept of restore/backup.
> Thanks in advance
> Hardik Shah
>|||h wrote:
> Hi,
> Some times, I am getting problem when I am restoring my SQL - 7 database ,
> is there any web page which can clear the concept of restore/backup.
> Thanks in advance
> Hardik Shah
>
As Tibor mentions, Books On Line is a good place to start, but you could
also try to describe the problems you have - then there might be
somebody in here that can help you.
Regards
Steen|||Hi,
my problem is :-
I have installed SQL - 7 at my home and work. instance name of both SQL is
differ.
I have created mydata.bak file at home and trying to restore at work, but I
am fail .
Any hints will be sincerly appreciated.
Hardik Shah
"Steen Persson (DK)" <spe@.REMOVEdatea.dk> wrote in message
news:#3D9oKHaGHA.428@.TK2MSFTNGP02.phx.gbl...
> h wrote:
> > Hi,
> >
> > Some times, I am getting problem when I am restoring my SQL - 7 database
,
> > is there any web page which can clear the concept of restore/backup.
> >
> > Thanks in advance
> >
> > Hardik Shah
> >
> >
> As Tibor mentions, Books On Line is a good place to start, but you could
> also try to describe the problems you have - then there might be
> somebody in here that can help you.
> Regards
> Steen|||h wrote:
> Hi,
> my problem is :-
> I have installed SQL - 7 at my home and work. instance name of both SQL is
> differ.
> I have created mydata.bak file at home and trying to restore at work, but I
> am fail .
> Any hints will be sincerly appreciated.
> Hardik Shah
>
It would still be a lot easier to give you some hints if you could tell
how you're doing the restore and which error message you get.
Regards
Steen