I didn't drop the table

Hi, Andrea,
Thank you for your reply.
I didn't drop the table,and the records in the table seldom change.
Does it has anything to do with the weekly backup schedule? I remember I
once did something wrong and I had to restore the database.
Thanks for any relpy.
Long
hi,
Long wrote:
> Hi, Andrea,
> Thank you for your reply.
> I didn't drop the table,and the records in the table seldom change.
> Does it has anything to do with the weekly backup schedule? I
> remember I once did something wrong and I had to restore the database.
> Thanks for any relpy.
> Long
if you modified your database and data, restoring an older (unmodified)
version can produce such problems
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply