|
Home > Archive > MS SQL Server > October 2006 > restoring with StopBeforeMark
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
restoring with StopBeforeMark
|
|
| bajopalabra 2006-10-24, 6:30 pm |
| hi
i did :
create table pp ( id int )
backup full
insert into pp values ( 1 )
backup diff
insert into pp values ( 2 )
backup log 1
insert into pp values ( 3 )
backup log 2
insert into pp values ( 4 )
backup log 3 -- tail
i want to restore
the rows 1, 2, and 3
the way i'm trying is this :
restore database [xx] from TheBackUp with
NOrecovery,
StopBeforeMark= 'LSN of backup log 4'
but,
i get a table with no rows
what is wrong ??
TIA
--
atte,
Hernán
--
atte,
Hernán
| |
| bajopalabra 2006-10-24, 6:30 pm |
| ohhhh...
i understand now...
i have to restore
the whole the backup chain
from the first to the last
but using the StopBeforeClause...
is there a way to restore
the whole backup chain in one line ?
should i to write a "loop"
for restore each row
that RESTORE HEADERONLY bring me ??
--
atte,
Hernán
"bajopalabra" <bajopalabra@hotmail.com> escribió en el mensaje
news:%23kiu9On3GHA.696@TK2MSFTNGP03.phx.gbl...
| hi
| i did :
|
| create table pp ( id int )
| backup full
| insert into pp values ( 1 )
| backup diff
| insert into pp values ( 2 )
| backup log 1
| insert into pp values ( 3 )
| backup log 2
| insert into pp values ( 4 )
| backup log 3 -- tail
|
| i want to restore
| the rows 1, 2, and 3
|
| the way i'm trying is this :
|
| restore database [xx] from TheBackUp with
| NOrecovery,
| StopBeforeMark= 'LSN of backup log 4'
|
| but,
| i get a table with no rows
|
| what is wrong ??
|
| TIA
|
| --
| atte,
| Hernán
|
| --
| atte,
| Hernán
|
|
| |
| Tibor Karaszi 2006-10-24, 6:31 pm |
| Already replied in .programming. Please don't multi-post.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
"bajopalabra" <bajopalabra@hotmail.com> wrote in message
news:uVMa5gn3GHA.4976@TK2MSFTNGP02.phx.gbl...
> ohhhh...
> i understand now...
>
> i have to restore
> the whole the backup chain
> from the first to the last
> but using the StopBeforeClause...
>
> is there a way to restore
> the whole backup chain in one line ?
>
> should i to write a "loop"
> for restore each row
> that RESTORE HEADERONLY bring me ??
>
> --
> atte,
> Hernán
> "bajopalabra" <bajopalabra@hotmail.com> escribió en el mensaje
> news:%23kiu9On3GHA.696@TK2MSFTNGP03.phx.gbl...
> | hi
> | i did :
> |
> | create table pp ( id int )
> | backup full
> | insert into pp values ( 1 )
> | backup diff
> | insert into pp values ( 2 )
> | backup log 1
> | insert into pp values ( 3 )
> | backup log 2
> | insert into pp values ( 4 )
> | backup log 3 -- tail
> |
> | i want to restore
> | the rows 1, 2, and 3
> |
> | the way i'm trying is this :
> |
> | restore database [xx] from TheBackUp with
> | NOrecovery,
> | StopBeforeMark= 'LSN of backup log 4'
> |
> | but,
> | i get a table with no rows
> |
> | what is wrong ??
> |
> | TIA
> |
> | --
> | atte,
> | Hernán
> |
> | --
> | atte,
> | Hernán
> |
> |
>
>
|
|
|
|
|