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!

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

Deleted linked server... Files missing or not registered!

Status
Not open for further replies.
perfectchaoss

perfectchaoss

Programmer
Nov 6, 2002
44
US
Hi,
I have a SQL server that I was trying to link to another SQL server. When I Removed the link I can no longer view any tables or views! I get a message that there are files missing or not registered. Has this ever happened to anyone else before? The data files and transaction logs are still the same size, The database is backed up to an acceptable time and date I am just wondering if there is an easier way to get my tables back than restoring.

Thanks,
JF
 
Status
Not open for further replies.

Similar threads

V
  • Locked
  • Question
xp_cmdshell vs psexec - this SQL server forgets credential to an W10 share
Replies
0
Views
358
Volvere
V
BeatriceC
  • Locked
  • Question
SQL Linked server StoredProcefure job creates temp files
Replies
1
Views
96
pjw001
pjw001
Colin Burton
  • Locked
  • Question
Determine if a file exists on s different server to the SQL Server 1
Replies
2
Views
406
gmmastros
gmmastros
ahmedsa2018
  • Locked
  • Question
How to give same number if it exist on table or new number if it not exist based on part value? 1
Replies
8
Views
153
Andrzejek
Andrzejek
Cpreston
  • Locked
  • Question
Converting or getting rid of decimal places 1
Replies
5
Views
160
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top