backup restore between sql 2000 2005

hi to all ,
Is it posible to backup a sql 2005 db and restore it to an sql 2000 database ,
I have succesfully done the reverse of it ,that is bakup an sql 2000 db and
restore it to 2005 but could not manage to the reverse of it
any help will be appreciated
regards...
orcunNo, it is not possible. If you need to get the data back to SQL Server
2000, you'll have to use DTS, SSIS, or a similar mechanism.
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"orcun usturali" <orcun usturali@.discussions.microsoft.com> wrote in message
news:7FC04DA0-6AFA-49DB-8B84-BCD1B3F4A7DA@.microsoft.com...
> hi to all ,
> Is it posible to backup a sql 2005 db and restore it to an sql 2000
> database ,
> I have succesfully done the reverse of it ,that is bakup an sql 2000 db
> and
> restore it to 2005 but could not manage to the reverse of it
> any help will be appreciated
> regards...
> orcun
>|||No. You cannot restore or attach a 2005 database to 2000. So your options are script and BCP, DTS,
SSIS and such tools that doesn't work at the binary level.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"orcun usturali" <orcun usturali@.discussions.microsoft.com> wrote in message
news:7FC04DA0-6AFA-49DB-8B84-BCD1B3F4A7DA@.microsoft.com...
> hi to all ,
> Is it posible to backup a sql 2005 db and restore it to an sql 2000 database ,
> I have succesfully done the reverse of it ,that is bakup an sql 2000 db and
> restore it to 2005 but could not manage to the reverse of it
> any help will be appreciated
> regards...
> orcun
>|||No. It does not work.
According with the speaker in the Microsoft Event, the system tables
structure of SQL Server 2005 are different than the ones in SQL 2000,
therefore you cannot go back from newer to older version.
"orcun usturali" wrote:
> hi to all ,
> Is it posible to backup a sql 2005 db and restore it to an sql 2000 database ,
> I have succesfully done the reverse of it ,that is bakup an sql 2000 db and
> restore it to 2005 but could not manage to the reverse of it
> any help will be appreciated
> regards...
> orcun
>|||Could you tell me how do you restore the backup sql 2000. I 've got an error
when I restore a database saved by sql2000.
thanks for your help
"orcun usturali" wrote:
> hi to all ,
> Is it posible to backup a sql 2005 db and restore it to an sql 2000 database ,
> I have succesfully done the reverse of it ,that is bakup an sql 2000 db and
> restore it to 2005 but could not manage to the reverse of it
> any help will be appreciated
> regards...
> orcun
>|||Just execute the RESTORE command, just as if you would restore onto a 2000 server.
Can you post the RESTORE command you executed and the error message?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"PBENISTY" <pbenisty@.newsgroups.nospam> wrote in message
news:C17F6E09-3525-43ED-B1F5-A0CE00EDB518@.microsoft.com...
> Could you tell me how do you restore the backup sql 2000. I 've got an error
> when I restore a database saved by sql2000.
> thanks for your help
> "orcun usturali" wrote:
>> hi to all ,
>> Is it posible to backup a sql 2005 db and restore it to an sql 2000 database ,
>> I have succesfully done the reverse of it ,that is bakup an sql 2000 db and
>> restore it to 2005 but could not manage to the reverse of it
>> any help will be appreciated
>> regards...
>> orcun
>>|||Sorry
ı didnt correctly understand what do you mean
my mail adress is orcunu@.biltas.com.tr
if you want to ask for anything lets continue on this mail adress
"PBENISTY" wrote:
> Could you tell me how do you restore the backup sql 2000. I 've got an error
> when I restore a database saved by sql2000.
> thanks for your help
> "orcun usturali" wrote:
> > hi to all ,
> >
> > Is it posible to backup a sql 2005 db and restore it to an sql 2000 database ,
> >
> > I have succesfully done the reverse of it ,that is bakup an sql 2000 db and
> > restore it to 2005 but could not manage to the reverse of it
> >
> > any help will be appreciated
> >
> > regards...
> > orcun
> >
> >

backup restore between sql 2000 2005

