Error 1068 And Hardware RAID Failure ?
May 20, 2005
Have a problem with SQL today. I rebooted the server and now it cannot see the E: drive, as per the RAID array setup. Problem being is that all my SQL databases and logs are on this drive. I'm guessing that the error message is just misleading as based on Microsoft this means the server is stand alone and needs to be started with a non-Domain account. Fix the hardware RAID array and hope all is well. Does that sound about right to you?
View 2 Replies
ADVERTISEMENT
Oct 11, 2000
Hi,
I have a pb with SQL Server,
SQLSERVERAGENT service ande the MSQLSERVER service can't be started.
Two error messages: Error 1068 and Error 1069, appeared when I want started those services.
It's a big pb for me, because I had implemanted my Base in server and I can't acceded it.
Please, give me a solution.
thank you.
View 1 Replies
View Related
Aug 19, 2007
Background... Server raid failed, rebuilt raid ran chkdsk but now I am
unable to run SQL service.
I've tried to manually start service but receive the following message
The MSSQLSERVER service on the local computer started and then stopped. Some
services stop automatically if they have no work to do.
Here's all I have in the error logs
2007-08-19 10:56:39.98 server Microsoft SQL Server 2000 - 8.00.2039
(Intel X86)
May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation
Developer Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
2007-08-19 10:56:39.99 server Copyright (C) 1988-2002 Microsoft
Corporation.
2007-08-19 10:56:39.99 server All rights reserved.
2007-08-19 10:56:39.99 server Server Process ID is 1812.
2007-08-19 10:56:39.99 server Logging SQL Server messages in file
'f:MSSQLlogERRORLOG'.
2007-08-19 10:56:40.01 server SQL Server is starting at priority class
'normal'(2 CPUs detected).
2007-08-19 10:56:40.15 server SQL Server configured for thread mode
processing.
2007-08-19 10:56:40.18 server Using dynamic lock allocation. [2500] Lock
Blocks, [5000] Lock Owner Blocks.
2007-08-19 10:56:40.23 server Attempting to initialize Distributed
Transaction Coordinator.
2007-08-19 10:56:42.29 spid4 Starting up database 'master'.
2007-08-19 10:56:42.31 spid4 Error: 5172, Severity: 16, State: 15.
2007-08-19 10:56:42.31 spid4 Error: 5173, Severity: 16, State: 1.
2007-08-19 10:56:42.31 spid4 Error: 5180, Severity: 22, State: 1.
View 3 Replies
View Related
Mar 1, 2008
hello there,
Could someone help me with my server. I could not start SQLServerAgent.
and have an error message:
An error 1068 - (The dependency service or group failed to start.) occurred while performing this service operation on the SQLServerAgent Service.
The startup account for both MSSQLServer and SQLServerAgent is on Local System Account.
And on the SQL Error Log I got:
2008-03-01 14:50:12.89 server Copyright (C) 1988-2002 Microsoft Corporation.
2008-03-01 14:50:12.89 server All rights reserved.
2008-03-01 14:50:12.89 server Server Process ID is 164.
2008-03-01 14:50:12.89 server Logging SQL Server messages in file 'D:Program FilesMicrosoft SQL ServerMSSQLLOGERRORLOG'.
2008-03-01 14:50:12.90 server SQL Server is starting at priority class 'normal'(1 CPU detected).
2008-03-01 14:50:12.92 server SQL Server configured for thread mode processing.
2008-03-01 14:50:12.92 server Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks.
2008-03-01 14:50:12.93 spid3 Starting up database 'master'.
2008-03-01 14:50:12.96 spid3 Error: 9003, Severity: 20, State: 1.
2008-03-01 14:50:12.96 spid3 Cannot recover the master database. Exiting.
I thnik the SQLServerAgent won't start because the the ERROR 9003. May be my Db is corrupted.
Is there anyone that could help me?
View 4 Replies
View Related
Apr 4, 2007
I am configuring a new database server, without SAN access, and want to know what is the best practice for SCSI RAID configuration. Do most folks prefer RAID 5 or RAID 10 configurations where their databases will reside?
View 8 Replies
View Related
Mar 27, 2008
I've always heard that RAID 5 (or better, RAID 10) is preferred for the actual database (mdf), but RAID 1 for logging.
If I have a dedicated physical volume for each, what's the performance hit for selecting RAID 1 for the MDF files? 3%, 20%, 200%?
Doing so (all RAID1) will allow me to have a separate physical volume for the TEMP database - that is heavily used by my app.
View 1 Replies
View Related
May 1, 2006
RAID 5 beats RAID 10Can I get some feedback on these results? We were having some seriousIO issues according to PerfMon so I really pushed for RAID 10. Theresults are not what I expected.I have 2 identical servers.Hardware:PowerEdge 28502 dual core dual core Xeon 2800 MHz4GB RAMController Cards: Perc4/DC (2 arrays), Perc4e/Di (1 array)PowerVault 220SEach Array consisted of 6-300 GB drives.Server 1 = Raid 103, 6-disk arraysServer 2 = Raid 5 (~838 GB each)3, 6-disk arrays (~1360 GB each)TestWinner% FasterSQL Server - UpdateRAID 513Heavy ETLRAID 516SQLIO - Rand WriteRAID 1040SQLIO - Rand ReadRAID 1030SQLIO - Seq WriteRAID 515SQLIO - Seq ReadRAID 5MixedDisktt - Seq WriteRAID 518Disktt - Seq ReadRAID 52000Disktt - Rand ReadRAID 562Pass Mark - mixedRAID 10VariesPass Mark -Simulate SQL ServerRAID 51%I have much more detail than this if anyone is interested.
View 13 Replies
View Related
Nov 16, 2007
Hello,
On the development server, I am trying to work with subscriptions . Report Server is windows authenticated.
When no paramters exist for the report, the sucbscription is successful.
But if there are paramters for the report, email delivery fails.
These are not data driven subscriptions.
Did anyone face the same problem ? Can anyone tell me where to start debugging since logfiles just say failure to send the email.
Thanks,
SqlNew
View 2 Replies
View Related
Feb 9, 2004
the problem is
source:kernel
backup medium ::reportloerror:write failure on backup device\. ape0.operating system error 23(data error(cyclic reduncancy check));
View 1 Replies
View Related
Mar 23, 2007
I am fed up of getting the below error message of repl. atleast once a day.
JOB RUN: 'REPL:1001' was run on 3/23/2007 at 3:00:01 AM
DURATION: 1 hours, 11 minutes, 11 seconds
STATUS: Failed
MESSAGES: The job failed. The Job was invoked by Schedule 421 (Replication agent schedule.). The last step to run was step 3 (Detect nonlogged agent shutdown.).
Please see below for the description of my Replication Job:
------------------------------------
Steps of Job:
1. Distribution Agent startup message.
db: distribution
cmd:
sp_MSadd_distribution_history @perfmon_increment = 0, @agent_id = 126, @runstatus = 1, @comments = 'Starting agent.'
2. Run agent.
cmd:
-Subscriber [GIZMO] -SubscriberDB [TelehopBilling] -Publisher [ROGER] -Distributor [ROGER] -DistributorSecurityMode 1 -PublisherDB [TelehopBilling]
3. Detect nonlogged agent shutdown.
db: distribution
cmd:
sp_MSdetect_nonlogged_shutdown @subsystem = 'Distribution', @agent_id = 126
This Job is executed every hourly and an error is fired atleast once a day notifying failure of this process. Please help me in resolving this issue.
Thanks,
View 4 Replies
View Related
Mar 13, 2007
I have an ASP page I'm testing and this is what I'm trying to do with it. I simply need it to read a SQL table on my server and display data from that table on screen. Thats it. But no matter how many times I tweak my code I keep getting 404 web page not found. Here is the entire pages code:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN"
<script language="JavaScript">
<!--
var win = null;
function NewWindow(mypage,myname,w,h,scroll){
LeftPosition = (screen.width) ? (screen.width-w)/2 : 0;
TopPosition = (screen.height) ? (screen.height-h)/2 : 0;
settings = 'height='+h+',width='+w+',top='+TopPosition+',left='+LeftPosition+',scrollbars='+scroll+',resizable=no'
win = window.open(mypage,myname,settings)
}
//-->
</script>
</head>
<%
'**************************************************************************
' This page will be used as a test page for Guests and Links
' its purpose is to simply read the guests and links tables then show
' what ever data is in them on the asp page.
'**************************************************************************
' This is the SQL section
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
con.Open "PROVIDER=SQLOLEDB;DATA Source=IP Address of server here;Initial Catalog=folder name here;User ID=sa;Password=password here"
set rs = Server.CreateObject("ADODB.recordset")
sql="SELECT * FROM T_ProgramGuests WHERE GuestID > 1"
rs.Open sql, conn
%>
<table border="1" width="100%">
<tr>
<%for each x in rs.Fields
response.write("<th>" & x.name & "</th>")
next%>
</tr>
<%do until rs.EOF%>
<tr>
<%for each x in rs.Fields%>
<td><%Response.Write(x.value)%></td>
<%next
rs.MoveNext%>
</tr>
<%loop
rs.close
conn.close%>
</table>
<p>Company Program Archive<left><HR align="left" WIDTH="50%" SIZE="1" NOSHADE>
</left>
<strong><u>Article Title</u></strong><br />
3/7/2007
<br /><br />
<strong>Trust in Cyberspace<br />
</strong><br />
Your reputation follows you, even into cyberspace. Online reviews, peer comments
and user opinions are changing the way we decide to trust other people. Technology
reporter John Doe sees current website ratings leading the way to a new
standard of social acceptance.</p>
</body>
</html>
I'm doing something wrong here but I'm not sure exactly what I'm missing. Is my SQL connection statement wrong? Or is it a syntax issue? Any suggestions?
View 2 Replies
View Related
Jun 14, 2007
Hi Y'all,
When i alter 1 single value in my sql server 2000 sometimes i get following error:
1) [MICROSOFT][ODBC SQL SERVER DRIVER] Communication link failure
After clicking away:
2)CANNOT START MORE TRANSACTION ON THIS SESSION
Maybe someone can help me out on this?
Thanks!
View 1 Replies
View Related
Jan 7, 2004
I am trying to install MSDE using settings I always have to install it:
setup sapwd=password instancename=vsdotnet disablenetworkprotocols=0 securitymode=sql
But it gets through the install, then the progress bar goes backwards and it uninstalled, I tried to enable logging and do /q+ but none of this gives usable information, i have redownloaded the MSDE SP3 install files and this has changed nothing, I know this is a common problem as I have seen a few sites mention it, but i can't seem to find the fix.
View 5 Replies
View Related
Apr 25, 2007
Hi,
I am running transactional replication between a pair of SQL Server 2005 machines using a remote distributor. Occasionally the log reader agent fails with the error
"Replication-Replication Transaction-Log Reader Subsystem: agent * failed. The process could not execute 'sp_MSpub_adjust_identity' on '*'."
The agent starts back up again almost immediately on its own with seemingly no problems. I haven't been able to find any documentation on this error from Microsoft. Any ideas?
It is not a permissions issue as the log reader agent (and all of the other agents at that) are running under windows accounts with domain admin access for the domain that both the publisher and the distributor SQL Servers are on. (I know, I know, that's horrible. I've only been here a week and a half and I just found out about this today, so I didn't have anything to do with such a glaring security issue.) All of the SQL Servers involved with the replication are still granting sysadmin access to the windows administrators group.
View 1 Replies
View Related
Aug 10, 2005
I have not been able to find any details about backup failures forMSSQL 2000. I am researching the following:1. when a backup fails at a certain point during the process does thebackup:A. stop there having recorded some details?B. quit without backing up any of the data it already processed?C. skip the data it cannot read and move on?2. Does the error log record any of the details above? For instance, ifthere is a table that the backup could not write to .bak, does theerror log report exactly where the error was?I need a way to obtain a Backup Exception 'Report' that when a backupfails it can tell me what did not get into the .bak file. I wouldprefer automatic notification. Our Oracle DBs have something setupthat can be run when a piece of the DB does not get backed up lettingthe Oracle DBA know where there are issues.Thank you,Stephanie
View 1 Replies
View Related
Oct 12, 2006
Hi,
I am using ADO in my application to connect and retrieve data from Microsoft SQL Server 2000 SP4. When I start my application, it establishes connection to the server successfully and I am able to retrieve data from the server. here is my test scenario:
1. unplug the network cable from the client machine and put the cable back in after some time. I disconnect from the database in my code when the client machine disconnects from the network
2. Once the client machine comes back on the network, I try to reconnect and retrieve data from the sql server but I get the following error message when I try to execute a sql command:
[Microsoft][ODBC SQL Server Driver]Communication Link failure
This problem occurs only with Window XP SP2. With XP SP1 it works fine. It seems to be problem on the client side as with Windows XP SP1 I do not get this error message at all.
Here are the various details:
1. The firewall is off on the client workstation.
2. the connection string is:
driver={SQL Server};server=AA;uid=BB;pwd=CC;database=DD
where AA = DNS name of server machine where sql server is running.
BB = user name
CC = password
DD= database name
3. The client is remote to the server.
4. I can ping the server machine when the client machine reconnects to the network.
5. I can still telnet the server when the client machine reconnects to the network.
6. client database provider is MDAC odbc.
7. the client and server machines are in the same domain.
8. Shared memory and TCPIP protocols are enabled and TCP is at the top of the list.
9. No alias is being used.
10. Viris scan is not installed.
11. force encriptioned is NOT checked.
Please reply.
View 12 Replies
View Related
Nov 19, 2007
Overview. I am converting over from MSDE to SQL Express. My front end program is unable to connect to the database. To troubleshoot, from the remote computer I tried connecting with the management program and I get the Error 26 unable to connect.
(The connection string worked previously (yesterday) when using MSDE as the server. When I installed SQL Express I named it the same instance as the server name under MSDE. I also use server authtication on both with same user name and password. As stated below I cannot connect using the managment console.)
Here is what I have done: I made sure that the SQL Server configuration has been changed to allow network connections (both TCP and named pipes). I have disable windows firewall on both machines. I confirmed that I can connect from the remote machined to the server by network browsing. Both machines are running XP Proff. There is no other security software running on either machine.
More Info. when attempting to log on I am using the server authntication, I use "sa" as the user id plus my password.
Goal. The front end of database program connects to the server remotely using a program called Hamachi over the internet. This works without a problem on MSDE. But for now I am simply try to connect using the managment program which lets you browse for other serves. When I do this it shows the remote computer, but not the name of the computer but not the SQL server which I type in like the following: "INTELsql1"
What I have not Done: I have not changed any permissions or added any users to the server, since this does not seem necessary. As stated the user of remote machine can connect to the server and change files.
Would appreciate any suggestions or tips. Thanks.
I HAVE READ THE POST FROM MAY 13, 2007 AND TAKEN ALL STEPS SUGGESTED EXCEPT MAKING SURE THE BROWSERS SERVICE IS RUNNING ON SERVER WHICH I WILL DO NOW.
View 2 Replies
View Related
Dec 21, 1999
I have started to see regular occurences of "ODBC error 40001- serialization failure" in the log of a client website (using cold fusion) and would be grateful for any suggestions on likely causes and solutions. The error message also mentions deadlock victims. Thank you in advance.
View 1 Replies
View Related
Aug 16, 2004
In my DTS package, is there any way to pass the task name and error description to another task that gets called on the task's failure?
View 1 Replies
View Related
Apr 11, 2008
Hello,
I'm looping through a set of IP's (sql servers), i'm changing the property ServerName for OLE DB connection dynamically.
So, I'm having a DataFlow Task inside a For each Task.
Data Flow task has OLE DB Source & OLE DB Destination. I've set ServerName of OLE DB Source to a variable which gets updated by For Each Loop.
Till now everything is working fine. However, if a Server (IP) is down it causes OLEDB Source to give an error.
So in my case, if one server is down, it gives error and does not proceed further. I want it to continue with other
servers.
How do i error handle this ?
Thank You,
Sandeep.
View 4 Replies
View Related
Oct 26, 2007
Hi,
I have system with SQL Server 2K5 SE 3042 SP2 . I was able to set up mirroring with primary-mirror-witness arrangement through GUI.
In this company I replaced another DBA who left, and the way our sys admin arranged our logins co-existed in domain for a while. Then sys admin, after mirroring was done, removed my login, renamed other DBA's login with mine, and removed his.
Now I cannot create endpoint, either by t-sql or through GUI: "An implicit login creation has failed. Reason: the login may have been dropped or its name may already be in use, error 1545".
After pressing Start Mirroring the following shows: "Database Mirroring Transport is disabled in the endpoint configuratin, error 1486". The 2nd error understandable in view of the 1st one.
I checked sys.database_mirroring_endpoints, it is empty. Anyone has an idea what this implicit login is, and where to look for it?
Vladimir Kievsky
View 6 Replies
View Related
Aug 7, 2006
my project is insert data to OLE DB destination from csv file.
my question is
how can I get the row number(error row) while constraint failure at the OLE DB destination?
thanks.
View 6 Replies
View Related
May 29, 2001
My SQL 7 is on RAID 5. Sometimes on non-peak hours, on RAID disks first
two lights ( from left ) are constantly on for hours. NT Task manager, nothing
unusual, SQL current activity - no running user processes. Isn't second light
on RAID comes on if any disk activity ( Read/Write ).
Suggestions are appreciated.
Thanks,
Ivan
View 2 Replies
View Related
Sep 28, 1998
I`ve tried implementing NT Software Raid / Stripping with Parity
and am unable to stripe disc that are more than 2g and
use SQL. I have not found any info in technet. Any ideas! Thanks.
View 2 Replies
View Related
Dec 20, 1998
Should one install RAID 5 for SQL Server or just use separate hard drives, one for the data and one for the transaction log?
View 4 Replies
View Related
Apr 15, 2008
could any one tell me about the difference between RAID and SHARED DISK ARRAY
View 3 Replies
View Related
Jul 20, 2005
Hi,I was going to buy a server with Raid 1 as I thought that it meant that ifone of the two mirrored drives fail, you simply take it out and put a newone in. At which point presumably the hardware takes over and copies theother drive over to mirror it again.However, my sql server admin book, says raid 1 is bad, as it means you havelots of downtime, when recovering from a broken drive.Can anyone give me some advice on this? What is the best Raid to use whenyou are running SQL server on the server.ThanksJJ
View 1 Replies
View Related
Sep 22, 2004
We get this error constantly...
24.121.0.118, Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322), ODBC Error Code = 40001 (Serialization failure) [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 56) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Any ideas? Would setting the isolation level to Read Commited help?
View 1 Replies
View Related
Nov 22, 2007
Hi Folks,
This is regarding the intermittent failure of communication between the application server and database server in one of our customer environment. Application error as well as SQL error log shows "General Network Error","Communication Link Failure". Please find below the server configuration
Application Server OS: Win 2003 server + Service Pack1, Standard Edition
Database Server OS: Win 2003 server + Service Pack1, MS SQL Server 2000 + SP4
We have checked the Client/Server Network utility associated with SQL Server and found TCP/IP protocol is used in communication neither than Named Pipes. DSN is used. We have also followed and implemented as per one KB article which mentioned Win 2003 server's feature of preventing Denial of Service attacks (Chance may be there to prevent the valid login packets).We made the registry changes and disabled this feature. A scheduled job which updates the database happens every morning. Also backup was done using a backup utility which needs the exclusive access to DB. So we have asked the customer to use enterprise manager for back up the DB instead of using the other utility to backup. If any one have experienced the same issue, please let me know.
Thanks,
Pranav.
View 2 Replies
View Related
Apr 21, 2008
Hi!
I've a computer with W2K SP4 installed. Previously SQL Express 2005 worked but according to the user it "just stopped working".
When selecting database on the server in the "Data Link Properties"-window he is given the following error message:
"Microsoft Data Link" "Login failed. Catalog information cannot be retrieved"
followed by
"Microsoft Data Link Error" "Connection failure"
Note: He is not given the error message "Server does not exist or access denied!"
- The SQL service is started (can be stopped and restarted without problem)
- I've re-installed SQL Express.
- I've checked and is certain the server name is correct (i.e. computernameSQLEXPRESS)
Any ideas here because I'm getting desperate?
Thanks in advance,
Peter Hartlén
View 7 Replies
View Related
Dec 29, 2006
Can some one help me with this ?
C:WINDOWSsystem32Odbc32.dll
Version:
3.525.1117.0
SQL_SUCCESS_WITH_INFO (1) in OdbcConnection::connect
sqlstate=01000, level=-1, state=-1, native_error=444, msg=The driver returned invalid (or failed to return) SQL_DRIVER_ODBC_VER:
sqlstate=01000, level=-1, state=-1, native_error=5701, msg=[Microsoft][SQL Native Client][SQL Server]Changed database context to 'master'.
sqlstate=01000, level=-1, state=-1, native_error=5703, msg=[Microsoft][SQL Native Client][SQL Server]Changed language setting to us_english.
SQL_ERROR (-1) in OdbcConnectionHandle::set_attr
sqlstate=IM001, level=-1, state=-1, native_error=0, msg=[Microsoft][ODBC Driver Manager] Driver does not support this function
SQL_ERROR (-1) in OdbcConnectionHandle::get_attr
sqlstate=IM001, level=-1, state=-1, native_error=0, msg=[Microsoft][ODBC Driver Manager] Driver does not support this function
SQL_ERROR (-1) in OdbcHandle::release
sqlstate=HY010, level=-1, state=-1, native_error=0, msg=[Microsoft][ODBC Driver Manager] Function sequence error
SQL_ERROR (-1) in OdbcHandle::release
sqlstate=HY010, level=-1, state=-1, native_error=0, msg=[Microsoft][ODBC Driver Manager] Function sequence error
Error Code: 0x8007ea74 (60020)
Windows Error Text: Source File Name: libodbc_handle.h
Compiler Timestamp: Wed Oct 26 16:37:41 2005
Function Name: OdbcConnectionHandle::set_attr@connect
Source Line Number: 168
---- Context -----------------------------------------------
Connecting to SQL Server
ExecuteSqlCommands
Originial error was 8007ea74 (60020)
ipt
SqlScriptHlpr
Error Code: 60020
MSI (s) (D0!0C) [18:24:47:187]: Product: Microsoft SQL Server 2005 Express Edition -- Error 29521. SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][ODBC Driver Manager] Driver does not support this function. Refer to the server error logs and Setup logs for detailed error information.
View 1 Replies
View Related
Sep 13, 2001
Im setting up a hardware raid 5 solution for one of our db servers. The data files will reside on the stripe. We dont realy want to raid more drives for the Transaction log if its not nessesary. If the drive with the log crashes is the data file for the database useless ?
View 1 Replies
View Related
Nov 29, 2005
Hi guys,
On a new server with 4 disks, what level of raid is best to apply. In terms of what's important, I'd say speed is at the top of the list.
BJ
View 1 Replies
View Related
