| Author |
Topic |
|
memarcie
Yak Posting Veteran
91 Posts |
 Posted - 2007-08-17 : 10:04:55
|
| we had some hardware issues earlier this week and I tried to move tempdb, i think it the middle of moving them the harware died. Now that we finally have replacement hardware, I see the tempdb.mdf, but not the templog.ldf and while mssqlserver starts, I can't use query manager to check what location that templog is at. When I try to start QM, I get a message cannot open user default database. Help please? Thanks,Marcie |
|
|
JoeNak
Constraint Violating Yak Guru
292 Posts |
Posted - 2007-08-17 : 10:52:13
|
| Use query analyzer.Use tempdbGoSelect * From sysfiles |
 |
|
|
JoeNak
Constraint Violating Yak Guru
292 Posts |
Posted - 2007-08-17 : 10:56:18
|
| Have you checked that login's default database and the login's permissions.Doesn't sound like an issue with tempdb. Tempdb is recreated every time sql server is started, so missing files will be recreated. |
|
|
|
memarcie
Yak Posting Veteran
91 Posts |
Posted - 2007-08-17 : 11:05:05
|
| I can connect to query analyzer now and I verified the locations of tempdb and templog and they are correct. Why don't I see the templog in the location listed? I cannot connect to EM or see/use any other databases besides master. Any other suggestions? |
|
|
|
memarcie
Yak Posting Veteran
91 Posts |
Posted - 2007-08-17 : 11:06:20
|
| And yes, I know the permissions are right, that was all working fine before the hardware failure on the sql server box. |
|
|
|
JoeNak
Constraint Violating Yak Guru
292 Posts |
Posted - 2007-08-17 : 11:12:54
|
| Any chance that hardware failure impacted any of your databases (ie master)? |
|
|
|
memarcie
Yak Posting Veteran
91 Posts |
Posted - 2007-08-17 : 11:20:06
|
| very possible. I can use master and change the location of tempdb via query analyzer, is there something else I should check in master? I can see correct locations listed for all of my other databases. |
|
|
|
memarcie
Yak Posting Veteran
91 Posts |
Posted - 2007-08-17 : 11:22:47
|
| I mean how do I know if there is something wrong with master? |
|
|
|
memarcie
Yak Posting Veteran
91 Posts |
Posted - 2007-08-17 : 12:57:31
|
| I'm going no where fast with this. I thought maybe they databases weren't attached any longer, tried that and they already exist. I really need to get this figured out by Monday, guess I'll be working over the weekend. |
|
|
|
JoeNak
Constraint Violating Yak Guru
292 Posts |
Posted - 2007-08-17 : 13:55:17
|
| If the other databases are present and accessible, then master is probably ok. You could check the sql log or run DBCC CHECKDB on master.Have you tried another login? Have you verified the privileges with the login you are using? |
|
|
|
memarcie
Yak Posting Veteran
91 Posts |
Posted - 2007-08-17 : 14:25:03
|
| I'm not sure why, but it did come up eventually. I don't know if there was a big delay for running sql server the first time and restoing the databases on the new machine, but it appears to be ok now? I'm stumped, but it works now. Thanks for your help. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-18 : 00:51:31
|
| If system dbs go wrong, you can't start sql service. |
|
|
|
|
I think my templog file is missing