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 |
|
CJVal
Starting Member
1 Post |
 Posted - 2008-03-11 : 18:55:06
|
| Hi All, not sure if this is the correct spot, and I aplogise for the newbieness of the question. But I was after some feedback.Ok this is a bit of a doozy for me. Work related question, I have been tasked with sorting out this issue at work, but don't really have much background in this field, but theres no one else in my team that can do it. Bit of a background on the problem.At work we have a server and a client machine, They are both running on Windows Server 2000. They both have on them proprietry software for the client which uses MSSQL. Late last year the client machines hard drive failed. We rebuilt it with a new hard drive from a back up machine.Now I had managed to get the client machine talking to the server, and the propriety software can communicate somewhat. The program involves starting sessions and collection of information which is put into the SQL database. Both machines do this fine and can see current sessions.Now I have the following problems. I cannot generate reports from the client machine or edit any database files. However the server does this fine.Now I've done a bit of investigating, the MDF file for the Server machine updates everytime the server or program is shutdown. The same with the LDF Log file, however on the client machine Both these files have last modified dates from 2004.Now comes the stupid part. If I copy these files from the server machine onto the client machine, thereby overwriting them, would this potentially fix the issue? Or will this make this issue worse.?Currently if I try and export information from the client machine I get a jet database error 3078 followed by an SQL statement basically telling me that it cant find the information, even though the proprietry software can see that the session is there. If I try the same procedure on the server machine it exports the data fine. All the exporting of data is to an access file which can be read, and the exporting itself is done in the proprietry software.Hope this hasn't confused you all? I just dont want to turn the client machine into a burning heap. I have done a full backup of the machine in preparation of trying the procedure, just after some advice.I'm not entirely comfortable doing this hence my question here.Edit: Ok, i've done a bit of reading, and I take it my problem may be fixed by attaching the database in Mssql Enterprise manager? Would I do this from the client machine or the server machine, as the server machine has the functioning database. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-11 : 23:27:08
|
| Is sql service running on client machine? |
 |
|
|
|
|
|
|
|
MS SQL export/reading issue