I'm running a SQL 7 db on a LAN in city A with other users accessing it from
another city (city B) over a WAN. Obviously the WAN users are getting much
slower access to the data. One thing I was wondering was if it was possible
to have two versions of the database, one on each server, and have them
automatically synchronize as users at each location make changes. Or, if
that's not possible, then at least have the city B users get any changes
that the city A users get as they are made.
I have a question about synchronizing databases. Let's say that I have 2 SQL Server 7 databases on 2 different computers running SQL Server 7.
The databases contain various related tables and are used to mange subscribers, contactpersonell and other data. In the databses subscribers are added, deleted and updated frequently so my problem is to keep the 2 databses that are located on different computers synchronized. If a subscriber is deleted on one computer, then it should be deleted in the other database too etc. These subscribers are identified by a subscriberID.
Is it possible in some (easy) way to do this synchronization?
And how should I specifiy where the databases are located so that my stored procedure (or whatever does this) knows where the databases and tables are located? I mean, if the databases are located for example in 2 different cities.
I have two server A & B and I have always on high availability turned on SQL14.
I need to shrink the log on server A and it's fine if it also needs to shrink B.
My problem is that when I run my shrink command I get:
"cannot be shrunk until all secondaries have moved past the point where the log was added.."
I think I need to drop the High availability on the servers and then run this:
USE iTest2_Claims; GO ALTER DATABASE iTest2_Claims SET RECOVERY SIMPLE; GO DBCC SHRINKFILE (iTest2_Claims_Log, 10); GO ALTER DATABASE iTest2_Claims SET RECOVERY FULL; GO
If the only way to shrink my log file is to drop high availibity how do I do that in script? and how risky is it that the high availaibity will not re-connect?
We have a situation that requires converting all INT columns from source database to BIGINT in destination.
By ‘copying’ term, I consider any operation like insert-select, merge, asynchronous replication or any other that will get all data synchronized until some moment in time, i.e. 2015-12-31 10:00 PST when downtime is planned. Before that moment it isn’t important if data in source and destination DB are in sync.
Copying process starts early enough to allow appliance of any technique/technology – there’s enough time to find best solution.
Requirements:
1. Destination database is superset of source, having all tables and all columns plus few more columns in few tables. Additional columns have default NULL or they are computed. INT columns in source are BIGINT in destination.
2. If source and destination are not in sync at the moment downtime begins, it is allowed to have few minutes to wait for synchronization. For instance, if transaction logs from last hour or so need to be shipped, that would be ok. If large table need to be synchronized by comparing row-by-row, it’s not ok.
3. Source database performance must not be compromised by any copying if it’s done before scheduled downtime. There are couple of options I have in mind involving MERGE command but its appliance might be limited by current DB design. Additionally, based on business logic, I cannot be absolutely sure if some row, created while ago, wasn’t changed meanwhile.
For some large tables, there is no indicator at all when any row has changed – I cannot rely on IDs nor there is column like ‘[date last changed] DATETIME’
I have been reading about various kinds of replication, i.e. log shipping but I’m not clear if any of these is applicable. Key points, if there is replication involved, are copying process must start from empty destination database plus synchronization must not compromise source DB performance So, how to do this using any kind of replication?
So in a previous thread I discovered that in order to actually subscribe to any publication, the publisher needs to be a well-known network name, requiring DNS resolution. You can't simply point a SQLExpress instance at an ip addressinstance and have it resolve the communications.
SQL Express 2005 with one instance on a networked dedicated stand-alone window XP€¦ We use this for custom software written in VB.net. We are not SQL experts€¦ Question 1) I am getting a event viewer warning that says The time stamp counter of CPU on scheduler id 1 is not synchronized with other CPUs. This seems strange, since there is only one CPU on this machine. Any ideas? Question 2) In SQL Server Management Studio Express, we do not have the actual data files attached to the instance, but the custom program does use the actual data files just fine, defined by the connection string. Is there any pro/con to having them attached in SQL Server Management Studio Express? Thanks! Bob
I wonder how do I shrink log file in a specific database which in Mirror/Synchronized/Restoring state..So that database is in Mirror server ( High availability ).
We are in need of a solution to our problem. We are working for a customer and cannot use their database to work on during development. We have copied the layout and made a sample db for our development. Rather than writing down all the changes we make to our own db and then making the same changes to the customer's, is there a better way? Can we use something like sourcesafe? Thankyou
I've got a few SQL Servers at work which are development servers using SQL Server Standard Edition. I would like to downgrade them to SQL Server Developer Edition to save the Standard Edition licenses for production purposes. However, i do not wish to uninstall and reinstall SQL Server Developer Edition, restore all the dbs. Is there a way to change the version of the SQL Server ?
Hi All, Can we have 2 versions of SQL Server on the same server? Example, can I install SQL Server 2000 and 2005 on the same server? Please let me know about all the combinations possible/not possible.
Is there a way to do the following -- I need to be able to update a table based on a selection by a DDL. So here are my two update queries: 1. Update RequestData Set Approved = True Where DeptID = @DeptID2. Update RequestData Set Approved = True (Yes I need to be able to do all of the rows at once.) But it's all based on the selection of the DDL---I really don't want to have to create two seperate sql commands any ideas?
Is there a way to remove old versions of a DTS package without rewriting the entire package? These packages run fine but take up more space than I am willing to allocate.
I understand the SANs are only Supported by SQL Server 2000 Enterprise and no other versions of SQL, can anyone supply information to the contrary please?
This may seem like a wierd question, but can I have 6.5 and 7.0 running on the same machine? I need 6.5 for production builds and 7.0 for test. Is this possible? THanks
I can see that SQL server 2000 trial is available for download, but I need to try out 7 for a particular project at work. Is this available for trial download? (Has it ever been?)
Hi all... I'm a MySQL user and I want to switch to MS SQL Server, I heared that there is more than one type of MS SQL Server and one or two can be downloaded for free. Can someone tell me the different types of MS SQL Server and where can I download those free versions?
Is it possible to run both SQL200 standard and SQL2005 Express on thesame server? I need to test a database created in 2005 on ourproduction server but don't want to upgrade our "live" databases yet.
I uninstalled the 32-bit Standard version but during install of the 64-bit trial version I got an error that the integration services could not install because the 32-bit version of COM+ was already registered and you can't have both. Need some help how to resolve this issue. Thanks
I have a server with sql 2000 and 2005 installed on it. When I try to connect to the msde 2000 database with an app or with managment studio express I get the following error
"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476"
But When I go through dos and type osql -S(local)database -E it connects to the correct msde instance. How can I fix this with out uninstalling sql server 2005????
We will be upgrading from SQL 2000 to SQL 2005. From what I have read, as part of the installation of SQL 2005 we will be installing the .Net framework 2.0 and Visual Studio 2005. We currently have production .Net applications which were developed in Visual Studio 2003 with the .Net framework 1.1. We plan at some point to upgrade our applications to Visual Basic 2005, but we were planning on upgrading to SQL 2005 first. I have a couple of questions about this.
1) We are a small shop and the same server which hosts our production applications also hosts SQL server for our model office and test applications. Can we have both versions of the common language runtime running on the same server?
2) Our .Net applications access the SQL data through stored procedures or views. I have run the Upgrade Advisor and it does not look as though there are any signficant upgrade issues with our SQL database objects, so we are tentatively planning on changing the compatibility levels of our databases to 90 after they are imported to SQL 2005. Assuming we take care of any SQL issues that we do have with our database objects, should we expect to encounter problems running our existing applications, under the older version of vb.net, and accessing our databases once we have upgraded to SQL 2005? (Of course we plan to test everything, but I just wanted to know if we should anticipate anything in particular.)
Hi If i develop a web application with sql server developement edition, it works fine in my webserver, or my webserver has to have the sql server development too? I'm interested in sql server report services. if i develop a web application with this tool what kind of version of sql server has to be installed in my webserver? Thank you
I have a DTS Package created with SQL2000 client tools, which contains a SQL connection and a sql task (exec sp_who2). When I run the package on my PC it works, when I run the package via SQL Agent it comes back with :-
DTSRun: Loading... Error: -2147287038 (80030002); Provider Error: 0 (0) Error string: The system cannot find the file specified. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts.hlp Help context: 713. Process Exit Code 1. The step failed.
I am not using any files. The DTS Package is called PMC_Test
Here is the dtsrun syntax from the SQL Agent job.
DTSRun /S "APP003" /N "PMC_Test" /E
When I try and open the DTS package using SQL7 client tools I get the same error message.
I'm trying to correct an error that a user is getting when running SQL Server 7.0 SP3, Desktop edition/ Windows NT 4.0 SP6. The error says that C:WINNTSYSTEM32odbcint.dll and C:WINNTSYSTEM32odbccp32.dll are different versions. I tried to install MDAC 2.5 sp1 to correct this problem but this message continues throughout the install. This is causing sqlagent service to hang. Any ideas of how to reinstall ODBC components without reinstalling the OS?
I know this is a very basic question for all of you but I need help.
I am a CPA working with a client to select an accounting & project management software for a construction client. In the top 5 choices, there are 2 that require MS SQL Server as the DB. This client will have about 10-20 users, including project managers & accounting personnel but by DB standards transaction volumes will be low. The company has a few large projects. There is no inhouse IT staff; network administration is outsourced.
The question on the table is this? How much more difficult is it to use MS SQL server in this environment? If all of the client's requirements can be met using a run-time version of Sybase, Pervasive, or FoxPro, isn't this the simplest solution. I don't want to recommend an elephant if it is not needed. I would appreciate your opinion....Thanks
Database newbie question: My sample database (T-SQL syntax): CREATE DATABASE sample GO USE sample CREATE TABLE customers (CustomerId int IDENTITY(1,1) PRIMARY KEY CLUSTERED,name varchar(50),address varchar(50)) CREATE TABLE invoices (InvoiceId int IDENTITY(1,1) PRIMARY KEY CLUSTERED,date datetime,CustomerId int REFERENCES customers(CustomerId)) INSERT customers (name,address) VALUES ('First Company Ltd.','New York') INSERT customers (name,address) VALUES ('Second Company Ltd.','Washington') INSERT invoices (date,CustomerId) VALUES ('Jan 1, 2004',1) INSERT invoices (date,CustomerId) VALUES ('Jan 2, 2004',1) INSERT invoices (date,CustomerId) VALUES ('Jan 2, 2004',2) SELECT * FROM customers GO CustomerId name address 1 First Company Ltd. New York 2 Second Company Ltd. Washington SELECT i.date,c.name,c.address FROM invoices AS i INNER JOIN customers AS c ON i.CustomerId=c.CustomerId GO date name address 2004-01-01 00:00:00.000 First Company Ltd. New York 2004-01-02 00:00:00.000 First Company Ltd. New York 2004-01-02 00:00:00.000 Second Company Ltd. Washington UPDATE customers SET address='Boston' WHERE name='First Company Ltd.' GO INSERT invoices (date,CustomerId) VALUES ('Jan 3, 2004',1) SELECT * FROM customers GO CustomerId name address 1 First Company Ltd. Boston 2 Second Company Ltd. Washington SELECT i.date,c.name,c.address FROM invoices AS i INNER JOIN customers AS c ON i.CustomerId=c.CustomerId GO date name address 2004-01-01 00:00:00.000 First Company Ltd. Boston 2004-01-02 00:00:00.000 First Company Ltd. Boston 2004-01-02 00:00:00.000 Second Company Ltd. Washington 2004-01-03 00:00:00.000 Second Company Ltd. Boston Is it possible in any of the RDBMS's to make this last query return the following result set? 2004-01-01 00:00:00.000 First Company Ltd. New York 2004-01-02 00:00:00.000 First Company Ltd. New York 2004-01-02 00:00:00.000 Second Company Ltd. Washington 2004-01-03 00:00:00.000 First Company Ltd. Boston
Currently i am working with Sql Server 2005 and i am taking daily backups which is going append same backup file <DB_NAME>.BAK.
Now i am trying to restore this bkp with a new database name and with 2 days before date image.When i am trying to do that, sql server is not showing the versions of the backups.
i made a backup devices for the app db and for every one of the system database. and with those devices backup and restore.
can i manually configure the system db or i must restore them? i have an issue where i downloaded and installed v.9.00.2047 while my backups where on v.9.00.1399
