After try and error for several months, finally my SQL2000 LS works.
i gave my self a little celebration for that.
but after running well for a day, just one day !
this morning it give me Out of Sync.
error messages:
failure /4305
activity : Load
[Microsoft SQL-DMO (ODBC SQLState: 42000)]
Error 4305: [Microsoft][ODBC SQL Server Driver][SQL Server]The log in this backup set
begins at LSN 7000000026200001, which is too late to apply to the database. An earlier
log backup that includes LSN 6000000015100001 can be restored.
[Microsoft][ODBC SQL Server Driver][SQL Server]RESTORE LOG is terminating abnormally.
activity : Copy
failure / 32
The process cannot access the file because it is being used by another process.
i just dont understand, how come the load & copy process failed, after it works for a day.
Hi All,I am close before throwing the machine out of the window.I tried to establish a linked server on our SQL2000 server pointing to a DB.EXEC sp_addlinkedserver@server = 'DB2',@srvproduct = 'IBM OLE DB Provider for DB2 Servers',@provider = 'IBMDADB2',@provstr='DSN=JDE_PROD;UID=XXXX;PWD=XXX;DATABASE=J DE_PROD;'EXEC sp_addlinkedsrvlogin 'DB2', false, NULL, 'XXX', 'XXXX'If I query the LS using query analyzer or the Enterprise Manager both startto hang, never responding again.To be honest I am quite new to this topic but I read a lot and also tried alot ;)Some articles talk about SNA Servers to be installed first, others aboutsome client tools.I am confused by now...Could anybody please be so kind and tell me how to connect the DB2 as alinked server?Is my statement wrong, and if so how should it look like? Why does theapplication start to hang? Do I really need to install additional softwareto do so?Our DB2 expert also taked about software necessary to access the DB2mainframe. Any ideas?Thanks a lot in advance and belive me, any hints are highly appreciated ;)Seize the DayAndyAndreas BretlJoin Bytes!
I have tried to set up log shipping for one of our databases - firsttime. Using EM I was able to create the job and maintenance plansucessfully. I wasn't able to find any errors in any logs. In themonitor server, when I look at job history, everything is gettingcopied and loaded sucessfully, yet the STATUS in the log shippingmonitor states it is out of sync.How do I get this into sync? I have set the out of sync threshold to45 minutes. I have made changes in our production database and thosechanges are showing up in the standby database, so it all appears tobe working.Thanks.
I have set up a database with log shipping to the backup server. I have actually set it up multiple times because it continues to get out of sync, and I do not know another way to get it back in sync (despite much effort to learn how). I have not found much documentation in BOL, nor in the on-line areas that I can find. I have not been able to discover why it keeps getting out of sync.
If there is anyone who may shed some light on this, I would be very greatful.
Particulars (both servers):
Windows ADV Server 2003 SQL 2000 (Enterprise Ed.) Servers on a work group (not domain)
There is a separate database on the same servers that continues to have successful log shipping.
I wanted to ask a question about log shipping going out of sync. We have a remote server in the UK that is our production server, and we are trying to set up log shipping with another server in the US. Our Log shipping monitor goes "out-of-sync" after about 8-10 hours. We changed the US server to have the same time as the server in the UK, but there still seems to be an out of syn error after 8 hours.
We are using Windows server 2000 and SQL server 2000.
SQL server will restore logs then after a few hours it stops restoring and goes out of sync. Was just wondering if someone knew the possibilities of why.
I have set up log shipping between two servers with a third serving as a monitoring server. Recently the monitoring for the eight databases that I am log shipping began to indicate that everything was failing. Upon further inventigation of the log_shipping_monitor_history_detail tables on the prinary and secondary everthing appears to working properly but I have been unable to resyncronize the monitoring. I have attempted to use the stored procedure sp_refresh_log_shipping_monitor to no avail, it does not appear to do anything with respect to the data in the dbo.log_shipping_primary_databases and log_shipping_monitor_primary tables on the primary server or the log_shipping_monitor_secondary and dbo.log_shipping_secondary_databases tables on the secondary. I have also manually updated the records in these tables in an attempt to syncronize but after the next sucessful backup, copy and restore this monitoring data is not updating. Does anyone have any ideas as to what I am doing wrong or how I might rectify this situation.
I checked the server and found that LS restore job failing and Backup and copy jobs running fine without any issue. and also observed that Copy folder the trn file existing on secondary server. i try to restore trn file im getting the error. and observed that last log backup file that it restored at the secondary database on May2nd,2015.
2015-06-02 12:25:00.72*** Error: The log in this backup set begins at LSN 761571000000022500001, which is too recent to apply to the database. An earlier log backup that includes LSN 721381000002384200001 can be restored.
From Restore job histort details below.
Message 2015-06-02 12:25:00.72*** Error: The file 'xxxx\_20150530104503.trn' is too recent to apply to the secondary database 'database'.(Microsoft.SqlServer.Management.LogShipping) *** 2015-06-02 12:25:00.72*** Error: The log in this backup set begins at LSN 761571000000022500001, which is too recent to apply to the database. An earlier log backup that includes LSN 721381000002384200001 can be restored. RESTORE LOG is terminating abnormally.(.Net SqlClient Data Provider) *** 2015-06-02 12:25:00.73Searching for an older log backup file. Secondary Database: 'database' 2015-06-02 12:25:00.73*** Error: Could not find a log backup file that could be applied to secondary database 'database'.(Microsoft.SqlServer.Management.LogShipping) *** 2015-06-02 12:25:00.74Deleting old log backup files. Primary Database: 'database'
I am testing log shipping on SQL2000 and am having an issue with the log shipping copy job on the destination. Using the log_shipping_monitor_probe, no trn log files are ever copied to the destination share. I even granted full access to everyone on the primary and destination share folders and using NT authentication uses the ANONYMOUS USER account (not sure why). My error returned from xp_sqlmaint is:NULL Microsoft (R) SQLMaint Utility (Unicode), Version 8.00.2039 Copyright (C) Microsoft Corporation, 1995 - 1998 NULL Logged on to SQL Server 'BOCAVSQLD2LOGSHIPSQLD2' as 'NT AUTHORITYSYSTEM' (trusted) NULL NULL Starting copy for plan BOCAVSQLD1.pubs_logshipping NULL Source database - pubs Copied 0 files NULL Finished copy for plan BOCAVSQLD1.pubs_logshipping (14 row(s) affected)
The above mentioned script by Ron Craig was put on the SWYNK site on 22 February 2002. When all the SQL Server scripts were moved from SWYNK to Jupiter, this article and scripts were lost. I have contacted Jupiter and they admit that it has been lost. If anyone has downloaded this article(prior to the move from SWYNK), please can you forward it to me. If Ron Craig should read this, please can you forward your article to me and ask Jupiter to put it back.
Hi all I've written an app using VWDE and SSE 2005 but it wont work on my hosts. I'm sure the connection string is correct and my hosts say it's all setup ok over there. I get this message: The SSE Provider did not find the database file specified in the connection string. At the configured trust level (below High trust level), the SSE provider can not automatically create the database file. And my hosts says that the db should be fine but some of the VB might not work, this is the line that's causing the issues (red): Line 15: Session("username") = loggedInNameLine 16: Line 17: a = Roles.GetRolesForUser(loggedInName)Line 18: Line 19: For Each j In aThis works fine in SSE 2005, should it work on SQL Server too? Can anyone suggest an alternative? ThanksMark
Hello all,I am a total newbie to SQL. I created this sp and then with C++,called it. My return value was 100 (which it was)CREATE PROCEDURE sp_StoreIPs@IPSource varchar(16),@IPTarget varchar(16),@TimeDate varchar(20),@Name varchar(250)asdeclare @iReturn intSet @iReturn = 100return @iReturnGOThen when I added a INSERT statement like ...CREATE PROCEDURE sp_StoreIPs@IPSource varchar(16),@IPTarget varchar(16),@TimeDate varchar(20),@Name varchar(250)asdeclare @iReturn intInsert into LookUP (IPSource, IPTarget,TimeDate, Name) Values(@IPSource,@IPTarget,@TimeDate,@Name)Set @iReturn = 100return @iReturnGOMy return value was 0. I am assuming the the INSERT statement isreturning the 0 but how can I get around this?ThanksRalph Kraussewww.consiliumsoft.comUse the START button? Then you need CSFastRunII...A new kind of application launcher integrated in the taskbar!ScreenShot - http://www.consiliumsoft.com/ScreenShot.jpg
after we download sp1 and hit runj, we got "Unspecific Error Occur" popup window, with message:The following unexpected error occur:" then without any detail. here is the hotfix log:
A database with 1 mdf and 2 ldf has been detached from SQL Server 7.0 . Then removed the log files ( they are gone , unable to recover ) and there's no backup at all . Now I want to attach the database with the same mdf , but got error msg - 'Device activation error'. It seems like it's looking for one of the log files.
Is there any way to recover the db ?
I guess NOT , isn't it ?
I don't understand why it doesn't work with sp_attach_single_file_db and sp_attach_db . I actually tested it with a dummy database with 1 log file , and it worked - a new log file was recreated. Thus I performed in production server. Don't understand why it doesn't work.
1) SQL server is running and I can access all the dbs when on the server.
2) All the workstations login to the server just fine. Server is configured for Active Directory.
3) SQL server has only the default instance installed and is in mixed authentication mode.
4) I have registered SQL Server in the Active Directory, (right click on the server node in the SQL Server Enterprise Manager and select the Properties item from the popup menu … Active Directory tab etc - as per the article "SQL Server 2000 Active Directory Integration”.
5) When in EM on the workstation, I try to create a sql server registration
a) With Windows authentication - but I get this error: SQL server registration failed because of the connection failure displayed below. Do you wish to register anyway?
Login failed for user '(null)'. Reason: Not associated with a trusted SQL server connection.
b) With user = sa and pwd = sa (both are the correct values and case) SQL server registration failed because of the connection failure displayed below. Do you wish to register anyway?
Login failed for user 'sa'
5) I have checked out http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B269587 and done everything it says.
Help - I haven't been able to connect for several days.
I have tried deleting the registrations several times - same results. I have tried uninstalling sql 2K and reinstalling 3x and tested before and after installing sp3a - same results.
I have been asked to see what I can recover from a development server whose database became suspect during a power failure.
One developer from another group who's time is limited tried to repair the database using checkdb, but it is still suspect.
There are no recent backups of anything whatsoever. Needless to say, we are lacking in DBA skills here. At this point, we don't care whether we get the data back, but we are desperate to recover the table definitions, user-defined functions and stored procedures -- if not all of them than most of them; if not most of them than some.
What are our options here?
Are their any good third-party tools to help us with this problem?
So im trying to return everything that uses that dbo.style im getting this error I just want to show where that table is being used and suggestions. I know that feature is undocumented. This also doesnt seem to be searching all the Databases when I search it.
Server: Msg 15009, Level 16, State 1, Procedure sp_depends, Line 28 The object 'dbo.style' does not exist in database 'master'. Server: Msg 15009, Level 16, State 1, Procedure sp_depends, Line 28 The object 'dbo.style' does not exist in database 'tempdb'. Server: Msg 15009, Level 16, State 1, Procedure sp_depends, Line 28 The object 'dbo.style' does not exist in database 'msdb'. Server: Msg 15009, Level 16, State 1, Procedure sp_depends, Line 28 The object 'dbo.style' does not exist in database 'GoldMine_Sales_and_Marketing'. Server: Msg 15009, Level 16, State 1, Procedure sp_depends, Line 28 The object 'dbo.style' does not exist in database 'CustomerConcerns'. Server: Msg 15009, Level 16, State 1, Procedure sp_depends, Line 28 The object 'dbo.style' does not exist in database 'Aggregate'. Server: Msg 15009, Level 16, State 1, Procedure sp_depends, Line 28 The object 'dbo.style' does not exist in database 'OLD_BUDGET'. Server: Msg 15009, Level 16, State 1, Procedure sp_depends, Line 28 The object 'dbo.style' does not exist in database 'CreditCardData'. Server: Msg 15009, Level 16, State 1, Procedure sp_depends, Line 28 The object 'dbo.style' does not exist in database 'DELSA'. Server: Msg 15009, Level 16, State 1, Procedure sp_depends, Line 28 The object 'dbo.style' does not exist in database 'COZUM'. Server: Msg 15009, Level 16, State 1, Procedure sp_depends, Line 28 The object 'dbo.style' does not exist in database 'DelSolNet'. Server: Msg 15009, Level 16, State 1, Procedure sp_depends, Line 28 The object 'dbo.style' does not exist in database 'DelSolNet2'. Server: Msg 15009, Level 16, State 1, Procedure sp_depends, Line 28 The object 'dbo.style' does not exist in database 'DYNAMICS'. Object does not reference any object, and no objects reference it. Server: Msg 15009, Level 16, State 1, Procedure sp_depends, Line 28 The object 'dbo.style' does not exist in database 'HUNTB'. In the current database, the specified object is referenced by the following: Server: Msg 15009, Level 16, State 1, Procedure sp_depends, Line 28 The object 'dbo.style' does not exist in database 'MASDEV'. Server: Msg 15009, Level 16, State 1, Procedure sp_depends, Line 28 The object 'dbo.style' does not exist in database 'MASDEVSmall'. Server: Msg 15009, Level 16, State 1, Procedure sp_depends, Line 28 The object 'dbo.style' does not exist in database 'OLDOnlineOrdering'. Server: Msg 15009, Level 16, State 1, Procedure sp_depends, Line 28 The object 'dbo.style' does not exist in database 'OnlineRMA'. Server: Msg 15009, Level 16, State 1, Procedure sp_depends, Line 28 The object 'dbo.style' does not exist in database 'OnlineStore'. Server: Msg 15009, Level 16, State 1, Procedure sp_depends, Line 28 The object 'dbo.style' does not exist in database 'DELSO'. Server: Msg 15009, Level 16, State 1, Procedure sp_depends, Line 28 The object 'dbo.style' does not exist in database 'Reporting'. Server: Msg 15009, Level 16, State 1, Procedure sp_depends, Line 28 The object 'dbo.style' does not exist in database 'SSE'. Server: Msg 15009, Level 16, State 1, Procedure sp_depends, Line 28 The object 'dbo.style' does not exist in database 'STTHO'. Server: Msg 15009, Level 16, State 1, Procedure sp_depends, Line 28 The object 'dbo.style' does not exist in database 'TMPLT'. Server: Msg 15009, Level 16, State 1, Procedure sp_depends, Line 28 The object 'dbo.style' does not exist in database 'WHAVL'. Server: Msg 15009, Level 16, State 1, Procedure sp_depends, Line 28 The object 'dbo.style' does not exist in database 'QSCHQ'. In the current database, the specified object is referenced by the following: In the current database, the specified object is referenced by the following: In the current database, the specified object is referenced by the following: Server: Msg 15009, Level 16, State 1, Procedure sp_depends, Line 28 The object 'dbo.style' does not exist in database 'SOLKD_DATA'. Server: Msg 15009, Level 16, State 1, Procedure sp_depends, Line 28 The object 'dbo.style' does not exist in database 'SOLKD_NET'. Server: Msg 15009, Level 16, State 1, Procedure sp_depends, Line 28 The object 'dbo.style' does not exist in database 'ALOHA_DATA'. Server: Msg 15009, Level 16, State 1, Procedure sp_depends, Line 28 The object 'dbo.style' does not exist in database 'ALOHA_NET'.
've installed sql 2005 xpress with advanced services......also installed the toolkit that came along..
all 'm interested in is to perform certain data mining operations on the adventureworks db..
;ve also installed the advn works db.........
now here is the prob.......
jus like how the sql online book instructed me i first started off with the datamining tutorial..where i was told to first OPEN BIDS select new PROJECT then make sure that the analysis Services template was selected and then go ahead with selection of the particular sln file....
the problem is that I DON'T SEE ANY ANALYSIS SERVICE TEMPLATE....all i c is a REPORT template..
i really need help guys..... 'm new to .net really feeling helpless...
Technically i am a network administrator, and know very little about SQL 2005, but it has come under my responsibility to manage this box and a lot depends on fixing this problem for me.
Error:
Service Broker needs to access the master key in the database 'Prototype'. Error code:25. The master key has to exist and the service master key encryption is required.
Also, i get the following both in windows event viewer and SQL logs;
Error:
Source: Logon
Message
Error: 18456, Severity: 14, State: 5.
Login failed for user 'logadmin'. [CLIENT: 192.168.1.2] Event ID 18456;
Login failed for user 'admin'. [CLIENT: 192.168.1.34] Event ID 18456
Symptoms:
While users are working and try to run a new query, their credentials are not accepted anymore. The account they are using is has "sysadmin" rights.
Once they restart the machine, they can run multiple queries, and then the same thign over again.
Please help me with this one, for i have pretty much exhausted google etc. I mean there are various blogs with same prblem but not a straighforward fix.
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.
I hope anyone can help me with this. I am having problems connecting to the aspnet database. It all started when I noticed that I could not log in to my webapplication anymore under debug mode, although I was able to log in when remotely accessing the website. I got the error message that the machineaspnet user did not have access to the database: "Login failed for user 'GM-FEDORSASPNET' "This was highly peculiar and rather annoying so I tried several things to straighten this out, but it only made things worse!I read that this had to with permissions of the database in question, al though I could not understand why permissions suddenly had changed. I tried to change the rights by attaching it to Management Studio Express and defining an aspnet login, but that failed because a login under that name was not accepted. I tried to make a copy of aspnet.mdf, delete the original and rename the copy to aspnet.mdf. When that didn't work, I then deleted the aspnet.mdf, counting on it that it would be regenerated automatically, but alas. I located the aspnet_regsql.exe tool to regenerate the database, but got the following error message: System.Web.HttpException: Unable to connect to SQL Server database. ---> System.Data.SqlClient.SqlException: 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)What can I do?
Good morning all. I need some help with a stored proc that is driving me up a wall. It's probably something stairing me right in the face but I can't see it!
I keep getting the following error on the procedure that I'm working on: SQL-DMO (ODBC SQLSTATE: 42000) ERROR 156: Incorrect syntax near keyword 'AS' Must declare the variable '@signid' Must declare the variable '@signid'
Here's the code:
CREATE PROCEDURE [dbo].[ws_savesignature2db] @xml as text='', @image as image='', @imageformat as varchar(20)='', @imagename as varchar(40)='', @imagesize as int=0, AS insert into signaturetable ([image], imageformat, imagename, imagesize) values (@image, @imageformat,@imagename,@imagesize)
/* if your XML field datatype is Text or nTEXT, use the code below in Sql Server 2000. If you use Sql Server 2005, you can use varchar(max) or nvarchar(max) which will be much easier and you do not need the code. */ select @signid = @@IDENTITY DECLARE @ptrval binary(16) SELECT @ptrval = TEXTPTR([xml]) FROM ws_signature WHERE signid= @signid if @ptrval is not null WRITETEXT ws_signature.xml @ptrval @xml GO
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 own a DELL dimesnsion 4600 desktop. I purchased it with windows xp HOME although I have upgraded to windows xp professional. I am trying to install Office Enterprise 2007 with the disk i purchased. My computer will not pick it up though. I know the cd works because I tried it on another computer but didnt intsall it. That computer read the disk. My computer will not. any help? desperate need
i have sql2000 & sql2005 on the same machine. I am unable to register my localhost in sql2000, get an access denied error. How can I make my localhost use sql2000 database?
Does anyone have any basic, simple scripts of sp's that I can give mycomputer operators to use to monitor for serious conditions on our sqlservers? We are new in the ms-sql arena, a small shop and we cantreally purchase any tools to monitor these servers, but we need somebasic checks that we can use to make sure a server is performing in areasonable fashion, no blocks, cpu<xx%, memory not pegged, IO working,etc...and we need to be able to do this without bugging ourprogrammers every time we are wondering why things are slowwnig down.We are a split shop between as400s and sql servers, and our operationsstaff has no problem performing this type of duty on the 400s. I thinksince the sql servers are so easy to deploy into production, the ideaof how to monitor these things health got lost in the shuffle andallowing the programmers to do it just serves to destabilize ourenvironment.Please help! Our shop has turned to chaos since we went live withMSSQL centric applications and everytime one programmer "resolves anissue" some other programmers application starts to act up.
i am in the process of Migrating SQL 2000 to my new SQL2000 server i want to know the what would the best way for me to migrate one SQL server to another SQL server on the same network and rename the new server to the old server and bring it up for use in our ecommerce website.
Hi Forum, Ive been unsuccessfully trying to copy data from one table to another, very simple scenerio! Table1 ID(PK), FirstName, Mobile, Date. Table2 FirstName, Mobile. The first question I have is should I fill Table2 at the insert stage OR should/do I update Table2 from Table1 as the users details are entered. ie create some kind of relationship. Really appreciate good advice! cheers P
I have two db instances on different SQL Servers. One is my test db and the other the prod. db. Each has two tables that hold lookUp values for the entire application. I would like to keep these tables in sync. in both dbs. The prod. db would be the master. I was trying to design a trigger to insert, update, or delete the appropriate records in the test db as they were added or deleted from the prod db. I'm getting too many prefixes errors on the script when trying to reference the table on the test db using four part naming convention. Any ideas on how to resolve this issue? Do I need to set up a linked server to accomplish this functionality? If so, how do I setup security for a linked server? Thanks in advance. Oscar
I have a SQL 7 backup file that I restored onto a new server. All the objects within the database are not owned by dbo, instead they are owned by a db user. When I tried to login to the db it said that it wasn't a valid user. So I added the login to the system. Now when I login it says it is not a valid db user. I have attempted to sync the id's but don't know how. In 6.5 I could run an ad-hoc query to match the SUID's for the system and the database. In 7.0 I can not because the suid for the db is computed. Any ideas on how to sync the user ID's so that I can login to the server using the target db as my default and can query the table with prefacing the owner(I can get in if I give my login SA privelages but then I have to preface all the objects with the owners name)?
Thanks in advance for any help that you can offer.
we currently have a web server/db on-site and a similar backup machine across the country. we're using a pretty bad backup strategy. we zip up a backup file, thats done on the main server every night, then ftp over to the back up server then run a restore.
lately ive been having problems with the main server. i would like to have the machines sync'd up as close as possible.
ive searched the threads and noticed replication and log shipping to be the most practical, but im assuming most of the machines are on the same domain.
what would be my best bet for machines connected over the internet, no vpn?
also the db on the main machine get queried/inserts all day from 7am - 6:30pm