hi to all ,
Is it posible to backup a sql 2005 db and restore it to an sql 2000 database ,
I have succesfully done the reverse of it ,that is bakup an sql 2000 db and
restore it to 2005 but could not manage to the reverse of it
any help will be appreciated
regards...
orcun
No, it is not possible. If you need to get the data back to SQL Server
2000, you'll have to use DTS, SSIS, or a similar mechanism.
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
"orcun usturali" <orcun usturali@.discussions.microsoft.com> wrote in message
news:7FC04DA0-6AFA-49DB-8B84-BCD1B3F4A7DA@.microsoft.com...
> hi to all ,
> Is it posible to backup a sql 2005 db and restore it to an sql 2000
> database ,
> I have succesfully done the reverse of it ,that is bakup an sql 2000 db
> and
> restore it to 2005 but could not manage to the reverse of it
> any help will be appreciated
> regards...
> orcun
>
|||No. You cannot restore or attach a 2005 database to 2000. So your options are script and BCP, DTS,
SSIS and such tools that doesn't work at the binary level.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"orcun usturali" <orcun usturali@.discussions.microsoft.com> wrote in message
news:7FC04DA0-6AFA-49DB-8B84-BCD1B3F4A7DA@.microsoft.com...
> hi to all ,
> Is it posible to backup a sql 2005 db and restore it to an sql 2000 database ,
> I have succesfully done the reverse of it ,that is bakup an sql 2000 db and
> restore it to 2005 but could not manage to the reverse of it
> any help will be appreciated
> regards...
> orcun
>
|||No. It does not work.
According with the speaker in the Microsoft Event, the system tables
structure of SQL Server 2005 are different than the ones in SQL 2000,
therefore you cannot go back from newer to older version.
"orcun usturali" wrote:

> hi to all ,
> Is it posible to backup a sql 2005 db and restore it to an sql 2000 database ,
> I have succesfully done the reverse of it ,that is bakup an sql 2000 db and
> restore it to 2005 but could not manage to the reverse of it
> any help will be appreciated
> regards...
> orcun
>
|||Could you tell me how do you restore the backup sql 2000. I 've got an error
when I restore a database saved by sql2000.
thanks for your help
"orcun usturali" wrote:

> hi to all ,
> Is it posible to backup a sql 2005 db and restore it to an sql 2000 database ,
> I have succesfully done the reverse of it ,that is bakup an sql 2000 db and
> restore it to 2005 but could not manage to the reverse of it
> any help will be appreciated
> regards...
> orcun
>
|||Just execute the RESTORE command, just as if you would restore onto a 2000 server.
Can you post the RESTORE command you executed and the error message?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"PBENISTY" <pbenisty@.newsgroups.nospam> wrote in message
news:C17F6E09-3525-43ED-B1F5-A0CE00EDB518@.microsoft.com...[vbcol=seagreen]
> Could you tell me how do you restore the backup sql 2000. I 've got an error
> when I restore a database saved by sql2000.
> thanks for your help
> "orcun usturali" wrote:
|||Sorry
? didnt correctly understand what do you mean
my mail adress is orcunu@.biltas.com.tr
if you want to ask for anything lets continue on this mail adress
"PBENISTY" wrote:
[vbcol=seagreen]
> Could you tell me how do you restore the backup sql 2000. I 've got an error
> when I restore a database saved by sql2000.
> thanks for your help
> "orcun usturali" wrote:

backup restore between sql 2000 2005

