Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Restored Data Not Up to Date 1

Status
Not open for further replies.

kldomino

IS-IT--Management
Sep 23, 2002
11
US
I had a corrupted SCSI controller card which corrupted both my boot drive and my raid array. I had to restore the boot drive OS/registry to a February vintage (don't ask), but my SQL data files were up to date through last week.

After the SQL restore (of both data nad registry, in which I did specify to force overwrite of the database in the backup agent, my data only appears to be through the end of January. Is there some inter-relation between the system files and the data files that I am not aware of, that would prevent current data files from being fully seen??? I am on SQL 7 on a Windows 2000 server.

Please help if you can....

Thank you,
Kelly :)
 
Nope.
sql server databases are self contained.

Maybe you have rstored an old backup or maybe the user doesn't have permissions to see new objects.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
 
Thanks Nigelrivett.

It appears that even with refreshing the links using the linked table manager, that some of my data is permanently gone. Apparently, it was stored in the local access mdb we use to manipulate the SQL data....
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top