Backups Fail: Server: Msg 3013
Sep 19, 2000
For some reason my backups (Transaction log and full backups) have started failing. When looking at the job histoy for the step that failed it reports:
*****(0.011 MB/sec). [SQLSTATE 01000] (Message 3014) Backup, CHECKALLOC, bulk copy, SELECT INTO, and file manipulation (such as CREATE FILE) operations on a database must be serialized. Reissue the statement after the current backup, CHECKALLOC, or file manipulation operation is completed. [SQLSTATE 42000] (Error 3023) Backup or restore operation terminating abnormally. [SQLSTATE 42000] (Error 3013). NOTE: The step was retried the requested number of times (3) without succeeding. The step failed.*****
I have tried running the SQL for the step manually and I get:
Backup, CHECKALLOC, bulk copy, SELECT INTO, and file manipulation (such as CREATE FILE) operations on a database must be serialized. Reissue the statement after the current backup, CHECKALLOC, or file manipulation operation is completed.
Server: Msg 3013, Level 16, State 1, Line 36
Backup or restore operation terminating abnormally.
The step is only determining what day of the week it is and putting it in to a '@bkupday' variable then: "BACKUP LOG [model] TO @bkupday WITH NOINIT , NOUNLOAD , NAME = N'Model Log Backup', NOSKIP , STATS = 10, DESCRIPTION = N'Model log backup', NOFORMAT" for each database and log.
This had been working fine, but for some reason has now started playing up. (trying to workout wether this ties in with when I started merge replication of one of the DBs)
Any one got any ideas as to what might be causing this as it's happened for a couple of nights now?
Cheerz.
View 2 Replies
ADVERTISEMENT
Jan 6, 2004
Hi, I have a scheduled maintenance plan that backs up my database (SQL 2000). The db is 108 Meg. Usually the backup files are around 89 Meg and the transaction log backups are around 4.5 Megs.
The problem is that every once a while the backup fails with the following error:
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3202: [Microsoft][ODBC SQL Server Driver][SQL Server]Write on 'C:Program FilesMicrosoft SQL ServerMSSQLBACKUPCRM_db_200312230100.BAK' failed, status = 112. See the SQL Server error log for more details.
[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is terminating abnormally.
What usually happens is that the last backup that has failed has a size of 9 or 8 Gigs!
My guess is that a backup file gets corrupt (the size increases to 8 Gigs) and the server runs out of space and won’t be able to do more backups. However I can’t figure out why the backup file size increases to and gets corrupt.
Can anyone help me?
View 4 Replies
View Related
Jan 14, 2008
My tape backups have started failing, due to time out errors.
I noticed that if I try restore headeronly from the tape drive I also receive a backup error.
I'm thinking that it could be the tape drive HP DAT 72 but thought I'd ask if anyone had any other suggestions.
This is the command I'm running: RESTORE HEADERONLY FROM TAPE = '\.Tape0' WITH NOUNLOAD
I am greeted with this result:
********************************
Msg 4027, Level 16, State 1, Line 4
Mount tape for RESTORE HEADERONLY of database '' on tape drive '\.Tape0'.
Msg 3229, Level 16, State 1, Line 4
Request for device '\.Tape0' timed out.
Msg 3013, Level 16, State 1, Line 4
RESTORE HEADERONLY is terminating abnormally.
**************************************
It doesn't happen all the time, but roughly half the time the backups fail.
If I go to the Computer Manager then Storage--> Libraries --> Hewlett Packard DAT 72 (my tape drive) it shows the Red X over the drive.
It lists it as an off-line library.
Any thoughts on this?
View 2 Replies
View Related
Jul 14, 2006
Running SQL Server 2005 Standard Edition.
Database is in Full Recovery mode.
I have full backups scheduled weekly, differentails scheduled daily and tran log ackups scheduled for every 15 minutes.
The tran log backups only work for the first 40 minutes or so after the daily backup. Once the daily has occured, the tran backups will work again, but for only 40 minutes.
I run consistency checks on the db daily and there are no errors.
The error returned from the tran log backup is 'BACKUP LOG cannot be performed because there is no current database backup'
Any thoughts would be appreciated.
View 4 Replies
View Related
May 26, 2008
Hi,
I run 2 steps viz with NORECOVERY and with RECOVERY in sequence as SQP jobs. The 2nd step fails some times. When it starts failing, I run full backup of the production server again and the 2nd step starts succeding. Unless I run the full backup the 2nd step keeps on failing.
What are the conditions which generate for [SQLSTATE 42000] (Error 3013) and how to tackle this problem.?
The 2 steps are :-
1.RESTORE DATABASE ARSYSTEM
FROM DISK = 'E:SQL backup from productionsql_full_backup'
WITH
Replace ,
MOVE 'arsystem' TO 'd:ardataarsystem.mdf' ,
MOVE 'arsystem_log' TO 'D:ARLOGARsystem' ,
NORECOVERY
GO
2.RESTORE DATABASE ARSYSTEM
FROM DISK = 'E:SQL backup from productionSQL daily diff back up'
WITH
Recovery
The status of the 2 steps is :
1 Executed as user: BPOTESTREMEDY
emedybackup. Processed 104480 pages for database 'ARSYSTEM', file 'ARSystem' on file 1. [SQLSTATE 01000] (Message 4035) Processed 1 pages for database 'ARSYSTEM', file 'ARSystem_log' on file 1. [SQLSTATE 01000] (Message 4035) RESTORE DATABASE successfully processed 104481 pages in 49.452 seconds (17.307 MB/sec). [SQLSTATE 01000] (Message 3014)
2. Cannot apply the backup on device 'E:SQL backup from productionSQL daily diff back up' to database 'ARSYSTEM'. [SQLSTATE 42000] (Error 3136) RESTORE DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.
View 3 Replies
View Related
Nov 15, 2015
The space allocated to the Log in question is 180 GB. During this time period I was running TLog backups every 5 minutes, yet the log continued to chew through to 80 GB used, even after the process was complete and a final TLog backup had been taken. It continued to stay very large until the Full backup was complete -- or something else that I'm unaware of completed. Like every other DBA I typically take a TLog backup to shrink the log, but what appeared to be the case here was the Full completed and it released the used log space. All said, will Transaction Log backups not free up the log during Full backups?
View 3 Replies
View Related
Oct 24, 2007
Hello all,
I have tried to install SQL Server 2005 Standard edition with CLUSTERING. I faced a problem and everything rolls back.
TITLE: Microsoft SQL Server 2005 Setup
------------------------------
SQL Server Setup was unable add user domain1xyz to local group domain1IT Security Admin-Group.
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=29512&EvtType=sqlca%5csqlsecurityca.cpp%40Do_sqlGroupMember%40Do_sqlGroupMember%40x6ba
I have refered to PostI=1659185 posted by Fly and it still won't be able to fix my problem.
I have added LOCAL SERVICE into the local group (SQLServer2005MSFTEUser$AAA$MSSQLSERVER), but it still can't work.
Please can someone help me on this. Thank a lot....
View 6 Replies
View Related
Nov 14, 2006
I have searched and could not find an answer for this one I read log and it said
Starting Service ...
SQL_Latin1_General_CP1_CI_AS
-m -Q -T4022 -T3659
Connecting to Server ...
driver={sql server};server=KENSHIN;UID=sa;PWD=;database=master
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
driver={sql server};server=KENSHIN;UID=sa;PWD=;database=master
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
driver={sql server};server=KENSHIN;UID=sa;PWD=;database=master
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
SQL Server configuration failed.
how do I fix this?
View 7 Replies
View Related
May 10, 2008
I tried to install SQL Server 2005 (x64) Standard Edition on Windows Server 2003 R2 (x64) Standard Edition. My box meet the requirement. But I got the following error when the installing progress was just about to begin:
Error 1016:Could not access network location k.3643236F_FC70_11D3_A536_0090278A1BB8]URTVersio.
(this is exactly what i saw in the system log)
what does it mean?? i am totally confused...what the hell is the k.3643236F_FC70_11D3_A536_0090278A1BB8]URTVersio????
Can anybody give me a hand? thanks...
View 5 Replies
View Related
Jun 7, 2005
Hi!Currently we only have one SQL Server database in our production system. I would like to add one more SQL server 2000 database. I would like to configure them so that both server share the load and Failover. I did some research and I found that I can do this by installing the OS (Windows 2000 Server Enterprise Edition) and SQL 2000 Enterprise Edition on both machines using the windows clustering. I want both servers to be active. They both have a copy of the production data. What I don't know is that, if it is possible to synchronize the data on both databases using SQL Server Replication utitlites. From what I know one SQL Server must be Publisher and one Subscriber. Can one sql server be both? Because I want both sql server to be identical. Can I set up replication between more than 2 servers? We just need to add one server for now but I would like it to be expandable. In the future we may need more.So Please provide me some ideas and answers about the following.1- Can two SQL Server cross replicate (both update each other in order to be identical)?2 -Does replication work beyond 2 servers.?3- If you were to set up a production database; what do you recommend considering the load balancing and Failover using Windows 2000 Server Enterprise Edition and SQL Sever 20000 Enterprise Edition?Thanks,Michael
View 3 Replies
View Related
Apr 24, 2000
Background:
NT EE, MSCS, SQL 7.0 in Active/Passive environment. Add'l SQL installed on Passive server is hosting our Report database(any tips on Log Shipping?).
Anyway, I am unable to configure a client to connect to the secondary server via TCP/IP sockets.(Error 10061). I use the standard port 1433 and I've tried using both the name and the IP address for the server name.
What it looks like it's doing is only listening to port 1433 on the hearbeat nic. The reason I believe this is because when I ping the server name from that server, it returns a succesful ping, but using the heartbeat(seperate subnet)nics IP address.
Ping from a remote box works fine(DNS/Wins Resolution), and I connect fine with Named Pipes.
Both the primary and secondary server display the same results, the difference appears to be that only a virtual server in a clustered environment can have TCP/IP clients connect to it.
Can anyone verify this for me? Thanks a bunch...
MS says to go Active/Active and I am willing to do so, eventually.
Looking for a short term solution.
I'm not able to listen on a different port(again, appears only a Virtual server can).
Pete Karhatsu
View 3 Replies
View Related
Jul 9, 1998
I have a client that has a table that after recreating the database from scratch it has a table that can not drop one of the eight indexes. Has anyone seen something like that? What did you do?
Thanks,
Steven Dunker
View 1 Replies
View Related
Jan 3, 2007
Greetings,
First I am fairly new to SQL Server 2005 Clustering so this is why I was to see if any of you might be able to help me.
Are current setup is as follows:
CRM1 SERVER 2K3 R2 xxx.xxx.xxx.74
CRM2 SERVER 2K3 R2 xxx.xxx.xxx.75
HP MSA1000 xxx.xxx.xxx.75
MSDTC IP xxx.xxx.xxx.77
SQL INSTANCE xxx.xxx.xxx.78
Now are CRM guys are trying to connect to xxx.xxx.xxx.78 for there SQL instance or RDP into this ip address and they can’t…Now the question is should they be able yto logon to the SQL Instance via RDP?
Thanks,
CujoX
View 3 Replies
View Related
Jan 8, 2007
Posted - 09/07/2005 : 15:32:52
--------------------------------------------------------------------------------
Hi, i need help about restore a DB
I did a backup of a database using SQL Server Management Studio, but when i try to restore my database now, i get this error:
TITLE: Microsoft SQL Server Management Studio
------------------------------
Restore failed for Server 'Athenas'. (Microsoft.SqlServer.Smo)
System.Data.SqlClient.SqlError: The media set has 2 media families but only 1 are provided. All members must be provided. (Microsoft.SqlServer.Smo)
What do i doing so bad??
Thanks for ur opinions and help.
Regards
------------------------------------------
seyha moth
View 8 Replies
View Related
Jun 18, 2007
Hi group,being pretty new to setting up sql server, I am stuck. Have installed sql 2000 server on Win 2000 server, IIS 5.0. I try to connect via ASP script that looks like this:<%Set Conn = Server.CreateObject("ADODB.Connection")ConStr = "PROVIDER=SQLOLEDB; DATA SOURCE=192.168.1.99"ConStr = ConStr & ";UID=someUser;PWD=somePassword" ConStr = ConStr & ";initial catalog=myDatabaseName;network library=DBMSSOCN"Conn.Open ConStrConn.CloseSet Conn = Nothing%>The IP number is the webserver my router points to on port 80.But get an HTTP 500 error and "The page cannot be displayed"Any suggestions as to what I am doing wrong here, would be very much appreciated.I have run applications for a long time that operate Access databases, but starting a new, an big project, forces me to upgrade to sql databases.Best wishesFCH
View 1 Replies
View Related
Nov 26, 2006
i installed sql server express, but i did not select to use mixed mode (the reason being for this that every time i did i got a install coruption error) i want to be able to connect the database remotly using the sqlservers jdbc driver. however i need a user name and password. therefore to do this i believe i need to be able to acess the database remotly.
ive tried everthing:
1. changing the surface area remote conenctions to allow remote connections using tcp and ip only
2. restarted the database
3. restarted the server
4. restarted the browser
5. checked the tcp/ip settings are enabled.
but when i do the follwing in command line i get this:
C:>osql -E
[SQL Native Client]VIA Provider: The specified module could not be found.
[SQL Native Client]Login timeout expired
[SQL Native Client]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.
which indicates that its still not allowing remote conenctions, any ideas?
View 4 Replies
View Related
Aug 2, 2007
I am working with the ssis packages.I am working in the development enviroment.Once i place them on the server all my connection to text files fails.I dont want to sit and Keep changing with respect to server again and again.
What is the best way to set connection like for example:in my development it can be on e:data folder
But on server F:Data
With me changing again and again, can this be set within the package in the development environment.
Please le me know.
View 4 Replies
View Related
Feb 18, 2008
Hi everyone
i get an error messgae running the following code
DECLARE @mailist VARCHAR(max)
SET @mailist=''
SELECT TOP 1 @mailist=@mailist + email +';'
FROM
email.dbo.mytable
SET @mailist=STUFF(@mailist,LEN(@mailist),1,'')
SET @mailist='''' + @mailist + ''''
EXEC msdb.dbo.sp_send_dbmail
@profile_name='my_mail_profile',
@recipients=@mailist,
@subject='mysubject',
@body_format='html',
@body=
'
<html>
<head>
<title>
problems with send_dbmail
</title>
</head>
<body>
this is not working
</body>
</html>
'
The error says:
quote:
Syntax error in parameters or arguments. The server response was: 5.5.4 Invalid Address)
At the other hand, if i assign a straightforward @recipints address such as
EXEC msdb.dbo.sp_send_dbmail
@profile_name='my_mail_profile',
@recipients=my@mail.com
It works
Anybody know why ?
Thanks
View 11 Replies
View Related
Sep 27, 2007
Hi,
A few months ago, I was trying to install SQL Server 2005 SP2 on a cluster (Active-Active), the Cluster has 3 instances, 2 lives in one node and the other one in the other node. When I try to make the deployment an error message appear, I do not have the error right now but it€™s something like €œCould not connect to the passive node, installation failed€?. The worst part of the error was all instances shut down and I couldn€™t bring on line and I have to reinstall all instances. I need to install SP2 but I€™m a little afraid fail again. Do you know the best way to deploy the SP2 on a cluster? Maybe move all instances in one node before install SP2? Can you help me with your comments. Do you think I have problems with the windows cluster?
Thanks and Regards,
View 3 Replies
View Related
May 16, 2006
Hi all,
When i attempted to connected to Microsoft SQL Server 2005 Express via ASP.NET 2.0 application, it seems to throw the following error.
I had set up the Protocols for Express (TCP/IP and Named Pipes are both enabled) to allow remote connections using both TCP/IP and named pipes.
Login failed for user ''. The user is not associated with a trusted SQL Server connection.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Login failed for user ''. The user is not associated with a trusted SQL Server connection.
Source Error:
The source code that generated this unhandled exception can only be shown when compiled in debug mode. To enable this, please follow one of the below steps, then request the URL:
1. Add a "Debug=true" directive at the top of the file that generated the error. Example:
<%@ Page Language="C#" Debug="true" %>
or:
2) Add the following section to the configuration file of your application:
<configuration>
<system.web>
<compilation debug="true"/>
</system.web>
</configuration>
Note that this second technique will cause all files within a given application to be compiled in debug mode. The first technique will cause only that particular file to be compiled in debug mode.
Important: Running applications in debug mode does incur a memory/performance overhead. You should make sure that an application has debugging disabled before deploying into production scenario.
Stack Trace:
[SqlException (0x80131904): Login failed for user ''. The user is not associated with a trusted SQL Server connection.]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +734883
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838
System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +359
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.SqlClient.SqlConnection.Open() +111
ASP.sqlquerytool_aspx.Button_Click(Object s, EventArgs e) +49
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +105
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +107
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102
I have been battling with error for 5 solid hours. Please help me
thank you in advance
View 1 Replies
View Related
Dec 19, 2007
I developed a intranet web application that stores about 1000+ new entries into a SQL Server database over the course of about a half hour. This runs 24/7 so its a very busy application. SQL Server is running on a server with a RAID 5 array which runs very good but I want to better guard against data loss. If I run a backup at 8:00 AM and the roof falls on the server crushing and destroying it at 5:00 PM, we just lost thousands of records that were made between 8am and 5pm that cannot be replaced.
I was thinking of adding a second server so when an entry is made it would be stored on both servers. The second server would be located at a different location so if 1 gets crushed we could just pick up where we left off and I wouldn't have to update my resume.....
Does this sound like a good idea or could anyone recommend a better solution?
Thanks in advance.
View 6 Replies
View Related
Feb 8, 2006
Is it possible to backup a remote SQL Server database to my local system? It is not working for me as I'm getting error as given below
Cannot open backup device 'path'. Device error or device offline
Any idea??
View 3 Replies
View Related
Nov 2, 2000
Does anyone know how to get SQL Server to see a network drive for backups? Even when trying to create a backup device on a network drive using UNC naming, SQL Server seems to have a problem with accepting it. If you browse for a place to put the device, only the local drive is accessible.
Please help. Thanks. John
View 1 Replies
View Related
Jun 23, 1999
I am working on a new SQL Server 7.0 system and have gotten to the issue of backing up and restoring the database. I am fairly new to SQL Server 7.0 and I am not sure how good the built in backup/resore is in SQL Server 7.0. The other optioin I have is Seagate Backup Exec which is currently being used for network backups.
Does anyone have any advide/information on this?
Thanks in advance.
Mike
View 4 Replies
View Related
Apr 13, 1999
Can anyone tell me some advantages/disadvantages to using ARCServe for
backups vs SQL Server 6.5 backup?
Thanks for the help!
Toni
View 1 Replies
View Related
Oct 27, 2004
Our e-business group will be running SQL Server as a backend and C#, ASP.NET, VB.NET application on the front end. Besides my enternal backups of user data on the database. What would you suggest for the Network team to backup and how offen. This is for productions. I usally get a full drive dump on the Dev network daily appended,and weekly archived. Any suggestion for production.
View 2 Replies
View Related
Jan 21, 2004
I have a job scheduled to backup a production database every night at 10pm. It will run fine for a number of days and then fail with the error:
Msg 3201, Sev 16: Cannot open backup device 'PCSLogisticsDB'. Device error or device off-line. See the SQL Server error log for more details. [SQLSTATE 42000] Msg 3013, Sev 16: BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] Msg 0, Sev 0: Associated statement is not prepared [SQLSTATE HY007] The backup set is valid. [SQLSTATE 01000]
When I go back and run it manually it works fine and then will run on it's own for a few more days. I've checked and File System backups aren't running at the time the backup kicks off. Has anyone experienced this?
View 3 Replies
View Related
Jun 2, 2015
I'm looking for an opinion on an architecture I'm thinking of rolling out.I have a HA cluster with 3 nodes:
Primary -- Main SQL Server
Failover -- Passive node, only used in DR scenario
Reporting -- Read Intent only queries directed here, SSRS.
I am pondering with the idea of balancing the backups out between 2 nodes as follow:
Primary: Full backup weekly, daily incremental.
Reporting: Log backups every 5 minutes.
I have tested that I can indeed restore the logs from the secondary node using the Full and Diff from the other server, no worries there.My concern is what will happen to the logs on the primary and fail-over server. Will they just grow, grow and grow?
View 5 Replies
View Related
Jul 20, 2005
Can SQL server handle High Availability or does it have to go downoccasionally for a cold backup? Does it support incremental backups?
View 4 Replies
View Related
Jul 20, 2005
I'm trying to create a backup set which maintains only a fixed number ofdays. As such, I've got the following script:BACKUP DATABASE [mydb] to [mydb Backup Set] WITH NOINIT, NOUNLOAD,NAME=N'My Database Backup', NOSKIP, STATS=10, NOFORMAT,RETAINDAYS=5DECLARE @i INTselect @i=position from msdb.backupset where database name='mydb'and type!='F' amd backup set id=(select max(backupset set id) frommsdb.backupset where database name='mydb')RESTORE VERIFYONLY FROM [mydb Backup Set] WITH FILE=@iThis script was created automatically, but I added the RETAINDAYS bit. Ionly want the past five days of backups available, but when I check thelist, I've got backups dating back to December 2003! The older backupsare correctly being marked as expired, but they are still on the list!How can I purge the list to only have the last five days of backups?Thanks in advanceJohnny
View 1 Replies
View Related
Jul 23, 2005
I have a SQL Server job, which runs mutiple steps. One of the steps(step 3) looks for a record in the database. How can I explicitly failthe SQL server job if the database record does not exist?
View 2 Replies
View Related
Jul 20, 2005
We have SQL Server 2000 Standard and recently moved from Exchange 5.5to Exchange 2003. This problem occurred both before and after thee-mail change.We would like to send notifications of failed jobs to multiple peoplein case one person happens not to be in on the day there is a problem.Setting up an operator with an e-mail name that combines twoaddresses seems to work ok as long as we use a format like thefollowing:smith_john; jones_maryorJoin Bytes!; Join Bytes!However, when we add a third name, we start getting problems. Thefirst and third accounts listed get the message but the second onedoes not -- apparently because the address gets corrupted. Forexample (based on the message received at one of the good addresses),a message sent to:Join Bytes!; Join Bytes!;Join Bytes!goes to Smith and Jackson successfully but Jones' address is corruptedto:Join Bytes!omand, of course, fails.From some other testing, it appears that the last three characters ofthe first address always get appended to the end of the secondaddress.Has anyone else run across this? If so, is there a known fix? I hadhoped Exchange 2003 would fix the problem. Most likely, we will trysetting up a personal distribution list under the account from whichthe messages are sent. I just wanted to give one more shot to findingthe problem -- both because I would like to know and because beingable to string together addresses is a little easier than having to gothrough the person who can give us access to the account to set thePDL.Thanks.Jonathan LevyChicago Department of Public Health
View 1 Replies
View Related
Feb 12, 2009
We get the below error while performing a distributed transaction on linked server. We have several linked servers configured in the source server and all of them succeed with the distributed transaction except on one.
Â
We did all the basic troubleshooting and moreover the distributed transactions work fine if we use a remote server instead.
Error:
OLE DB provider "SQLNCLI10" for linked server "SERVERNAME.REDMOND.CORP.MICROSOFT.COM" returned message "No transaction is active.".
Msg 7391, Level 16, State 2, Line 3
The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server "SERVERNAME.REDMOND.CORP.MICROSOFT.COM" was unable to begin a distributed transaction.
Â
 Test code:
begin distributed transaction
select top 10 * from [SERVERNAME.REDMOND.CORP.MICROSOFT.COM].master.sys.objects
 ROLLBACK
Â
Source server : Â Â
Microsoft SQL Server 2008 (RTM) - 10.0.1779.0 (X64)
      Nov 12 2008 12:10:04
      Copyright (c) 1988-2008 Microsoft Corporation
      Enterprise Edition (64-bit) on Windows NT 6.0 <X64> (Build 6001: Service Pack 1) (VM)
Â
Target server : Â Â
Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86)
      Jul 9 2008 14:43:34
      Copyright (c) 1988-2008 Microsoft Corporation
      Enterprise Edition on Windows NT 5.2 <X86> (Build 3790: Service Pack 2)
View 30 Replies
View Related