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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Microsoft Sql 2000

Author  Topic 

cmwil
Starting Member

5 Posts

Posted - 2008-10-31 : 11:20:13
My hard drive failed but I have recovered my database files.How can I import my old database into a new database

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2008-10-31 : 11:21:54
What do you have ?

A backup or detached db ?
Go to Top of Page

cmwil
Starting Member

5 Posts

Posted - 2008-10-31 : 11:24:54
I do not have a bckup only all the files from the database in folders.
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-10-31 : 11:28:18
Try to attach the files .
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-10-31 : 11:28:52
And run CheckDB to make sure there is no consistency errors.
Go to Top of Page

cmwil
Starting Member

5 Posts

Posted - 2008-10-31 : 11:54:55
I am totally new to this, I am really trying to help some one out, which files do I need to paste to the new databse.
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-10-31 : 11:58:21
http://msdn.microsoft.com/en-us/library/aa259611(SQL.80).aspx
Go to Top of Page
   

- Advertisement -