|
Why cant you just use one database server?
|
|
|
|
|
The Customer wants each Machine (Tester) to have its own Database (Unique and Resident) as well as having either all the other Platforms contain each others Data recors and Updates or one designated Supervisor Server with all the other Servers updating their individual changes to it.
Regards
BC
|
|
|
|
|
As long as all the information from the Local Server or PC is available to the Local User (Operator) and the Supervisor Dedicated PC Database contains all the Locals Information and Changes and Updates it really doesn't matter. As long as it is completely FREE and no Licenses are required I am FREE to do any Suggested Configuration. As long as each Machine (Tester) can get it Own Database Information from It's PC and Anyone on the Supervisor PC or on the Same Network can get it as well or Log into the Supervisor and retrieve it for FREE its all good.
Regards
BC
|
|
|
|
|
It is always a difficult situation when a user places technical demands on a solution. I don't see why each machine would need it's own instance of SQL. The whole idea behind SQL Server is that there is 1 machine that is responsible for housing the data and making it available to many people. Have you considered how you are going to back all of these databases up? How are you going to ensure that the backups are consistent among all of the computers? How are you going to handle the situation where one or more computers are not on when an update is made ? Are you going to queue up the changes made and when these computers come online, process the pending transactions ? Ugh. This is way too complicated for what seems to be a small office configuration.
This proposed implementation has "problem" written all over it. Convince your client that 1 machine with a proper SQL engine is the way to go. If they don't want to spend money on SQL Server, how about mySql ? I've never used mySql, but it might be a lower cost solution.
You really need to go with a single server configuration.
whew, I'm done with my rant now  Time for me to switch to decaf.
|
|
|
|
|
The Customer Specified and Suggested this configuration. I do not have to do it that way as long as is completely free and NoLicenses are requires. The end user must have the ability to retrieve data from the LocalDatabase at any time. The Database must be updated locally after each use or run and must all be available globally to the other 11 local machines (tester) or a master or supervisor machine (Tester) MASTER1 which is updated with all the other 11 localMachines (Testers) as well as its own local data. All records must be updated after each Machine (Tester) Cycle or the Next time that the machine (tester) is turned on it needs to update accordingly. Backups will be done locally on each machine at some specified frequency defined by the customer. Each machine has its own Unique Results and 1 Master or allMust have the others information avalaible to them to Query. I have the Database Created in MS Access for the first machine Tester) but the Customer will not accept it because it Requires Office or Licensing to be installed on 12 PC Platforms. SQL Server Express 208 willnot allow you to import a Database from MS Access and Save it as a SQLServer Express 2008 Database. Hope you can help.
Regards
BC
|
|
|
|
|
Anyone know of potential problems with using a SQL Server 2000 db with a .NET 2.0/3.5 site?
|
|
|
|
|
The two have nothing to do with each other, so, no...
|
|
|
|
|
want to know how can I schedule a task in SQL Express 2005 to backup the database on daily basis to a folder in a network drive like this:
\\192.9.100.2\backup.sql\backup.bak
I want an incremental backup to be performed daily but full backup to be performed monthly.
|
|
|
|
|
Don't repost. If you you want to change your post, simply hit Edit link on the bottom right corner of the post.
|
|
|
|
|
I want to know how can I schedule a task in SQL Express 2005 to backup the database on daily basis to a folder in a network drive like this:
\\192.9.100.2\backup.sql\backup.bak
I want an incremental backup to be performed daily but full backup to be performed monthly.
|
|
|
|
|
|
what about creating a stored procedure then use windows schedule task to execute the procedure?
|
|
|
|
|
That would work also. Just create the procedure and schedule a batch job which will use sqlcmd and execute the procedure. There's a bit more work since you need to take care of logging, alarming etc. but it's not complicated.
|
|
|
|
|
Hello,
I store a lot of data in a table. An ordered subset of these data are to be displayed on a remote application. In order to minimize the network load and display latency I'd like to retrieve only the row that are really displayed. The remote application will request additional rows when the user scroll.
First I though I could use views and cursor to achieve this. It works well except when I need to display data add after the view creation. In this case I have to recreate the view which is quite long.
I'm connected through ODBC to SQL Server or MySQL. Is there an ODBC way to retrieve result set rows on demand (I don't want all the rows to be retrieved by the ODBC driver) ? So maybe I could use a simple SELECT request and get only the rows I need (assuming the SELECT will be fast enough).
Thanks
|
|
|
|
|
You could look at SQLFetchScroll[^].
The downside is that the cursor must be open all the time, which can lead to several problems. If you want to close the cursor between calls then you have ty dynamically modify the sql statement so that you define new "offset" every time.
|
|
|
|
|
What is the possible problems caused by keeping the cursor open all the time ?
By "offset" do you mean I need to memorize the last position and use it again the next call as a "bookmark" for the SQLFetchScroll method ?
|
|
|
|
|
20c wrote: What is the possible problems caused by keeping the cursor open all the time
Some issues that come immediately to my mind:
- the connection to the db must be open all the time so it's vulnerable to any possible network failures or degraded performance may cause timeouts thus closing the connection (don't know your environment so this may not be an issue for you)
- When you hold the cursor open you use several resources on the database side since the database must hold the result set for you.
- possible locking problems if the query holds S-locks, also degraded performance for the same reason
20c wrote: By "offset" do you mean I need to memorize the last position and use it again the next call as a "bookmark" for the SQLFetchScroll method
Not actually the position as a row, since it may vary between calls. For example:
- you have 100 customers ordered by name
- you fetch in pages of 10 rows- you're on page 50-59
- the next page would be customers 60-69.
But what happens if let's say 20 customers have been added and they all start with letter A? If you remember the row position you would actually get the previous page where you've already been if you go forward.
What I meant is that you remember for example the key and the values in the ordering columns. If the customer has for example CustomerID as a primary key, next time when fetching you would query for customers in the same order but only rows starting the last customer you fetched previously.
|
|
|
|
|
Hi All,
I have VS2008 professional edition, I want to add a connection to SQL server compact edition, but in the Server explorer, in Data Sources, I don't see Sql Server Compact edition. Is there any VS2008 Setting I have to change?
With VS2008 Express edition, everything is working fine, I could able to access .sdf files.
I know that with VS2008, SSCE is shipped and available right away, but it is not working with me.
Thanks in advance for your help,
Veena
|
|
|
|
|
Did you add the local database (from Add/New Item...) into your project? After that it should automatically be listed in the server explorer.
|
|
|
|
|
Thanks Mika,
I added local database into my project. I got following warning
"The data provider required to connect to the local data file could not be found. The file will be added to the project but the typed DataSet associated with the file will not be generated."
I checked in server explorer, no SSCE is listed. When I tried to access the newly added .sdf local database, I got an error "Operation could not be completed. Unspecified error.". This is the case in VS2008 professional edition.
For VS2008 express edition , everything is working fine.
Veena
|
|
|
|
|
Sounds like you have an installation issue. SqlCe library isn't installed for some reason.
Visit: SQL Server Compact 3.5[^] and download the latest version and try to install that. Hope it helps.
|
|
|
|
|
hellow can any one help me in getting week number (sunday - sunday) as week in sql server query.
i am using this but its not giving as sunday to sunday
SELECT StartTime,DATEPART(DAY, StartTime - 1) / 7 + 1 AS theWeekWithinMonth from TT where cardid = '3344'
|
|
|
|
|
Do you mean week numbers as 1-52 (or 53). In that case try:
SELECT DATEPART(WEEK, StartTime)...
If you mean day numbers 1-7 starting from sunday try:
SELECT DATEPART(WEEKDAY, StartTime)...
modified on Thursday, January 8, 2009 7:55 AM
|
|
|
|
|
Kindly help me out.performance of my sql server degrades after power failure.
i ran dbcc checkdb command , but it shows no error.
|
|
|
|
|
This could be a normal situation. When the SQL Server is shut down, it's memory manager is destroyed so there are no more block in the buffer. It takes some time for the database to gather a good mru list of necessary buffers. So basically before the power failure many operations were done in-memory, but now the data must be fetched from the disk. Also what takes time is that if your memory settings are dynamic, SQL Server must increase memory usage as needed. Just make sure that the operating system isn't swapping.
You can use performance manager to monitor if this is the case (since you're not facing any errors). You can also use activity monitor to see if this is disk I/O related.
Also check that there are no problems in errorlog.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
