| Author |
Topic |
|
rtutus
Aged Yak Warrior
522 Posts |
 Posted - 2005-11-13 : 02:07:38
|
| I had a production database called matrice withing my local sql server. After re-installimng SQL server, I can t find my atabase anymore, SQL server manager displays only the default databases that are installed the first time with it (matser, model, msdb....tempdb) |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-11-13 : 08:13:26
|
search your drive (where you had stored the db) for matrice.mdf.if it doesn't find it then i hope you have a backup because if not you've lost it.always backup your db's before reinstalling the server.Go with the flow & have fun! Else fight the flow  |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-11-13 : 10:07:03
|
| You won't have lost the database it's just not attached.You can attach the files using enterprise manager or sp_attach_db.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
rtutus
Aged Yak Warrior
522 Posts |
Posted - 2005-11-13 : 14:16:08
|
| I could not find it (matrice.mdf) in the whole hard drive, I find it weired that if we reinstall sql server we lose our database. i appreciate any other suggestions. (that d be bad in real business case, losing data)Thanks folks |
|
|
|
coolerbob
Aged Yak Warrior
841 Posts |
Posted - 2005-11-13 : 14:35:52
|
| the sql install has not caused you to lose your db.the file might not be called matrice.mdf; it could be matrice_data.mdf or any number of namesyou should know where it use to be on the drivemaybe try searching for %matrice% |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-11-13 : 14:41:31
|
| search for .mdf==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-11-14 : 22:23:43
|
"maybe try searching for %matrice%"Hehehe ... I wish!I think he needs to search for files *matrice*.* "I find it weired that if we reinstall sql server we lose our database"I expect the file is still there, but I'm not sure what you expect a reinstall of SQL Server to do - other that revert to the "factory default"?Kristen |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-11-14 : 22:24:54
|
| Silly question. Did you also install a new OS? And, is it safe to assume this is the same server as before?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
rtutus
Aged Yak Warrior
522 Posts |
Posted - 2005-11-16 : 11:02:50
|
| I looked for %matrice% and matrice.* and matrix_Data.mdf, but no luck. I had not reinstalled the OS, reinstalled just SQL server. yes it s the same computer that i m using; my own computer Windows XP; may be i changed the login that I used, now i m using a different one, do u think that might be the problem?Take care guys |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-11-16 : 11:18:31
|
| do you know in which directory the db was in before you reinstalled?Go with the flow & have fun! Else fight the flow |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-11-16 : 15:46:54
|
| "I looked for %matrice% and matrice.* and matrix_Data.mdf, but no luck"Is the database matrice or matrix ??As I said before you need to search for*matrice*.*and even that is not guaranteed as there is nothing that says that the names of the files for a database nee to match the database nae itself. So searching for *.MDF is also worthwhile, as Nigel said.Kristen |
|
|
|
rtutus
Aged Yak Warrior
522 Posts |
Posted - 2005-11-17 : 13:09:52
|
| Sorry I meant matrice_data.mdf Never mind guys, I ll just rebuild the database again, fortunaetly i m doing it at home, if that were at work that d be badThanks guys |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-11-17 : 13:13:26
|
| " if that were at work that d be bad"Either way, you ought to attend to getting it backed up regularly ...Kristen |
|
|
|
|
I lost my database after reinstalling SQL server