I have to schedule the automatic restore the standby database for
testing backups . The database was already in log shipping mode. Up to
what point do I need to restore the database without affecting the log
shipping sequence? Can we query the log shipping tables for the last
scn applied and recover up to that point? Any suggestoions are welcome.
Thanks
Tram
Hello,
I would like to request you to kindly point me to a location where I may obtain more ideas/suggetions/details on how synchronization may be performed in a real world scenario ?
MS has been promoting smart clients and offline availability, but I cant seem to find any material that outlines some ideas/techniques/pointers as to how this may be acheived sans SQL Server replication
Essentially, what I'm looking for is someting that would guide a not-so-solid-with-databases person like me through how synchronization (sans sql replication engine) may be implemented - any watchouts etc..
Regards,
Avinash
Hi all,
Heres the deal -
I have several remote users - all running the same program, with a local copy of MSDE...
I would like to setup a master server at my office that will act as a repository for the data that is generated at the remote sites.
I would like the remote users to establish a connection with the server (tcp/ip) and upload all the data they have entered into the local database.
They do not need to download any data - this is accomplished through the web services of SQLXML -
they just need to upload all the data they have, without destroying the data from before.
I have some concerns on the auto-inc that is used in the tables now and how they will react to each other in the master database...
thanks for any help
take care
tony
Hi all, here are my goals: Have the same DB on two different stand-alone computers, and keep them up-to-date from each other.
Basically a user would input to a DB for a week. Then every week or two, update the other stand alone DB with the new input. The DB would be exactly the same.
What are my options for this? I'd like it as easy as possible! Are there any software packages that deal with this type of transfer, etc.? Thank you!
All,I have an Access DB. On a nightly basis, I want to look at an OtherDB (not Access, but SQL) and:+ Add any new records from Other.Clients into Access.Clients
Quote:
Hi all,
We are going to have several dozen servers around the country- each with a mirror copy of the initial database (blank) loaded upon them.
The data will be entered at each station, and then once a month, the systems will dial into the 'net and -
this is where i am getting stuck -
we would like the data from the remote areas to update the data in the master database -
What would be the best solution to update the data from the remote station into the master database???
thanks
tony
we have a merg replication running in three regions UK,USA and AU
my question is in one of our test environment testers managed to get a few tables out of synch while the replication is out.
we have re-established the replication since then and it worked fine untill they try to update records from those out of synch tables. as usual we get conflicts.
we don't really know how many tables are out of synch either. we have about 500 tables.
is there a way to synch tables from with in the merge replication??
Hi Everyone
As most of you do, I am eagerly awaiting the ability to synchronize my sql mobile database on the hand held to a local sql express database on my local machine
I know users in Microsoft have pointed out to us that we are getting things for free.
At the same time, Microsoft is getting our patience for free and at a cost to us developers.
Its nearly April and as one article says Microsoft will release a fix for this inadequacy
Microsoft...we are happy to pay for this. Palm offers it so what is the big deal. Its not the
reinvention of the wheel. We would have liked that instead of the server synchronization
that bypasses the local sql express database
I as many others are happy to pay
Please let us know when you will be addressing this problem.
I would appreciate the feedback and frustration of other developers. Maybe this will show them we are really running out of time with our clients
Regards
Touraj
Hi ... I am converting SqlServer 2000 databases to SqlServer 2005. It is working great for the most part.
The issue I am having is that a user with a schema that owns objects is established in the database and no user is defined in the instance logins. I can see where if I add the instance login then the Principal_id does not match. Cannot drop the user/schema as there are referenced objects.
I got around this in SqlServer 2000 by updating the IDs to match but now they are views and updating is not allowed.
Is there a straightforward way to resynch the database user to a newly created login?
Thanks,
John
Hi,I had this problem in version 7 and dont remneber How I solved it!!I have installed a local SQL Server (2000 aka version 8) on myWorksation (W2K), I have picked NT authuntication.Everything was fine untill I changed my password. Now SQL server cannot start because it fails to login. The old password is embeddedsomwhere and I cant egt to it!!!My workstation is on a network, so the password is my networkpassword.Everythinng is MS on our network.Any help would be appreciated.ThanksFardad
View 1 Replies View RelatedHello,I'm relatively new to the database world so please forgive me inadvance for my ignorance. I have recently been tasked at my job withfinding a tool that will perform the following tasks: 1) extractschemas from a db, 2) produce a difference report between schemas fromtwo databases, and 3) synchronize two schemas. The purpose is forproduct upgrades during which an existing database schema will need tobe synchronized with a baseline schema.The tool must support the following database vendors (versions givenin parenthesis): Oracle (8i/9i), Sybase (12.x), Informix (9.x), MSS2000, and IBM DB2 (7/8).I have spent the last several days downloading and researching avariety of tools such as Aqua Data Studio, DbVisualizer, DBExplorer,DBDiff, and AdeptSQL. I thought it would be a good idea to post amessage to a few database newsgroups and ask for any recommendationsdatabase developers may have.So if anyone has any recommendations on such a tool or softwarepackage, I would greatly appreciate any information.Thanks!Chad Smith
View 9 Replies View RelatedWe are trying to set up Web Synchronization, but we keep getting the error "IIS ws not found on the web server. Please specify a computer name that has IIS installed".
Our Distributor/Publisher are on one box, IIS on aother box. Both boxes are in the same domain (test environment), and both boxes are being logged into with a domain account.
We can get this to work in another similar environment so we don't know why this one isn't working. Is it permission issues?
Thanks...
Hi
I could not able to find Forums in regards to 'Log Shipping' thats why posting this question in here. Appriciate if someone can provide me answers depends on their experience.
Can we switch database recovery model when log shipping is turned on ?
We want to switch from Full Recovery to Bulk Logged Recovery to make sure Bulk Insert operations during the after hours load process will have some performance gain.
Is there any possibility of loosing data ?
Thanks
Dear all,
I am running into a null reference exception on replication with SQL Server 2005 Compact Edition. The problem occurs at repl.synchronize(). Even though the statement is inside a try-catch block, the exception is not caught, and the application quits.
Device O/S: Windows Mobile 5.0 v 5.1.195 Build 14957.2.3.1
Hardware: Dell Axim X51v, Intel PXA270
Database: SQL 2005 SP2 (no post SP2-patches)
Exception shows as "an unexpected error has occured in AppName.exe. Select Quit and then restart this program, or select Details for more information." Details:
.. at NullReferenceException at AppName.Form1.Synch()
.. at .... (various lines)
.. at AppName.Form1.Main()
The application is based on the tutorial (Creating a Mobile Application with SQL Server Compact Edition) at http://msdn2.microsoft.com/en-us/library/ms171908.aspx.
The application was successfully working initially but then stopped working on replication after some minor modifications which were not related to the replication code, e.g. adding some buttons to the form.
Three things are puzzling me here..
1. The fact that this is a NullReferenceException and not a SqlCeException
2. Why the try-catch block doesn't work
3. Why the exception occurs
Is this a bug or am I doing something wrong here?
Any help would be appreciated.
Code sample below:
Sub Synch()
Try
LogMsg("Deleting db...")
DeleteDB()
LogMsg("Initializing repl...")
Dim repl As New SqlCeReplication
repl.InternetUrl = http://192.168.0.100/SQLMobile/sqlcesa30.dll
repl.Publisher = "TRKSRV"
repl.PublisherDatabase = "trk_db"
repl.PublisherSecurityMode = SecurityType.NTAuthentication
repl.Publication = "Trk"
repl.Subscriber = "Trk"
repl.SubscriberConnectionString = "Data Source=""Program FilesTrk2007DefectTrk.sdf"";Max Database Size=128;Default Lock Escalation =100;"
LogMsg("Adding subscription...")
repl.AddSubscription(AddOption.CreateDatabase)
LogMsg("Synch...")
repl.Synchronize()
LogMsg("Cleanup...")
repl = Nothing
Catch err As SqlCeException
MessageBox.Show(err.ToString & " " & err.HResult & " " & err.NativeError & " " & err.Message & " " & err.InnerException.ToString)
Catch err2 As Exception
MessageBox.Show(err2.ToString & " " & err2.Message.ToString & " " & err2.InnerException.ToString)
End Try
End Sub
Hi,
I 'm sure I am missing something obvious, hopefully someone could point it out. After a failover log shipping, I want to fail back to my inital Primary server database; however, my database is marked as loading. How can I mark it as normal?
I did the failover as follow:
I did a failover log shipping from the 2 server Sv1 (Primary) and Sv2 (Secondary) by doing the following
1) Stop the primary database by using sp_change_primary_role (Sv1)
2) Change the 2nd server to primary server by running sp_change_secondary_role (Sv2)
3) Change the monitor role by running sp-change_monitor_role (Sv2)
4) Resolve the log ins - (Sv2)
5) Now I want to fail back - I copy the TRN files to Sv1 - use SQL Ent to restore the database at point in time. The task is done; however, the database is still mark as loading. I could not use sp_dboption.
I appreciate any suggestion.
Thanks in advance
Greetings!
I would like to create a database for keeping track of payroll data for employees where the supervisors (job coaches) on our workshop floor can use a Pocket PC device to record the hourly employee data on the fly. Then at the end of the day, the supervisor can place the device in a cradle of some sort and synch the newly entered data into the main database.
I'm guessing that SQL Server Compact edition would be perfect for this type of task? Is that correct? Can someone give me recommendations on how to go about setting this up? What should I use as the main database? SQL Server? Access? Any advice is appreciated!
I was hoping someone could help me with a question. I have a server that has a table with 5.6 million rows of data. I want to use DTS to transfer all the rows in the table from one SQL server to another via DTS, which I have got to work correctly. The problem I'm having is when I run the DTS job the 2nd time, it does all 5.6 million rows again and not just the deltas since the last DTS job. Is there anyway to use DTS to transfer the deltas (ex: 1000 rows since the last DTS job) from server 1 to server 2 ?
Thank you.
we have a table in an oracle database containing security information that is updated several times a day. the network connection into that oracle database is not always reliable. we would like to keep a copy of that table in a sql2005 database. the table will need to be refreshed 1/hr. it is a small table so performance won't be an issue.
would ssis be ideal for setting something like this up? i have never created an ssis package before (i'm an oracle dba crossing over). any pointers on how best to set this up?
thanks!
chris
Could somebody please guide me on how best to Implement SQL Server Log Shipping. I have gone through BOL without luck. Thanks.
View 2 Replies View RelatedI need to create a RO copy of a production DB owned by an outside company. We are connectd via a WAN link, but cannot use replication. They are proposing using an initial load via tape, and sending us a text file nightly with the days changes to the DB. We will then need to load that data using BCP, DTS or some other method. Does any one have any ideas on using log shipping instead of the text file. It would only be practical to get a fresh load of the entire DB once a quarter or once a month at most. It is a 40+ GB database and we are expecting 100 to 200 MB of logs per night. For business reasons, we are limited to some type of file transfer mechanism for the data transfer, and cannot really change their backup schedule which is nightly fullbackups and tlogs every 30 minutes.
View 1 Replies View RelatedCan anyone point out me , What does Log shipping mean ?
Is it backup of Log file ? or moving backup logs to any other destination ?
Thanks
Karthik
Hi all,
I am using SQL 2k EP Editions with SP2 on Win 2k Advance servers. Since more than week or so I am trying to establish log shipping between two servers. But its not working.
I am using database maintainence plan wizard to set up log shipping. Every thing works fine as far as wizard is concern, it creats plan for log shipping. But my log shipping is not working. The plan to back up log on source database is working fine. I can see the job history and the log files in the backup folder. But I have found that the job on the standby server to copy log file on network folder is failing and so the job to restore log on stand by server. I get the following message
"sqlmaint.exe failed with error state....."
Little reaserch on the standby server found that sql server is using maintainence plan to copy and restore log files, but i do not see any database maintainence plans on standby server as well as I have checked that there is no plan id in sysjobs table on either server.
I have sa rights. The account used by sql service and sql agent have admin rights and they do have rights to access the network folder for both the servers. So there is no rights problem.
I have followed all steps published in white paper for setting up log shipping on microsoft web site.
I have searched microsoft KB but it is of no use for sqlmaint.exe.
Any help is highly appreciated.
thanks in advance.
Minesh.
This might end up being fairly lengthy...I'm in the midst of implementing log shipping as a "warm stand-by" solution at my company. All the components appear to be in place: I'm using cmd shell to copy the backup device file to a remote server and then execute a RESTORE stored procedure on the remote server.
The copy and restore work just fine. The problem I'm having is with the transaction log dumps and restores.
We normally dump transaction logs (and then truncate) every hour. With the log shipping being implemented, we're going to want to do separate log dumps every ten or fifteen minutes, copy that dump over to the remote server, and then apply that log to the database.
Here's the question: for the log ship portion, I don't truncate the log. But after the "normal" log dump occurs, things get tossed out of whack. When you try to apply a log, I get the message "database has not been rolled forward enough....".
Has anyone encountered this type of issue and if so, how did you work around it? I'm assuming it's a simple of issue of certain options you set on your dumps and scheduling....
I'd appreciate any help....
Thanks!!!
Does anyone know if Log Shipping in SQL 2000 Ent also ships over database schema changes?
View 2 Replies View RelatedWe are considering implementing log shipping. Do the sql server logs keep track of the logs that are shipped and applied through log shipping? Or is there some other way to make sure that all logs have been shipped and applied?
View 1 Replies View RelatedI have been successful in getting log shipping working but still have some nagging questions that I cannot find answers to.
1. I had a situation where the copy for one TranLog took much longer than the 15 minute interval I have it setup for. It seemed to get stuck on that copy. Is that how it is supposed to behave.
2. Related to the question above, weekly, I have jobs that reorganize, check integity, recalc statistics. Would these jobs create very large log files? If so, how do others deal with this?
3. Is there any documents available that discuss testing converting your secondary server/database to your primary and back again?
4. Is there a way to setup Email notification to report out-of-sync conditions?
Any other gotcha's that people have run into.
Any help would be greatly appreciated.
Thanks,
Ken Nicholson
Hi
While configuring log shipping, if i choose the "allow database to assume primary role" then the "ceate and initialise new database " option is selected by default..Does this happen all the time or am i missing something.What if i have already initialised the destination database.
Thanks
Madhukar Gole
Hi all,
I am testing my log - shipping strategy. I have tried with northwind database and it was successfully created and is operating. However in order to test I have created a new Test Table in the primary database to see whether it is working. From now on database shows that it has been loading and I cannot see any tables it is grayed and it says loading. What would be the problem? When I checked the logs it has been copying to the secondary database and it doesn't show any error in the log-shipping monitor. It seem everything is cool accept this loading part. If some one help me I really appreciate it.
Thanks
LS
:confused:
Hi all,
I am using SQL 2k EP Editions with SP2 on Win 2k Advance servers. Since more than week or so I am trying to establish log shipping between two servers. But its not working.
I am using database maintainence plan wizard to set up log shipping. Every thing works fine as far as wizard is concern, it creats plan for log shipping. But my log shipping is not working. The plan to back up log on source database is working fine. I can see the job history and the log files in the backup folder. But I have found that the job on the standby server to copy log file on network folder is failing and so the job to restore log on stand by server. I get the following message
"sqlmaint.exe failed with error state....."
Little reaserch on the standby server found that sql server is using maintainence plan to copy and restore log files, but i do not see any database maintainence plans on standby server as well as I have checked that there is no plan id in sysjobs table on either server.
I have sa rights. The account used by sql service and sql agent have admin rights and they do have rights to access the network folder for both the servers. So there is no rights problem.
I have followed all steps published in white paper for setting up log shipping on microsoft web site.
I have searched microsoft KB but it is of no use for sqlmaint.exe.
Any help is highly appreciated.
thanks in advance.
Minesh.
Hi All,
I failed to configure the Logshipping in
SQLServer2000, through database maintenance plan wizard,
at last step I got the following error.
Microsoft SQL-DMO(ODBC SQLState:42000)
Error 50007:xp_repl_encrypt:Error executing
srv_paramsetoutput
I am running SQLServer2000 Enterprise Edition with
Servicepack2, and Windows2000AdvancedServer with
Servicepack2 on both machines and bothe machines are in
the domain, both SQLServerservices are running under
Domain account.
thanks in advance,
Rob.
HI,
Is there any effect on taking full backups on Primary Server while log Shipping is in place? If we take a full backup is that applied to the secondary server?
thanks
We would like to use log shipping for a Near Real Time (5 min delay)reporting server. SQL 2000 requires exclusive use of the database when the logs are applied. This presents a problem since there may be a couple of hundred users on the NRT server. Even if they only make connections when running the reports there could be some contention issues. Has anybody used log shipping in this type of scenario?
View 2 Replies View RelatedIs it possible to log ship a database from server A (source) to server B (read only) when the database on server A is partly replicated (transactional repl) to several other servers ? All hints and advices are highly appreciated.
View 2 Replies View Related