Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
derreckdean
Starting Member
3 Posts |
 Posted - 2009-07-10 : 15:50:40
|
| Hi All,I have a 26MB database that used to contain tables and SProcs and more, which after a reformat of the server attaches successfully, but contains no tables, SProcs, or other data.Some backstory: I have an SQL server 2008 database that I upgraded from sql 2005 not too long ago. One of the Windows Updates borked my registry permissions on CLSID and I had to reformat the machine. I booted from a Ubuntu 9.04 CD and copied all of the databases and files from that machine onto a USB flash drive, and reformatted the server, since I wasn't sure of the problem at that time. It could have been a virus for all I knew... once I had the same issue on my laptop, I knew how to fix it and then wished I had never reformatted.I reinstalled Windows 2003 Server on the box, reinstalled all my programs (VS2008, SQL2008, etc). I attached all 5 of my databases on this server. All of the databases save the one in question work fine - all data and procedures are intact. The "truncated" DB's file size is 26MB, and its log is 3MB. Running a DBCC CHECKDB returns no problems. Selecting all tables using SELECT * FROM sys.tables returns no records. There are no SPs, built-in or not.I don't care about the data in this table as much as the functions, SPs, table structures and indexes. Am I screwed, or can some of this information be retrieved?No, I didn't make backups *facepalm*- Derreck |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2009-07-10 : 16:46:32
|
| if checkdb returns no errors of anykind it looks like you're screwed.does select * from INFORMATION_SCHEMA.ROUTINESreturn anything?although i have to wonder how come there's no system sprocs and checkdb still returns ok.___________________________________________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.5 out! |
 |
|
|
derreckdean
Starting Member
3 Posts |
Posted - 2009-07-10 : 17:05:52
|
quote:
Originally posted by spirit1select * from INFORMATION_SCHEMA.ROUTINES
No rows returned. |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2009-07-10 : 17:12:37
|
| then you're screwed.___________________________________________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.5 out! |
|
|
|
derreckdean
Starting Member
3 Posts |
Posted - 2009-07-10 : 17:15:47
|
| That's what I figured. Thanks for your help and time! |
|
|
|
|
|
|
|
|
SQL Server 2008 DB truncated?