hi to all ,
Is it posible to backup a sql 2005 db and restore it to an sql 2000 database
,
I have succesfully done the reverse of it ,that is bakup an sql 2000 db and
restore it to 2005 but could not manage to the reverse of it
any help will be appreciated
regards...
orcunNo, it is not possible. If you need to get the data back to SQL Server
2000, you'll have to use DTS, SSIS, or a similar mechanism.
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"orcun usturali" <orcun usturali@.discussions.microsoft.com> wrote in message
news:7FC04DA0-6AFA-49DB-8B84-BCD1B3F4A7DA@.microsoft.com...
> hi to all ,
> Is it posible to backup a sql 2005 db and restore it to an sql 2000
> database ,
> I have succesfully done the reverse of it ,that is bakup an sql 2000 db
> and
> restore it to 2005 but could not manage to the reverse of it
> any help will be appreciated
> regards...
> orcun
>|||No. You cannot restore or attach a 2005 database to 2000. So your options ar
e script and BCP, DTS,
SSIS and such tools that doesn't work at the binary level.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"orcun usturali" <orcun usturali@.discussions.microsoft.com> wrote in message
news:7FC04DA0-6AFA-49DB-8B84-BCD1B3F4A7DA@.microsoft.com...
> hi to all ,
> Is it posible to backup a sql 2005 db and restore it to an sql 2000 databa
se ,
> I have succesfully done the reverse of it ,that is bakup an sql 2000 db an
d
> restore it to 2005 but could not manage to the reverse of it
> any help will be appreciated
> regards...
> orcun
>|||No. It does not work.
According with the speaker in the Microsoft Event, the system tables
structure of SQL Server 2005 are different than the ones in SQL 2000,
therefore you cannot go back from newer to older version.
"orcun usturali" wrote:

> hi to all ,
> Is it posible to backup a sql 2005 db and restore it to an sql 2000 databa
se ,
> I have succesfully done the reverse of it ,that is bakup an sql 2000 db an
d
> restore it to 2005 but could not manage to the reverse of it
> any help will be appreciated
> regards...
> orcun
>|||Could you tell me how do you restore the backup sql 2000. I 've got an error
when I restore a database saved by sql2000.
thanks for your help
"orcun usturali" wrote:

> hi to all ,
> Is it posible to backup a sql 2005 db and restore it to an sql 2000 databa
se ,
> I have succesfully done the reverse of it ,that is bakup an sql 2000 db an
d
> restore it to 2005 but could not manage to the reverse of it
> any help will be appreciated
> regards...
> orcun
>|||Just execute the RESTORE command, just as if you would restore onto a 2000 s
erver.
Can you post the RESTORE command you executed and the error message?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"PBENISTY" <pbenisty@.newsgroups.nospam> wrote in message
news:C17F6E09-3525-43ED-B1F5-A0CE00EDB518@.microsoft.com...[vbcol=seagreen]
> Could you tell me how do you restore the backup sql 2000. I 've got an err
or
> when I restore a database saved by sql2000.
> thanks for your help
> "orcun usturali" wrote:
>|||Sorry
? didnt correctly understand what do you mean
my mail adress is orcunu@.biltas.com.tr
if you want to ask for anything lets continue on this mail adress
"PBENISTY" wrote:
[vbcol=seagreen]
> Could you tell me how do you restore the backup sql 2000. I 've got an err
or
> when I restore a database saved by sql2000.
> thanks for your help
> "orcun usturali" wrote:
>sql

backup LSN help

