Error when restoring tables

[Pederico Wallens]

Hi !!

I have this problem when I dumped 10 tables to a new-created-dump device.

I dropped the tables and recreated it with the same layout as before.

When i try to load the tables again eith the command "load table from dumdevice" the first table works fine but the second table gets the error message:

"Schema differs between source table......."
Where the source table according to the eroor message is the first table that
I sucessfully loaded though I didn`t mentioned it in the command.

What can I do, Am I not allowed to dump several tables to the same dumpdevice !!!

Please Help

Pederico

[Jasper]

On 8/20/98 7:51:11 AM, Pederico Wallens wrote:
>"Schema differs between source table......."

I too have had similiar problems with restoration. I made a backup of a table and then tried to restore at a later date. Same error!?!

I even made a backup and an immediate restore. Still no luck. But all it not lost. If you have made a complete database backup, you should be in luck.

I was able to restore the tables by restoring the complete database, which I might add was a lot faster. Less than 1 hour for 10G database.

I consulted with a SQL Server `expert` and he said that he had never encountered th problem, it may be due to a Serice Pack installed.

So I suggest restoring the complete database, if possible. I also suggest making complete backups, rather than single table. Mainly becuase of the unreliability of the `table` backups, but also because when restoring a single table the indexes are droppped and recreated. One table we had took about 8 hours to restore. - the complete Database (containing that table), only took about 1 hour.

Good luck

Jasper

[TZ]

SELECT * FROM T1
ORDER BY F1 ASC

and

SELECT * FROM T1
ORDER BY F1 DESC

I want merge these 2 SQL with specify ASC/DESC dynamically,
How can I do it?
It seems CASE function doesn't work in this case

[carol]

not sure under what situation you are calling this select statement...
a case statement will work if you do it this way:

declare @sort varchar(10)

select @sort = 'asc'

if @sort = 'asc'
select * from offer order by description asc
else
select * from offer order by description desc


------------
TZ at 3/1/2002 10:43:16 AM


SELECT * FROM T1
ORDER BY F1 ASC

and

SELECT * FROM T1
ORDER BY F1 DESC

I want merge these 2 SQL with specify ASC/DESC dynamically,
How can I do it?
It seems CASE function doesn't work in this case