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 |
|
Banyardi
Starting Member
4 Posts |
 Posted - 2008-08-29 : 13:35:26
|
| I had a database that filled all the designated files in the data filegroup. I added four new empty files with to the filegroup to expand the database. I then made a mistake and ended up corrupting the last two files in the filegroup. These two corruptd files have no data so I want to eliminate them from the filegroup, but the database is in an off-line state because of the corruption. I detached the database, and tried to reattach it, but it says it can't find the two files that are corrupted.How can I modify the database to ignore these corrupt files, so that I can bring the database back online? Short of that, how can I rebuild the database from scratch and then import the existing data from the offline database?Any ideas on how to approach this problem would be appreciated.Brandon_Forest@sbcglobal.netSQL Server DBA |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2008-08-29 : 14:00:34
|
| Restore the database from the last full backup, and then apply the transaction log backups up to the point in time just before the problem occurred.CODO ERGO SUM |
 |
|
|
|
|
|
Recovering From Corrupted Filegroup Files