Do differential backups have to be backed up into the same
file/device as the original backup? or can I make a
seperate file/device'not necessarily, you can create it on the seperate device as well.
--
- Vishal
"susan" <susanbauer@.yahoo.com> wrote in message
news:057801c37e23$7f417fe0$a301280a@.phx.gbl...
> Do differential backups have to be backed up into the same
> file/device as the original backup? or can I make a
> seperate file/device'
>
Showing posts with label backed. Show all posts
Showing posts with label backed. Show all posts
Monday, March 19, 2012
Sunday, March 11, 2012
Differential backups of sql2k w/BackupExec huge
I am running Sql2k to house my 7GB database. I ran a full backup this
morning and saw amount of data backed up was 7GB. I then decided to try
doing a differential backup to see if it might be a good mid-day solution.
Normally I would do several log backups during the day but because the
application does several unpredictable bulk inserts of external data daily,
my understanding is that this breaks the transaction log sequence and as
such log backup won't work.
Anyway, when I did this differential backup I was very surprised to find
that the 2 users on my system were able to make 2.35GB of changes in an hour
and a half. I know, that isn't necessarily what it means when you get such a
huge diff backup, but what I want to know is why could this be happening and
what options are available to me for mid-day backups. I ran another diff
backup an hour later and 2.4 GB was backed up.
My hunch is that something is causing checkpoints that are trunc'ing the log
such as the db or log auto-growing. To counter these possiblities, I
increased the size of the DB to 10GB and the log file is 500MB just to be
safe.
If I am right and something is causing checkpoints, how can I find out what
it is? I didn't write the app, I am just stuck supporting it.
Mike
<><Whether or not and when checkpoints are occurring does not affect
differential backups... Only data which has changed since the last complete
backup... so those users have changed mucho data...
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it community
of SQL Server professionals.
www.sqlpass.org
"Mike Strout" <m i k e s t r o u t @. h o t m a i l . c o m> wrote in message
news:vii9cd3i46t953@.corp.supernews.com...
> I am running Sql2k to house my 7GB database. I ran a full backup this
> morning and saw amount of data backed up was 7GB. I then decided to try
> doing a differential backup to see if it might be a good mid-day solution.
> Normally I would do several log backups during the day but because the
> application does several unpredictable bulk inserts of external data
daily,
> my understanding is that this breaks the transaction log sequence and as
> such log backup won't work.
> Anyway, when I did this differential backup I was very surprised to find
> that the 2 users on my system were able to make 2.35GB of changes in an
hour
> and a half. I know, that isn't necessarily what it means when you get such
a
> huge diff backup, but what I want to know is why could this be happening
and
> what options are available to me for mid-day backups. I ran another diff
> backup an hour later and 2.4 GB was backed up.
> My hunch is that something is causing checkpoints that are trunc'ing the
log
> such as the db or log auto-growing. To counter these possiblities, I
> increased the size of the DB to 10GB and the log file is 500MB just to be
> safe.
> If I am right and something is causing checkpoints, how can I find out
what
> it is? I didn't write the app, I am just stuck supporting it.
> Mike
> <><
>|||Is it possible that index rebuilds or some other bulk operation took place
that would have moved or changed a vast amount of pages in the database?
"Mike Strout" <m i k e s t r o u t @. h o t m a i l . c o m> wrote in message
news:vii9cd3i46t953@.corp.supernews.com...
> I am running Sql2k to house my 7GB database. I ran a full backup this
> morning and saw amount of data backed up was 7GB. I then decided to try
> doing a differential backup to see if it might be a good mid-day solution.
> Normally I would do several log backups during the day but because the
> application does several unpredictable bulk inserts of external data
daily,
> my understanding is that this breaks the transaction log sequence and as
> such log backup won't work.
> Anyway, when I did this differential backup I was very surprised to find
> that the 2 users on my system were able to make 2.35GB of changes in an
hour
> and a half. I know, that isn't necessarily what it means when you get such
a
> huge diff backup, but what I want to know is why could this be happening
and
> what options are available to me for mid-day backups. I ran another diff
> backup an hour later and 2.4 GB was backed up.
> My hunch is that something is causing checkpoints that are trunc'ing the
log
> such as the db or log auto-growing. To counter these possiblities, I
> increased the size of the DB to 10GB and the log file is 500MB just to be
> safe.
> If I am right and something is causing checkpoints, how can I find out
what
> it is? I didn't write the app, I am just stuck supporting it.
> Mike
> <><
>|||Mike Strout (m i k e s t r o u t @. h o t m a i l . c o m) writes:
> Normally I would do several log backups during the day but because the
> application does several unpredictable bulk inserts of external data
> daily, my understanding is that this breaks the transaction log sequence
> and as such log backup won't work.
No, that is not the case. Assuming of course, you are not running in
Simple recovery mode that is. And that you bulk-load operations does
not include BACKUP LOG db WITH NO_LOG.
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
morning and saw amount of data backed up was 7GB. I then decided to try
doing a differential backup to see if it might be a good mid-day solution.
Normally I would do several log backups during the day but because the
application does several unpredictable bulk inserts of external data daily,
my understanding is that this breaks the transaction log sequence and as
such log backup won't work.
Anyway, when I did this differential backup I was very surprised to find
that the 2 users on my system were able to make 2.35GB of changes in an hour
and a half. I know, that isn't necessarily what it means when you get such a
huge diff backup, but what I want to know is why could this be happening and
what options are available to me for mid-day backups. I ran another diff
backup an hour later and 2.4 GB was backed up.
My hunch is that something is causing checkpoints that are trunc'ing the log
such as the db or log auto-growing. To counter these possiblities, I
increased the size of the DB to 10GB and the log file is 500MB just to be
safe.
If I am right and something is causing checkpoints, how can I find out what
it is? I didn't write the app, I am just stuck supporting it.
Mike
<><Whether or not and when checkpoints are occurring does not affect
differential backups... Only data which has changed since the last complete
backup... so those users have changed mucho data...
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it community
of SQL Server professionals.
www.sqlpass.org
"Mike Strout" <m i k e s t r o u t @. h o t m a i l . c o m> wrote in message
news:vii9cd3i46t953@.corp.supernews.com...
> I am running Sql2k to house my 7GB database. I ran a full backup this
> morning and saw amount of data backed up was 7GB. I then decided to try
> doing a differential backup to see if it might be a good mid-day solution.
> Normally I would do several log backups during the day but because the
> application does several unpredictable bulk inserts of external data
daily,
> my understanding is that this breaks the transaction log sequence and as
> such log backup won't work.
> Anyway, when I did this differential backup I was very surprised to find
> that the 2 users on my system were able to make 2.35GB of changes in an
hour
> and a half. I know, that isn't necessarily what it means when you get such
a
> huge diff backup, but what I want to know is why could this be happening
and
> what options are available to me for mid-day backups. I ran another diff
> backup an hour later and 2.4 GB was backed up.
> My hunch is that something is causing checkpoints that are trunc'ing the
log
> such as the db or log auto-growing. To counter these possiblities, I
> increased the size of the DB to 10GB and the log file is 500MB just to be
> safe.
> If I am right and something is causing checkpoints, how can I find out
what
> it is? I didn't write the app, I am just stuck supporting it.
> Mike
> <><
>|||Is it possible that index rebuilds or some other bulk operation took place
that would have moved or changed a vast amount of pages in the database?
"Mike Strout" <m i k e s t r o u t @. h o t m a i l . c o m> wrote in message
news:vii9cd3i46t953@.corp.supernews.com...
> I am running Sql2k to house my 7GB database. I ran a full backup this
> morning and saw amount of data backed up was 7GB. I then decided to try
> doing a differential backup to see if it might be a good mid-day solution.
> Normally I would do several log backups during the day but because the
> application does several unpredictable bulk inserts of external data
daily,
> my understanding is that this breaks the transaction log sequence and as
> such log backup won't work.
> Anyway, when I did this differential backup I was very surprised to find
> that the 2 users on my system were able to make 2.35GB of changes in an
hour
> and a half. I know, that isn't necessarily what it means when you get such
a
> huge diff backup, but what I want to know is why could this be happening
and
> what options are available to me for mid-day backups. I ran another diff
> backup an hour later and 2.4 GB was backed up.
> My hunch is that something is causing checkpoints that are trunc'ing the
log
> such as the db or log auto-growing. To counter these possiblities, I
> increased the size of the DB to 10GB and the log file is 500MB just to be
> safe.
> If I am right and something is causing checkpoints, how can I find out
what
> it is? I didn't write the app, I am just stuck supporting it.
> Mike
> <><
>|||Mike Strout (m i k e s t r o u t @. h o t m a i l . c o m) writes:
> Normally I would do several log backups during the day but because the
> application does several unpredictable bulk inserts of external data
> daily, my understanding is that this breaks the transaction log sequence
> and as such log backup won't work.
No, that is not the case. Assuming of course, you are not running in
Simple recovery mode that is. And that you bulk-load operations does
not include BACKUP LOG db WITH NO_LOG.
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
Differential backups and transaction logs.
Hello. it would be great if someone could help me.
I have a large database (18GB) which is being backed up on the Monday
of every week. Transactions logs are taken every 15mins during the day
and then a diff at the end of the day. My question is this, if a take
a differential at the end of the day can i still restore the
transaction logs from that day after restoring the full backup? I can
restore the full and differentials then the logs fine but when i try
and restore say the full and the transactions it complains that there
is a previous log which there isnt.
Any help would be great at this point.
Try out once again. I have gone thorugh lot of transaction log loads, it
didnt caused me any trouble. I faced the same issue when we transfer it to DR
server, sometimes FTP fail so manually copies it and go for log load which
works fine. Can you post the Error you getting, in that there will be
timestamp saying till what time load happend.
Thanks,
Sree
[Please specify the version of Sql Server as we can save one thread and time
asking back if its 2000 or 2005]
"bungy" wrote:
> Hello. it would be great if someone could help me.
> I have a large database (18GB) which is being backed up on the Monday
> of every week. Transactions logs are taken every 15mins during the day
> and then a diff at the end of the day. My question is this, if a take
> a differential at the end of the day can i still restore the
> transaction logs from that day after restoring the full backup? I can
> restore the full and differentials then the logs fine but when i try
> and restore say the full and the transactions it complains that there
> is a previous log which there isnt.
> Any help would be great at this point.
>
|||Thanks for the help but I found out what the problem was. zip extract
script that was extracting the files wasnt working correctly and the
sproc that is doing the restore wasnt right. Its hard if you didnt
write the bloody thing yourself.
Many thanks,
Sreejith G wrote:[vbcol=seagreen]
> Try out once again. I have gone thorugh lot of transaction log loads, it
> didnt caused me any trouble. I faced the same issue when we transfer it to DR
> server, sometimes FTP fail so manually copies it and go for log load which
> works fine. Can you post the Error you getting, in that there will be
> timestamp saying till what time load happend.
> --
> Thanks,
> Sree
> [Please specify the version of Sql Server as we can save one thread and time
> asking back if its 2000 or 2005]
>
> "bungy" wrote:
I have a large database (18GB) which is being backed up on the Monday
of every week. Transactions logs are taken every 15mins during the day
and then a diff at the end of the day. My question is this, if a take
a differential at the end of the day can i still restore the
transaction logs from that day after restoring the full backup? I can
restore the full and differentials then the logs fine but when i try
and restore say the full and the transactions it complains that there
is a previous log which there isnt.
Any help would be great at this point.
Try out once again. I have gone thorugh lot of transaction log loads, it
didnt caused me any trouble. I faced the same issue when we transfer it to DR
server, sometimes FTP fail so manually copies it and go for log load which
works fine. Can you post the Error you getting, in that there will be
timestamp saying till what time load happend.
Thanks,
Sree
[Please specify the version of Sql Server as we can save one thread and time
asking back if its 2000 or 2005]
"bungy" wrote:
> Hello. it would be great if someone could help me.
> I have a large database (18GB) which is being backed up on the Monday
> of every week. Transactions logs are taken every 15mins during the day
> and then a diff at the end of the day. My question is this, if a take
> a differential at the end of the day can i still restore the
> transaction logs from that day after restoring the full backup? I can
> restore the full and differentials then the logs fine but when i try
> and restore say the full and the transactions it complains that there
> is a previous log which there isnt.
> Any help would be great at this point.
>
|||Thanks for the help but I found out what the problem was. zip extract
script that was extracting the files wasnt working correctly and the
sproc that is doing the restore wasnt right. Its hard if you didnt
write the bloody thing yourself.
Many thanks,
Sreejith G wrote:[vbcol=seagreen]
> Try out once again. I have gone thorugh lot of transaction log loads, it
> didnt caused me any trouble. I faced the same issue when we transfer it to DR
> server, sometimes FTP fail so manually copies it and go for log load which
> works fine. Can you post the Error you getting, in that there will be
> timestamp saying till what time load happend.
> --
> Thanks,
> Sree
> [Please specify the version of Sql Server as we can save one thread and time
> asking back if its 2000 or 2005]
>
> "bungy" wrote:
Labels:
18gb,
backed,
backups,
database,
differential,
logs,
microsoft,
mondayof,
mysql,
oracle,
server,
sql,
transaction,
transactions
Differential backups and transaction logs.
Hello. it would be great if someone could help me.
I have a large database (18GB) which is being backed up on the Monday
of every week. Transactions logs are taken every 15mins during the day
and then a diff at the end of the day. My question is this, if a take
a differential at the end of the day can i still restore the
transaction logs from that day after restoring the full backup? I can
restore the full and differentials then the logs fine but when i try
and restore say the full and the transactions it complains that there
is a previous log which there isnt.
Any help would be great at this point.Try out once again. I have gone thorugh lot of transaction log loads, it
didnt caused me any trouble. I faced the same issue when we transfer it to D
R
server, sometimes FTP fail so manually copies it and go for log load which
works fine. Can you post the Error you getting, in that there will be
timestamp saying till what time load happend.
Thanks,
Sree
[Please specify the version of Sql Server as we can save one thread and
time
asking back if its 2000 or 2005]
"bungy" wrote:
> Hello. it would be great if someone could help me.
> I have a large database (18GB) which is being backed up on the Monday
> of every week. Transactions logs are taken every 15mins during the day
> and then a diff at the end of the day. My question is this, if a take
> a differential at the end of the day can i still restore the
> transaction logs from that day after restoring the full backup? I can
> restore the full and differentials then the logs fine but when i try
> and restore say the full and the transactions it complains that there
> is a previous log which there isnt.
> Any help would be great at this point.
>|||Thanks for the help but I found out what the problem was. zip extract
script that was extracting the files wasnt working correctly and the
sproc that is doing the restore wasnt right. Its hard if you didnt
write the bloody thing yourself.
Many thanks,
Sreejith G wrote:[vbcol=seagreen]
> Try out once again. I have gone thorugh lot of transaction log loads, it
> didnt caused me any trouble. I faced the same issue when we transfer it to
DR
> server, sometimes FTP fail so manually copies it and go for log load which
> works fine. Can you post the Error you getting, in that there will be
> timestamp saying till what time load happend.
> --
> Thanks,
> Sree
> [Please specify the version of Sql Server as we can save one thread an
d time
> asking back if its 2000 or 2005]
>
> "bungy" wrote:
>
I have a large database (18GB) which is being backed up on the Monday
of every week. Transactions logs are taken every 15mins during the day
and then a diff at the end of the day. My question is this, if a take
a differential at the end of the day can i still restore the
transaction logs from that day after restoring the full backup? I can
restore the full and differentials then the logs fine but when i try
and restore say the full and the transactions it complains that there
is a previous log which there isnt.
Any help would be great at this point.Try out once again. I have gone thorugh lot of transaction log loads, it
didnt caused me any trouble. I faced the same issue when we transfer it to D
R
server, sometimes FTP fail so manually copies it and go for log load which
works fine. Can you post the Error you getting, in that there will be
timestamp saying till what time load happend.
Thanks,
Sree
[Please specify the version of Sql Server as we can save one thread and
time
asking back if its 2000 or 2005]
"bungy" wrote:
> Hello. it would be great if someone could help me.
> I have a large database (18GB) which is being backed up on the Monday
> of every week. Transactions logs are taken every 15mins during the day
> and then a diff at the end of the day. My question is this, if a take
> a differential at the end of the day can i still restore the
> transaction logs from that day after restoring the full backup? I can
> restore the full and differentials then the logs fine but when i try
> and restore say the full and the transactions it complains that there
> is a previous log which there isnt.
> Any help would be great at this point.
>|||Thanks for the help but I found out what the problem was. zip extract
script that was extracting the files wasnt working correctly and the
sproc that is doing the restore wasnt right. Its hard if you didnt
write the bloody thing yourself.
Many thanks,
Sreejith G wrote:[vbcol=seagreen]
> Try out once again. I have gone thorugh lot of transaction log loads, it
> didnt caused me any trouble. I faced the same issue when we transfer it to
DR
> server, sometimes FTP fail so manually copies it and go for log load which
> works fine. Can you post the Error you getting, in that there will be
> timestamp saying till what time load happend.
> --
> Thanks,
> Sree
> [Please specify the version of Sql Server as we can save one thread an
d time
> asking back if its 2000 or 2005]
>
> "bungy" wrote:
>
Labels:
18gb,
backed,
backups,
database,
differential,
logs,
microsoft,
mondayof,
mysql,
oracle,
server,
sql,
transaction,
transactions
Differential backups and transaction logs.
Hello. it would be great if someone could help me.
I have a large database (18GB) which is being backed up on the Monday
of every week. Transactions logs are taken every 15mins during the day
and then a diff at the end of the day. My question is this, if a take
a differential at the end of the day can i still restore the
transaction logs from that day after restoring the full backup? I can
restore the full and differentials then the logs fine but when i try
and restore say the full and the transactions it complains that there
is a previous log which there isnt.
Any help would be great at this point.Try out once again. I have gone thorugh lot of transaction log loads, it
didnt caused me any trouble. I faced the same issue when we transfer it to DR
server, sometimes FTP fail so manually copies it and go for log load which
works fine. Can you post the Error you getting, in that there will be
timestamp saying till what time load happend.
--
Thanks,
Sree
[Please specify the version of Sql Server as we can save one thread and time
asking back if its 2000 or 2005]
"bungy" wrote:
> Hello. it would be great if someone could help me.
> I have a large database (18GB) which is being backed up on the Monday
> of every week. Transactions logs are taken every 15mins during the day
> and then a diff at the end of the day. My question is this, if a take
> a differential at the end of the day can i still restore the
> transaction logs from that day after restoring the full backup? I can
> restore the full and differentials then the logs fine but when i try
> and restore say the full and the transactions it complains that there
> is a previous log which there isnt.
> Any help would be great at this point.
>|||Thanks for the help but I found out what the problem was. zip extract
script that was extracting the files wasnt working correctly and the
sproc that is doing the restore wasnt right. Its hard if you didnt
write the bloody thing yourself.
Many thanks,
Sreejith G wrote:
> Try out once again. I have gone thorugh lot of transaction log loads, it
> didnt caused me any trouble. I faced the same issue when we transfer it to DR
> server, sometimes FTP fail so manually copies it and go for log load which
> works fine. Can you post the Error you getting, in that there will be
> timestamp saying till what time load happend.
> --
> Thanks,
> Sree
> [Please specify the version of Sql Server as we can save one thread and time
> asking back if its 2000 or 2005]
>
> "bungy" wrote:
> > Hello. it would be great if someone could help me.
> >
> > I have a large database (18GB) which is being backed up on the Monday
> > of every week. Transactions logs are taken every 15mins during the day
> > and then a diff at the end of the day. My question is this, if a take
> > a differential at the end of the day can i still restore the
> > transaction logs from that day after restoring the full backup? I can
> > restore the full and differentials then the logs fine but when i try
> > and restore say the full and the transactions it complains that there
> > is a previous log which there isnt.
> >
> > Any help would be great at this point.
> >
> >
I have a large database (18GB) which is being backed up on the Monday
of every week. Transactions logs are taken every 15mins during the day
and then a diff at the end of the day. My question is this, if a take
a differential at the end of the day can i still restore the
transaction logs from that day after restoring the full backup? I can
restore the full and differentials then the logs fine but when i try
and restore say the full and the transactions it complains that there
is a previous log which there isnt.
Any help would be great at this point.Try out once again. I have gone thorugh lot of transaction log loads, it
didnt caused me any trouble. I faced the same issue when we transfer it to DR
server, sometimes FTP fail so manually copies it and go for log load which
works fine. Can you post the Error you getting, in that there will be
timestamp saying till what time load happend.
--
Thanks,
Sree
[Please specify the version of Sql Server as we can save one thread and time
asking back if its 2000 or 2005]
"bungy" wrote:
> Hello. it would be great if someone could help me.
> I have a large database (18GB) which is being backed up on the Monday
> of every week. Transactions logs are taken every 15mins during the day
> and then a diff at the end of the day. My question is this, if a take
> a differential at the end of the day can i still restore the
> transaction logs from that day after restoring the full backup? I can
> restore the full and differentials then the logs fine but when i try
> and restore say the full and the transactions it complains that there
> is a previous log which there isnt.
> Any help would be great at this point.
>|||Thanks for the help but I found out what the problem was. zip extract
script that was extracting the files wasnt working correctly and the
sproc that is doing the restore wasnt right. Its hard if you didnt
write the bloody thing yourself.
Many thanks,
Sreejith G wrote:
> Try out once again. I have gone thorugh lot of transaction log loads, it
> didnt caused me any trouble. I faced the same issue when we transfer it to DR
> server, sometimes FTP fail so manually copies it and go for log load which
> works fine. Can you post the Error you getting, in that there will be
> timestamp saying till what time load happend.
> --
> Thanks,
> Sree
> [Please specify the version of Sql Server as we can save one thread and time
> asking back if its 2000 or 2005]
>
> "bungy" wrote:
> > Hello. it would be great if someone could help me.
> >
> > I have a large database (18GB) which is being backed up on the Monday
> > of every week. Transactions logs are taken every 15mins during the day
> > and then a diff at the end of the day. My question is this, if a take
> > a differential at the end of the day can i still restore the
> > transaction logs from that day after restoring the full backup? I can
> > restore the full and differentials then the logs fine but when i try
> > and restore say the full and the transactions it complains that there
> > is a previous log which there isnt.
> >
> > Any help would be great at this point.
> >
> >
Labels:
18gb,
backed,
backups,
database,
differential,
logs,
microsoft,
mysql,
oracle,
server,
sql,
transaction,
transactions
Wednesday, March 7, 2012
different sort order id
When I am trying to restore a database, getting an error
message which says "database attempting to restore was
backed up under different sort order id than the one
currently running and atleast one of them is a non-binary
sort order. Operation terminating abnormally."
How I can I rectify this problem ?I'm guessing this is happening under SQL 7.0. On SQL 7.0 you can only
restore backups that contain the same sort order as the server in which you
are trying to restore to. Basically SQL 7.0 supports only a single sort
order for the server. But SQL 2000 does not have this limitation. In SQL
2000 you have server, database even column level sort orders, so you should
be able to restore your database backup to a 2000 server.
You might consider using DTS to move the data from the source server to your
new target server that has a different sort order then your source server.
--
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Jagdish" <jnasit_x@.hss.hns.com> wrote in message
news:692701c42ea5$8b364e10$a101280a@.phx.gbl...
> When I am trying to restore a database, getting an error
> message which says "database attempting to restore was
> backed up under different sort order id than the one
> currently running and atleast one of them is a non-binary
> sort order. Operation terminating abnormally."
> How I can I rectify this problem ?
>
message which says "database attempting to restore was
backed up under different sort order id than the one
currently running and atleast one of them is a non-binary
sort order. Operation terminating abnormally."
How I can I rectify this problem ?I'm guessing this is happening under SQL 7.0. On SQL 7.0 you can only
restore backups that contain the same sort order as the server in which you
are trying to restore to. Basically SQL 7.0 supports only a single sort
order for the server. But SQL 2000 does not have this limitation. In SQL
2000 you have server, database even column level sort orders, so you should
be able to restore your database backup to a 2000 server.
You might consider using DTS to move the data from the source server to your
new target server that has a different sort order then your source server.
--
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Jagdish" <jnasit_x@.hss.hns.com> wrote in message
news:692701c42ea5$8b364e10$a101280a@.phx.gbl...
> When I am trying to restore a database, getting an error
> message which says "database attempting to restore was
> backed up under different sort order id than the one
> currently running and atleast one of them is a non-binary
> sort order. Operation terminating abnormally."
> How I can I rectify this problem ?
>
Subscribe to:
Posts (Atom)