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!

Database there but not there

Status
Not open for further replies.

Waynest

Programmer
Jun 22, 2000
321
GB
We messed up on our development machine recently and had to uninstall then re-install sql server 7.0.&nbsp;&nbsp;The databases we were using are still physically there on the disk (we can see the .mdf & .ldf files) but we cant access them thru sql server.&nbsp;&nbsp;We can restore backups from tape but being programmer types we havent got backups for a couple of them.<br><br>How do I get the info in the files back into sql server? Agh!<br>&nbsp;<br>&nbsp;<br>
 
Try the stored procedures:<br><br><font color=blue>sp_attach_db </font><br>or<br><font color=blue>sp_attach_single_file_db </font><br><br>and see if they do the trick. <p>Robert Bradley<br><a href=mailto: > </a><br><a href= - Visual FoxPro Development</a><br>
 
Robert<br><br>sp_attach_db did the biz.&nbsp;&nbsp;thanks man.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top