I've been working on some code to be able to reverse catalog a set of
backups into the msdb backup* tables, which was easy, but now I'm struggling
with the necessary code to create the restore commands for an arbitrary
point in time.
My question is what is the appropriate logic or psuedo code for walking a
tree backup resources to get to a point in time.
I believe the following to be appropriate logic, but would like
verification:
full backup id = (max (checkpointlsn) where finishtime<[point in time]) and
type = 1
differential backup id = (max(checkpointlsn) where backuplsn = full backup
checkpointlsn and type = 5 and finishtime<[point in time])
But I am still struggling with the T-log resources and how to put it all
together (like for example, if you simply cannot get to a given point in
time given a set of files, and only wanting to restore the necessary the
last t-log where the lsn hasn't changed in 10 backup files)
Help!?
Bump
<news@.news.com> wrote in message
news:%23l52asjXEHA.1656@.TK2MSFTNGP09.phx.gbl...
> I've been working on some code to be able to reverse catalog a set of
> backups into the msdb backup* tables, which was easy, but now I'm
struggling
> with the necessary code to create the restore commands for an arbitrary
> point in time.
> My question is what is the appropriate logic or psuedo code for walking a
> tree backup resources to get to a point in time.
> I believe the following to be appropriate logic, but would like
> verification:
> full backup id = (max (checkpointlsn) where finishtime<[point in time])
and
> type = 1
> differential backup id = (max(checkpointlsn) where backuplsn = full backup
> checkpointlsn and type = 5 and finishtime<[point in time])
> But I am still struggling with the T-log resources and how to put it all
> together (like for example, if you simply cannot get to a given point in
> time given a set of files, and only wanting to restore the necessary the
> last t-log where the lsn hasn't changed in 10 backup files)
> Help!?
>
>
>
>
>

backup LSN help

I've been working on some code to be able to reverse catalog a set of
backups into the msdb backup* tables, which was easy, but now I'm struggling
with the necessary code to create the restore commands for an arbitrary
point in time.
My question is what is the appropriate logic or psuedo code for walking a
tree backup resources to get to a point in time.
I believe the following to be appropriate logic, but would like
verification:
full backup id = (max (checkpointlsn) where finishtime<[point in time]) and
type = 1
differential backup id = (max(checkpointlsn) where backuplsn = full backup
checkpointlsn and type = 5 and finishtime<[point in time])
But I am still struggling with the T-log resources and how to put it all
together (like for example, if you simply cannot get to a given point in
time given a set of files, and only wanting to restore the necessary the
last t-log where the lsn hasn't changed in 10 backup files)
Help!?Bump
<news@.news.com> wrote in message
news:%23l52asjXEHA.1656@.TK2MSFTNGP09.phx.gbl...
> I've been working on some code to be able to reverse catalog a set of
> backups into the msdb backup* tables, which was easy, but now I'm
struggling
> with the necessary code to create the restore commands for an arbitrary
> point in time.
> My question is what is the appropriate logic or psuedo code for walking a
> tree backup resources to get to a point in time.
> I believe the following to be appropriate logic, but would like
> verification:
> full backup id = (max (checkpointlsn) where finishtime<[point in time])
and
> type = 1
> differential backup id = (max(checkpointlsn) where backuplsn = full backup
> checkpointlsn and type = 5 and finishtime<[point in time])
> But I am still struggling with the T-log resources and how to put it all
> together (like for example, if you simply cannot get to a given point in
> time given a set of files, and only wanting to restore the necessary the
> last t-log where the lsn hasn't changed in 10 backup files)
> Help!?
>
>
>
>
>

backup LSN help

I've been working on some code to be able to reverse catalog a set of
backups into the msdb backup* tables, which was easy, but now I'm struggling
with the necessary code to create the restore commands for an arbitrary
point in time.
My question is what is the appropriate logic or psuedo code for walking a
tree backup resources to get to a point in time.
I believe the following to be appropriate logic, but would like
verification:
full backup id = (max (checkpointlsn) where finishtime<[point in time])
and
type = 1
differential backup id = (max(checkpointlsn) where backuplsn = full backup
checkpointlsn and type = 5 and finishtime<[point in time])
But I am still struggling with the T-log resources and how to put it all
together (like for example, if you simply cannot get to a given point in
time given a set of files, and only wanting to restore the necessary the
last t-log where the lsn hasn't changed in 10 backup files)
Help!?Bump
<news@.news.com> wrote in message
news:%23l52asjXEHA.1656@.TK2MSFTNGP09.phx.gbl...
> I've been working on some code to be able to reverse catalog a set of
> backups into the msdb backup* tables, which was easy, but now I'm
struggling
> with the necessary code to create the restore commands for an arbitrary
> point in time.
> My question is what is the appropriate logic or psuedo code for walking a
> tree backup resources to get to a point in time.
> I believe the following to be appropriate logic, but would like
> verification:
> full backup id = (max (checkpointlsn) where finishtime<[point in time])[/vbcol
]
and[vbcol=seagreen]
> type = 1
> differential backup id = (max(checkpointlsn) where backuplsn = full backup
> checkpointlsn and type = 5 and finishtime<[point in time])
> But I am still struggling with the T-log resources and how to put it all
> together (like for example, if you simply cannot get to a given point in
> time given a set of files, and only wanting to restore the necessary the
> last t-log where the lsn hasn't changed in 10 backup files)
> Help!?
>
>
>
>
>