473,382 Members | 1,433 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,382 software developers and data experts.

MS SQL question

2
Hi All

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.
Mar 11 '08 #1
3 1163
ck9663
2,878 Expert 2GB
Hi All

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.
Answer this first: Do you have a copy of the same database? One on the server and one on the client?

Backup everything first, then answer the question and we go from there.

-- CK
Mar 11 '08 #2
CeJay
2
I've backed up the system, there is a copy of the mdb file on both the server and the client machine, they both have the same name and are the same size, along with the ldf files, the difference is the last modified dates, They should be linked therefore as they should reference the same data. The server is currently updating properly when you change something the client machine is

I've also a bit of reading, and I take it my problem may be fixed by attaching the database in Mssql Enterprise manager? As I may not have done this before when I rebuilt the other machine. Would I do this from the client machine or the server machine, as the server machine has the functioning database.
Mar 11 '08 #3
ck9663
2,878 Expert 2GB
If you're concerned with the last modified date as seen on windows explorer, it might not be what you thought it is. The db might be modified, but we don't know if the data were. Your third party apps could just be using the client database to be able to link to the server database. So the actual data update is already happening on your server. Every connection that's made or a temp table created on your db, it will be "modified" hence a new modified date. If your running your apps and it's automatically updating both server and client, you don't have a problem.

-- CK
Mar 12 '08 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Mohammed Mazid | last post by:
Can anyone please help me on how to move to the next and previous question? Here is a snippet of my code: Private Sub cmdNext_Click() End Sub Private Sub cmdPrevious_Click() showrecord
3
by: Stevey | last post by:
I have the following XML file... <?xml version="1.0"?> <animals> <animal> <name>Tiger</name> <questions> <question index="0">true</question> <question index="1">true</question> </questions>
7
by: nospam | last post by:
Ok, 3rd or is it the 4th time I have asked this question on Partial Types, so, since it seems to me that Partial Types is still in the design or development stages at Microsoft, I am going to ask...
3
by: Ekqvist Marko | last post by:
Hi, I have one Access database table including questions and answers. Now I need to give answer id automatically to questionID column. But I don't know how it is best (fastest) to do? table...
10
by: glenn | last post by:
I am use to programming in php and the way session and post vars are past from fields on one page through to the post page automatically where I can get to their values easily to write to a...
10
by: Rider | last post by:
Hi, simple(?) question about asp.net configuration.. I've installed ASP.NET 2.0 QuickStart Sample successfully. But, When I'm first start application the follow message shown. ========= Server...
53
by: Jeff | last post by:
In the function below, can size ever be 0 (zero)? char *clc_strdup(const char * CLC_RESTRICT s) { size_t size; char *p; clc_assert_not_null(clc_strdup, s); size = strlen(s) + 1;
56
by: spibou | last post by:
In the statement "a *= expression" is expression assumed to be parenthesized ? For example if I write "a *= b+c" is this the same as "a = a * (b+c)" or "a = a * b+c" ?
2
by: Allan Ebdrup | last post by:
Hi, I'm trying to render a Matrix question in my ASP.Net 2.0 page, A matrix question is a question where you have several options that can all be rated according to several possible ratings (from...
3
by: Zhang Weiwu | last post by:
Hello! I wrote this: ..required-question p:after { content: "*"; } Corresponding HTML: <div class="required-question"><p>Question Text</p><input /></div> <div...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.