| Author |
Topic |
|
aberbotimue
Starting Member
26 Posts |
 Posted - 2010-08-13 : 15:28:56
|
| Hi all..I seem to have got in a pickle!I have a sql server 2k DB.. it was running on a server with sql/os on disk one - the data files on disk 2 - backups on disk 3I lost disk 2. SQL noticed, and has maked the DB's as suspect. and rightly so, the data files are missing..I am wanting to recreate them onto disk 3, but It won't let me detach the existing DB's, etc.. and as such, the re attching is failing. I even tried to create a new db, and restore into that, but that failed..and now I am just flailing around, and not achieving anything..what is the quickest waty to get the database back working..I have backup files.I have sql server 2 k with the dbs in there, but can't detach them.I can alter the connection string for the software rto use a new DB name, but would need the backups to create thoses dbs for me.any help would be welcomed... its the weekend, and i want to go home! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
aberbotimue
Starting Member
26 Posts |
Posted - 2010-08-13 : 16:47:34
|
| Thanks for the reply..when i select delete I get this message.http://twitgoo.com/1hv5ecI will try the restore into another db agin, to get the meassage.. I just tried and i get another error, so will play, and repost when i get stuck again.. but even if I restore to a new DB, I will still need to get rid of the original DB's even tho their data is already awol. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
aberbotimue
Starting Member
26 Posts |
Posted - 2010-08-13 : 18:50:18
|
| I seem to have got the restore into a new db at least started, but considering the backup only ever takes 30 mins, the fact the restore has been going for over an hour now, i supect somthing is wrong..as part of the restore process, it did mention somthing about the old path of the old DB, which no longer exists.. i am not sure how to tell if its restoring or not, or if its died...I ran the SELECT * FROM master.sys.databasesbut its saying Invalid object.I ran somthing earlier, can't reall what it was, and the databases were all listed. the three that were moved to have their data on the other disk ( the disk thats died ), that are marked at suspect, were not in the list. yet they do seem to be in enterprise manager.I guess if this restore works, i'm not going to bne able to change the name to the old db, while it still exists in enterprise manager. |
|
|
|
aberbotimue
Starting Member
26 Posts |
Posted - 2010-08-13 : 19:01:18
|
| Although the restore is still going, it is working, and the disk space free is shrinking!! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
aberbotimue
Starting Member
26 Posts |
Posted - 2010-08-14 : 17:33:26
|
| The restore I started has worked.. into another DB.. It just took a LONG time, but there are over 6 Million records in there, so I guess thats fair!The DB is now running under a new name, and we altered the connection string in the App to point to the new DVB name.. new user, etc..which only leaves changing its name at sompoint to the old name, as thats what we all know and love!! The select * from master.dbo.sysdatabases does show the list not show the databases in the table, but they still exist in the local version of enterprise manager.. so i guess the next step is kill them off.. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
aberbotimue
Starting Member
26 Posts |
Posted - 2010-08-19 : 09:35:39
|
| after a reboot of the server they stopped showing. Thanks for that.. I assume its because I did try the delete, althouth it failed, it did remove the entry from the sysdatabases table.The full text index that died with the disk is a harder one to get rid of.. I have deleted it, and it failed, but also after rebooting, its still in the EM interface.. any words of wisdom, how to get rid of the broken full text catalog// |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
lost disks, have backups, sql confused