Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.








Sponsored Links:

Related Messages:
Robocopy SQL Server Directory
I am in the process of creating a VM server which serves as a backup for a production SQL server. the SQL server has SQL directory installed on C: and F: partitions. Sql installation files reside on C: while MSSQL directory (include backup, logs, data, etc.. ) reside on F:. The VM was created by cloning of the original (production) server but only C: partition. I need to use robocopy to copy the MSSQL directory from original sql (F:) server to the VM (F:). My questions are:

1. will doing it this way mess up database integrity on the VM?
2. What should I check to ensure installed filed registered to the new VM server instead of the original sql server?
3. what switches of robocopy should be used to produce exact copy of the MSSQL folder from original server to the VM
4. the current database is about 1GB, how long the robocopy may take?

If you have experienced this before, please share your thoughts, suggestions, ideas. Very much appreciate your feedback.

Thank you

View Replies !   View Related
Copy Bak, Trn Files To File Server With Robocopy.
I need help with better solution to copy my bak and trn files to a file server. This is the background. I use to dump the backup files directly to the file server; this was not €œbest practices€? according to some books and forums.  Back to dump the file first to local disc and after that letting robocopy copy the files to the file server. And I end up with this problem.


This is error from the backup log
Failed-1073548784) Executing the query "BACKUP DATABASE [BPROJCT] TO  DISK = N'F:\backup\BPROJCT\BPROJCT_backup_200711281700.bak' WITH NOFORMAT, NOINIT,  NAME = N'BPROJCT_backup_20071128170005', SKIP, REWIND, NOUNLOAD,  STATS = 10
" failed with the following error: "Write on "F:\backup\BPROJCT\BPROJCT_backup_200711281700.bak" failed: 112(There is not enough space on the disk.)


This is the error from the robocopy log
New File                                               0                    BPROJCT_backup_200711201700.bak
2007/11/20 17:02:11 ERROR 32 (0x00000020) Copying File F:ackupBPROJCTBPROJCT_backup_200711201700.bak
The process cannot access the file because it is being used by another process.
Waiting 30 seconds... Retrying...


Robocopy tries to copy the file before its completely written to disk. I have made a batch file that looks like this
robocopy



"F:ackup" "\sefwg-sqlbackackupACON" *.* /MIR /TBD /MON:1 /MOT:5 /LOG+:"F:ackupackup.log" /NP


Monitor the file folder and copy all files every 5 min, the file is started with scheduled Task.
Have I missed some switch? Can start robocopy from SQL Serer Agent in a xp_cmd_shell?

View Replies !   View Related
Package Fails When I Use ODBC Connection (Fails On SQL Server Agent, OK In Visual Studio)
I did a small package with only one ODBC connection (Merant 3.70 32-Bit Progess).  This package runs well in Visual Studio and fails when runs by SQL Server Agent.

Configuration:

SQL Server Agent on a 32Bit server. 

The ODBC connection configuration in available on System DSN on this server.

The user of Server Agent have full access (Admin).

Connect Manager Provider: ".Net ProvidersOdbc Data Provider"

SQL Server version: 9.0.3042

 

Error Message:

Executed as user: TEKCON cadmin. ...ion 9.00.3042.00 for 32-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Started:  16:50:33  Error: 2007-06-11 16:50:33.62     Code: 0xC0047062     Source: Data Flow Task DataReader Source [1]     Description: System.Data.Odbc.OdbcException: ERROR [HYC00] [MERANT][ODBC PROGRESS driver]Optional feature not implemented.  ERROR [HY000] [MERANT][ODBC PROGRESS driver]msgOpen: unable to open message file: PROMSGS  ERROR [IM006] [MERANT][ODBC PROGRESS driver]Driver's SQLSetConnectAttr failed.  ERROR [HYC00] [MERANT][ODBC PROGRESS driver]Optional feature not implemented.  ERROR [HY000] [MERANT][ODBC PROGRESS driver]msgOpen: unable to open message file: PROMSGS  ERROR [IM006] [MERANT][ODBC PROGRESS driver]Driver's SQLSetConnectAttr failed.     at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)     at System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection connection, OdbcCon...  The package execution fa...  The step failed.


I created a .bat file with this instruction and It's run well:

dtexec /f "C:Program FilesMicrosoft SQL Server90DTSPackagesIntegration Services Project estcom.dtsx"
pause

Why it's not running with SQL Server Agent???

View Replies !   View Related
Standard Edition Fails To Install, Express Edition Fails To Uninstall
We are trying to install the Standard Edition of SQL Server 2005. We already have SQL Express installed. Standard won't install and Express won't uninstall.

We have tried every suggestion we can find and some we made up. When we try to install Standard, we get to the bit where you choose what you want to install and the only thing available is workstation components.

There are so many cases of this on the Internat that I can't believe MS have not solved the issue. And I am stunned that they want to charge us more money to talk to us about how to fix something we just paid them an arm and a leg for!

What do I need to tell you to get some idea of where to go next with this?

View Replies !   View Related
Job Fails
Hi all,

Sql server 7



I have created a Web assistant job which select
and displays data from a table (very small amt of data)
on to the webpage. the job is schedule to run
every 1 minute. the job is not running, in job view
history its gives the error msg
"could not open the output file" 16821 Error no.

pls suggest
Awaiting for ur reply


TIA
Adil

View Replies !   View Related
Job Fails
I have a DTS job that runs every hour.
it truncates destination table and copies from the source table.

it has failed with the following error in view job history

"error-214721900(80040E14);provider error 14262.(37B6)"
error source Microsoft ole db provider error
pls help in this

how can i solve this, i tried restarting the job but its failing again.

View Replies !   View Related
DTS Fails
Good Morning,

I've been running into a small problem. There are two people that usually create local packages to be executed by the DTS. Either my boss or I. The problem that I have been running into is, there are some local packages that will not execute when I try to run them. These packages are that my boss has created. When she runs them they work fine. But when I run them they just don't run. The only way I can run the local package is if I log in into the server and run it from there.

The error that I keep getting is:

Unspecified Error
[Microsoft][ODBC Driver Manager] Data Source Name not found and no default driver specified.

What would I be able to do so that I can execute this local package from my computer?

View Replies !   View Related
SQL 6.5 BCP Job Fails In SQL 7.0
I hace BCP job that ran fine on SQL 6.5.
However since upgrading to SQL 7.0 the job
fails with a error,
'Right trucation of the last column of data.'and BCP in fails.

I checked the data and that's fine. So is the
format file. Nothing has changed with the job
either.

Does the SQL 7.0 BCP behave differenty and therefore
changes are required to 6.5 BCP jobs?

Ranjit

View Replies !   View Related
DTS Fails
Hi,
I have suddenly run into a problem. I have a DTS which was running well till few days ago. Now when ever it runs, it crashes the server, any body
have any idea why???


Thanks in Adv.
Nirmal

View Replies !   View Related
Job Fails
Hey guys,

I'm trying to run a job that will convert a load of data but it keeps failing at the first step. If I run the scripts in each step on their own then they run fine. The error message I get is 'The process did not produce any output. Process exit code 1. The step failed'. I think this may be some kind of security problem but I cannot see where. The command I'm using for the first step is as follows:

OSQL -SCRLONSQL01 -DINPRO -Usysadm -Pcarpmaels -i"C:Program FilesCPA Inpro DatabaseScriptsdropinteg.sql" -o"C:conversionoutputdropinteg.txt" -n

Any pointers would be most helpful.

View Replies !   View Related
SMO Fails On One Not Another
Can anyone enlighten me on using smo backup with sqlexpress?
I have compiled an exe using vbc running the folloing code
Imports System
Imports Microsoft.SqlServer.Management.Smo
Imports Microsoft.SqlServer.Management.Common
Imports System.IO

Module SMOtest
Sub Main()
Try
Kill(System.Environment.GetFolderPath Environment.SpecialFolder.ProgramFiles) & " estSMO_BACKUP")
Catch
End Try
Try
System.Threading.Thread.Sleep(500)
Dim bkpfileName As String = System.Environment.GetFolderPath(Environment.SpecialFolder.ProgramFiles) & " estSMO_BACKUP"
Dim backDeviceItem As New BackupDeviceItem(bkpfileName, DeviceType.File)
Dim db As String = "test" ' Define and set db
Dim bck As New Backup() ' Instantiate a Backup object
bck.Action = BackupActionType.Database ' Set Action
bck.BackupSetName = db & "_BackupSet" ' Set Backup
bck.Database = db ' Set Database name property
bck.Devices.Add(backDeviceItem)
Dim srv As New Server() ' Instantiate a Server object
bck.SqlBackup(srv) ' Invoke Backup object's SqlBackup method
Catch
End Try
End Sub
End Module

This works fine on a win2k dev system though when moving to another win2k system the code will error on non system databases. If db= model,master,tempdb etc it executes fine. When I try to backup a created db (any) I get an error stating the name is not found in sysdatabases.

SELECT name FROM master..sysdatabases
where name not in ('master','tempdb')

shows all the created databases including "test" in this case
keep in mind many recompiles using different db's work fine on one system and not the other. Even restored "test" from a backup from the system with no problems only to have a 3041 error consistently on the other. System databases work fine for all attempts on the offending system.
Any ideas? (the offending system is a SAT raid which has been evil from the get go) corruption seems to be the only conclusion I can reach

View Replies !   View Related
Job Fails
Hi,
I am trying to create a job to run a ssis package.
The job fails. Looking at the history log, there is no proper information on why the job failed. It just says: The job failed. The job was invoked by user ...
 
please note that the ssis package runs fine on it's own i.e. in the designer by pressing the run button.
Thanks
 

View Replies !   View Related
SQL Job Fails
I have a package which works fine when i ru if from VS but when i schedule it iam getting an error on one of the data reader source. I am not able to figure it why its giving error when its working fine from VStudio

 
Message
Executed as user: NAdbasvc-alticor. ... 9.00.3042.00 for 32-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Started:  11:28:25 AM  Error: 2007-07-10 11:28:26.21     Code: 0xC020838F     Source: Staging LKPDataReader Source [1]     Description: An error occurred executing the provided SQL command.  End Error  Error: 2007-07-10 11:28:26.21     Code: 0xC004706B     Source: Staging DTS.Pipeline     Description: "component "LKPDataReader Source" (1)" failed validation and returned validation status "VS_ISBROKEN".  End Error  Error: 2007-07-10 11:28:26.21     Code: 0xC004700C     Source: Staging DTS.Pipeline     Description: One or more component failed validation.  End Error  Error: 2007-07-10 11:28:26.21     Code: 0xC0024107     Source: Staging      Description: There were errors during task validation.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  11:28:25 AM  Finished: 11:28:26 AM  Elapsed:  0.906 seconds.  The package execution fai...  The step failed.
 
has anyone come across same issue, help

View Replies !   View Related
Db Connection Fails In C#
I have this line of db connection code that works in vb.net but not in c#:
con = new ADODB.ConnectionClass(); //for vb.net I used ADODB.Connection() instead and it workscon.Open("Provider=SQLOLEDB;" + ConfigurationSettings.AppSettings["connectionString"]);
Error message:CS1501: No overload for method 'Open' takes '1' arguments
Searched the web but can't find the answer... Does anyone have a clue?

View Replies !   View Related
App_Data New DB Fails
Hello,I'm trying to create a new SQL Express database in VWD, and I get the error:  Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance.  The connection will be closed.What is this error all about?  I don't understand it.Thanks.

View Replies !   View Related
Login Fails
Hi all;

I am getting the following error when I try to connect to my local SQL server from my ASP.NET application

Server Error in '/pelin' Application.

Cannot open database requested in login 'pelin'. Login fails. Login failed for user 'sa'.

for other users also
my connection string is in web.config file:

<appSettings>
<add key="constr" value="server=ARGE057VSDOTNET2003;UID=sa;pwd=sa;database=Test;"></add>
</appSettings>

can you help me please thanks..

View Replies !   View Related
SQL Connection Fails
Hello,

I'm trying to get a handel on ASP.NET and I've put together a new SQL connection to display a view inside of a datagrid.

When I go to run it (before or after compile) I get the error:

------------------------------------------------------------------------------------------------------

Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection

Line 57: Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Line 58: Dim ds As New DataSet
Line 59: SqlDataAdapter1.Fill(ds)
Line 60:
Line 61: DataGrid1.DataSource = ds

Stack Trace:


[SqlException: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction)
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction)
System.Data.SqlClient.SqlConnection.Open()
System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState)
System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
jtio8.WebForm1.Page_Load(Object sender, EventArgs e) in c:inetpubwwwrootjtio8WebForm1.aspx.vb:59
System.Web.UI.Control.OnLoad(EventArgs e)
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Page.ProcessRequestMain()


--------------------------------------------------------------------------------


Here is the connection string I am using:

Me.SqlConnection1.ConnectionString = "workstation id=MyWorkstation;packet size=4096;integrated security=SSPI;data source=MyServer;" & _
"persist security info=False;initial catalog=Northwind"

-------------------------------------------------------------------------------

Now, I've created a new login to the SQL server using the ASPNET user id (as well as several others for testing), set up the premissions for each UID and I'm still getting this error.

I have also tried to setup the user info in the connection string by doing the following:

Me.SqlConnection1.ConnectionString = "user id=aspnet;password=;workstation id=MyWorkstation;packet size=4096;integrated security=SSPI;data source=MyServer;" & _
"persist security info=False;initial catalog=Northwind"

Any ideas?

Thanks,
Dale

View Replies !   View Related
Maintenance Job Fails
Hi there,Used the wizard to create a maintenance plan for a db. But it fails most ofthe time. I checked the log-files.At 1.00 AM, it runs the "Optimizations" job for 6-9 seconds. It succeedsalways.At 1.05 AM, for 1 second, it runs "integrity check", but most of the time itfails, and says that it couldn't switch to single-user because other usersare using the database.And when "integrity check" fails the "backup" job won't run at 1.10 AM. Whenit DOES run it takes 2 seconds.How do I find out who is using the database ? How do I put a sp_who (orsimilar) in the "integrity check" job ?I got this tip:----------Assuming you have SQL2000, then you can use something like this tokick out all the users:ALTER DATABASE foo SET RESTRICTED_USER WITH ROLLBACK IMMEDIATEIf you want to know who is using the database, then this is one way:select suser_sname(sid)from master..sysprocesseswhere dbid = db_id('foo')---------But how do I actually do it ? How do I edit a maintenance plan ?thx/jim

View Replies !   View Related
Registration Fails
For years I've had a server registration using sql server auth set up...now it's failing...can't be found not suthed BS...

I can still see mu other boxes in sql mode, and otyhers in mixed, and I can still see my remote boxes in Ireland and Pennysylvania...we're in NJ..

The person next to me does the same thing, had to reboot, but was fine.

I get ice in the winter...

bizzare-o world.

Any ideas?

Never seen anything like it...

I do know that our tech group has been doing some pushes lately...but I checked my settings and they seem fine..but why would I be able to see everything else but this one instance?

View Replies !   View Related
SQL Job Fails Running DTS Job
Hello,
I have a DTS job that retrieves data from a different server. When I manually run the DTS job, it executes fine, but when I run it from an SQL job it fails regardless of the owner I use to run the SQL job under.
I ran the same DTS package from another computer which has SQL client installed and it ran fine.
Does anyone know what could be the reason for failure when running the DTS job from the SQL job from the server?

Thanks,
Adrian.

View Replies !   View Related
Backup Job Fails
Hi all,

I have a MSDE Installed on my machine.
I want to set maintenance plans for backup and optioizations whih iam able to do. But it is failing with a message 'Failed executing API: CreateProcess. [SQLSTATE 42000] (Error 22029)'
Can anybody help?

thank you,

THOMAS

View Replies !   View Related
DTS Job Fails When Scheduled
I have a DTS local package that transfer data from the host SQL server to another. If I run the package directly (i.e. Right click - Execute Package) everything works as it should.

However, if I try and execute this as a Server Agent job it fails, the job history step details shows the following error:


Executed as user: MYSERVERNAMESYSTEM. ...: Drop table customer Step DTSRun OnError: Drop table customer Step, Error = -2147467259 (80004005) Error string: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 Error Detail Records: Error: -2147467259 (80004005); Provider Error: 17 (11) Error string: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 DTSRun OnFinish: Drop table customer Step DTSRun OnStart: Create Table customer Step DTSRun OnError: Create Table customer Step, Error = -2147467259 (80004005) Error string: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. Error source: Microsoft OLE DB Provider for SQL Server... Process Exit Code 2. The step failed.


Whilst this is obviously a connection issue, I dont understand how this can work if executed directly and not if executed as an agent job.

Can anybody shed any light on this?

If it helps this is the sequence of events my DTS package uses

1) Connect to remote DB
2) Drop table customers
3) Create new remote customers table
4) Connect to to local DB (hosting the DTS package)
5) Select * from local customers table
6) Dump data from local select into remote DB

View Replies !   View Related
DTS Works But Job Fails
Hi

I have a DTS to copy data from Oracle to SQL Server. When I logon to SQL Server box with a userID xxx, I can run the DTS from EM and it works perfectly fine but when I schedule the DTS as job, it fails.

SQL Server agent is running with same account "xxx"
DTS connects to SQL Server with sa authentication
Job owner is same account "xxx"

Job error log

Executed as user: DOMAINNAMExxx. ... Drop table [IFS_PROD].[dbo].[INVENTORY_PART] Step DTSRun OnStart: Drop table [IFS_PROD].[dbo].[PART_CATALOG] Step DTSRun OnStart: Drop table [IFS_PROD].[dbo].[SUPPLIER_INFO] Step DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish: Drop table [IFS_PROD].[dbo].[PART_CATALOG] Step DTSRun OnFinish: Drop table [IFS_PROD].[dbo].[INVENTORY_PART] Step DTSRun OnStart: Create Table [IFS_PROD].[dbo].[INVENTORY_PART] Step DTSRun OnStart: Create Table [IFS_PROD].[dbo].[PART_CATALOG] Step DTSRun OnFinish: Drop table [IFS_PROD].[dbo].[SUPPLIER_INFO] Step DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: Create Table [IFS_PROD].[dbo].[SUPPLIER_INFO] Step DTSRun OnStart: Create Table [IFS_PROD].[dbo].[SUPPLIER_INFO_ADDRESS] Step DTSRun OnFinish: Create Table [IFS_PROD].[dbo].[PART_CATALOG] Step DTSRun OnFinish: Create Table [IFS_PROD].[dbo].[INVENTORY_PART] Step DTSRun OnStart... Process Exit Code 6. The step failed.


I copied the DTS to another one and scheduled it

This time I got the error log
Executed as user: DOMAINNAMExxx. ...... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: Create Table [IFS_PROD].[dbo].[SUPPLIER_INFO_ADDRESS] Step DTSRun OnFinish: Create Table [IFS_PROD].[dbo].[SUPPLIER_INFO_ADDRESS] Step DTSRun OnStart: Copy Data from SUPPLIER_INFO_ADDRESS to [IFS_PROD].[dbo].[SUPPLIER_INFO_ADDRESS] Step DTSRun OnError: Copy Data from SUPPLIER_INFO_ADDRESS to [IFS_PROD].[dbo].[SUPPLIER_INFO_ADDRESS] Step, Error = -2147467259 (80004005) Error string: Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation. Provider is unable to function until these components are installed. Error source: Microsoft OLE DB Provider for Oracle Help file: Help context: 0 Error Detail Records: Error: -2147467259 (80004005); Provider Error: 0 (. The step failed.

Please help!
Thanks in advance

View Replies !   View Related
DTS Job Fails When Scheduled?
I have a DTS job that moves a text file from a workstation to the SQL server, transforms the data, pumps into a table and then archives the file. It runs fine within EM on the SQL Server, but once scheduled fails immediately on Step 1. I have logged the error as follows:

************************************************** **********
The execution of the following DTS Package succeeded:

Package Name: Load LaserGauge Data Daily
Package Description: (null)
Package ID: {6E4E8DDC-3864-43E9-B82D-300FCBCCAE63}
Package Version: {4DFF3F73-1653-4896-8DA3-A4246D41EE51}
Package Execution Lineage: {E17CD8A1-9754-413B-B129-093711326C27}
Executed On: SEQUEL
Executed By: SQLSERVICE
Execution Started: 3/26/2004 1:12:17 PM
Execution Completed: 3/26/2004 1:12:17 PM
Total Execution Time: 0.031 seconds

Package Steps execution information:

Step 'DTSStep_DTSDataPumpTask_1' was not executed

Step 'DTSStep_DTSActiveScriptTask_1' failed

Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description:The task reported failure on execution.
Step Error code: 8004043B
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:700

Step Execution Started: 3/26/2004 1:12:17 PM
Step Execution Completed: 3/26/2004 1:12:17 PM
Total Step Execution Time: 0.031 seconds
Progress count in Step: 0

Step 'DTSStep_DTSActiveScriptTask_3' was not executed
************************************************** **********

I have taken the following actions to resolve:
1. Tested DTS job on local SQL Server - executes without error
2. Checked security: The DTS job is owned by me, and I am a member sysadmins, etc... The SQL Job I have tried several differing accounts (Mine, Domain Administrator, and most recently a proxy account I setup called SQLDTSuser) All have failed with the same error.
3. I have checked the SQL Agent account to ensure that it has necessary rights, stopped and started SQL Agent service, same results.
4. As mentioned I setup a Proxy Account which is in Domain Admins, and Sysadmins on SQL and changed SQL Agent Properties to use this account. result was same error.
5. Set Workflow Properties on the DTS job ActiveXtask to "Execute on Main PAckage Thread" - result was same error.

I'm at a loss I have to be overlooking something obvious, but need someone to hopefully point me in the right direction. Thank you in advance for any help I can get!

The platform is SQL 2000 and I've included the first activex Task code below:

************************************************** **********
' Visual Basic ActiveX Script
'************************************************* **********

Function Main()
Dim fso
Set fso = CreateObject("Scripting.FileSystemObject")
Dim filePath
filePath = DTSGlobalVariables("gv_SourceDir").Value & "" & SourceFileName
If fso.FileExists(filePath) Then
fso.MoveFile filePath, DTSGlobalVariables("gv_WorkDir").Value & "" & DTSGlobalVariables("gv_WorkFileName").Value
Main = DTSTaskExecResult_Success
Else
Main = DTSTaskExecResult_Failure
End If
End Function

Function SourceFileName
Dim fileDate
fileDate = DateAdd("d", -1, Date)
SourceFileName = "LASERDATA" & PadLeft(DatePart("d", fileDate), 2) & PadLeft(DatePart("m", fileDate), 2) & Right(DatePart("yyyy", fileDate), 2) & ".CSV"
End Function

Function PadLeft(Value, Length)
Dim retval
retval = Value
Do While Len(retval) < Length
retval = "0" & retval
Loop
PadLeft = retval
End Function

View Replies !   View Related
Insert Fails
INSERT INTO ticket_dump_datawarehouse
SELECT Ticket_ID,
ID_Entry_Type,
Region,
Related_Case,
Create_Date,
ID_Service_Center,
ID_Type,
ID_Priority
FROM dump_view
will fill fail >

cannot insert the value NULL into column 'Ticket_ID', table 'capacity_base_tracking.dbo.ticket_dump_datawareho use'; column does not allow nulls. INSERT fails.
The statement has been terminated.

But dump_view does not contain any Ticket_ID columns that have NULL value..

where is the problem

View Replies !   View Related
DTS Job Fails When Scheduled
Hi!
I am trying to take a complete dabtabase backup through DTS wizard.However, the task runs fine when done directly,It falis when scheduled with teh following error in event log:

Event Type:Warning
Event Source:SQLSERVERAGENT
Event Category:Job Engine
Event ID:208
Date:4/7/2004
Time:2:01:22 PM
User:N/A
Computer:INTRANET
Description:
SQL Server Scheduled Job 'TestIntranetExportOnEPO' (0x8DA07349F2111949A424D9AC1D606C05) - Status: Failed - Invoked on: 2004-04-07 14:00:01 - Message: The job failed. The Job was invoked by Schedule 11 (TestIntranetExportOnEPO). The last step to run was step 1 (TestIntranetExportOnEPO).

Pls help!

View Replies !   View Related
SQL Reinstall Fails
Sorry about that first post I hit the wrong button.

I have a BIG problem. One day about a week ago I came into my office and everything was working fine, except for the fact that the drive of the NT server was a little fragmented. This machine is a dedicated server and since everything was relatively ok I turned the monitor back off and left the machine alone, after starting Diskkeeper to take care of the fragmentation. Later I go to check on the machine and the following message had appeared on the screen, NT system corrupt service can not continue with an OK button. So I sighed an pressed the ok button already to figure out what service needed to be restarted, unfortunately my best laid plans were soon destroyed when again the message popped up till I had shut down every program and had to reboot.... That is when the real fun started, it never rebooted, I had shut it down properly. So now I had a central server, that had never been backed up before that needed windows NT reinstalled. So I started reinstalling NT. I recently came in to this position and the people before me had not made and backup what so ever. So I had no Emergency Disk, and the systems files, i.e. User database, stuff that would normally be on a Emergency Disk were somehow corrupt and I could no recover them. Well after getting NT up, I worked on restoring the functions of the server, file sharing and web hosting. I still have a lot of programs to reinstall as the reinstall of NT left the actual program files alone, but has rendered them unusable. Now that I`m done with the background, I have now made a copy of what was left on the drive, so I could restore the data files. When I go to reinstall SQL 6.5, it will not let me use the upgrade part. So I try to do a complete install, I`m getting desperate here! Well it starts the install no problem asks me for info and I tell it. I have tried this with a new directory and the old one with the files intact. Well as the install goes along it allows the copying of the files, and then goes to a screen where it has the little hour glass thing in the SQL window setting up the server. A few minutes later it changes the title on the screen to read Microsoft SQL Server 6.5 Setup and brings up a window with the error The SQL Server installation could not be successfully completed Setup was not able to connect to the SQL server the only button is Exit to windows NT. I`m out of ideas. HELP me please.

View Replies !   View Related
Restore Fails
I'm new to SQL server, so bear with me please.

I'm running NT4 SP3 SQL 6.5 SP5. I have one major database (son_db) which is being backed up (along with others) using this command:

DUMP DATABASE son_db TO DBTape WITH NOUNLOAD , STATS = 10, NOINIT , NOSKIP

The task is completing successfully each night. However, we want to test the restore of this database, so we created a test table (test_table) which resides in the son_db database, added some data, and then let the backup run.

Next day we alter some data and try to restore the single table, but consistantly get the following message after clicking on the restore button:

[SQL Server] invalid source table "test_table" specified in LOAD TABLE. Could not find table in SYSOBJECTS in dump.

After this error, the table (test_table) is now completely empty.

MS website is no help, so I would really appreciate a bit of guidance on this,

Many thanks,

Joe
MCSE (but not including SQL!)

View Replies !   View Related
SQLMAINT Fails ...
Hi,
I tried to used SQLMAINT.EXE in my scheduled task but it keeps on failing and just gave me the syntax. I also tried to run it manually from the command prompt but it still kept on giving me the syntax to use SQLMAINT.

The following is just a simple test I did to check if SQLMAINT.EXE will work, but it did not. Is there any other thing I should do before executing/scheduling the SQLMAINT.EXE ?? ANY help is appreciated.

Zandro Santos

View Replies !   View Related
Restore Fails!!!!
Hi ,
While running the load cmd - 'Load database dbname1 from disk='c:empdump1.dat'
through ISQL I am getting the following error
1 transaction rolledback dbid error 7.But when I tried restoring using enterprice manager UI it is working fine.Any body knows why it is happening like this .
Thanks in advance
Jiji

View Replies !   View Related
HELP! -- RESTORE DB FAILS
Hello, I have a SERIOUS problem where I am restoring my SQL server (6.5) dump to my standby server everyday.......however, it often fails with the following msg:
'Unexpected end-of-dump while loading database, attempting to continue. Please verify database integrity. (Message 3103)'
It does also succeed, but too often fails and my standby server depends on it. The DB that gets restored is placed in single-user mode, so no other process or connection is allowed.
The backup to PROD runs at 12AM, for about 3 hours and succeeds always; the restore runs at 4:00...i've tried later times as well.
Can anyone tell me how to get near 100% success rate? What is the problem and how can I fix it? Thank you for the help.

View Replies !   View Related
BackUp Fails
Guys I was wondering if you can help me figure out the problem with the script.

1) I am getting the following error message on one of the job which is backing up all the databases on the server.

...ges for database 'AdminWorkFlow_Reports', file 'AdminWorkFlow_Reports_Data' on file 1.
[SQLSTATE 01000] (Message 4035) Processed 1 pages for database 'AdminWorkFlow_Reports',
file 'AdminWorkFlow_Reports_Log' on file 1. [SQLSTATE 01000] (Message 4035) Backup or
restore operation successfully processed 433177 pages in 64.328 seconds (55.163 MB/sec).
[SQLSTATE 01000] (Message 3014) Processed 113720 pages for database 'BMSRep', file 'BMS_Data'
on file 1. [SQLSTATE 01000] (Message 4035) Processed 1 pages for database 'BMSRep', file '
BMS_Log' on file 1. [SQLSTATE 01000] (Message 4035) Backup or restore operation
successfully processed 113721 pages in 17.200 seconds (54.162 MB/sec). [SQLSTATE 01000]
(Message 3014) Processed 208 pages for database 'EmailAddress', file 'EMailAddress_STGE_Data'
on file 1. [SQLSTATE 01000] (Message 4035) Processed 1 pages for database 'EmailAddress',
file 'EMailAddress_STGE_Log' on file 1. [SQLSTATE 01000] (Message 4035) Backup or restore
operation succe... The step failed.

Not sure where to start. I looked up the backup script it looks fine.

BackUp Database AdminWorkFlow_Reports to Disk = 'q:\AdminWorkFlow_Reports12-17-2007.bak'

--
--
--
--

BackUp Database EmailAddress to Disk = 'q:\EmailAddress12-17-2007.bak'

2)Also I have another script which for some reason doesn't run on some nights. Its enabled and the job is scheduled daily but its not running for about a week.

SQL server agent is running though.

Any help in this regard would be appreciated.

View Replies !   View Related
Connecting With The &#39;sa&#39; ID Fails
I am using SQL 2000/SP2 and the 'sa' password was changed from the
default blank password.

When installing the new SMSWeb Reports, 1.2.113.0, the Password
Verification fails for the 'sa' ID.

I reset the password and even tried to make an ODBC connection to the
database with the 'sa' ID and password, but that fails too.

Leads me to believe it's a SQL problem, but TechNet does not have
anything for this.

SQL experts, your advise please. Thanks....Susan

View Replies !   View Related
Job Fails With Sa As Onwer !
Hello everybody.
I job using web assistant to run once a day, after wizzard was complited
then fails next day with error ...
----
Unable to perform a SETUSER to the requested username 'dbo' because the username is invalid for database 'AccidentDB'. The step failed.
---

1. I check onwer of the job = MyDomainSQL2000 (it is sa and Sql server and
SQL agent use this account as service account)
2. I changed job owner to sa and restart job(I logged in to server as domain admin) result ... the same error
3. I created user accidentDB with dbo rights to database AccidentDB
made this user job owner and job runs fine .

Why job could fail for sa and MyDomainSQL2000 while those accounts are power users ?

---------------------------------------------
What the job does
Connect to DB2 database using linked server using open query and publish result to web page .
---------------------

Thank you

View Replies !   View Related
&#34;That&#39;s&#34; Fails To Insert
This is a proc that was working on production 7.0 server but is being tested on a 2000, what's changed?

TIA

JeffP....

View Replies !   View Related
DTS Package Fails When Run As A Job
I have a DTS package set up to push data out to several sites. When I execute the package it runs perfectly. When I schedule it as a job it fails.
I checked the proxy account in the SQLAGent properties and there is a check mark there. But the job still fails.

Does anyone have any ideas?

View Replies !   View Related
Insert Fails
Hi
I have C++ Client application writes data using sp in SQL Server.
After inserting more than 150000 records, i am unable to insert data , simply it hangs and no more connection are not allowing.If I close the application, it is working fine. What could be the reason?

Thank in advance

View Replies !   View Related
Master DB Fails
Ok I had a server crash the master was bad or corrupted. I tried to rebuild the master but that failed. I had to reinstall sql and then attach the databases.

I need to know why the master all of a sudden just stopped working. Any ideas where to look or what would cause this?

Thanks.

:eek:

View Replies !   View Related
Job Fails Under SQL Agent
We have recently upgraded our datawarehouse to SQL Server 7.0 and I am having problems getting a particular job to run out of the scheduler. Under SQL Server 6.5, this job took upwards of 16-18 hours to complete - but now fails after only 58 minutes. My problem with the failure is that I don't know where to look to find the cause - I will paste the contents of SQL Agents "view job history" window, which unfortunately (to me, as least) isn't much help. Any help offered will be much appreciated. Oh yes, I can run this job manually (through the new SQL Query analyzer), and it does complete. Even if it encounters an error such as a field not being long enough, or a particular index can't be dropped because it doesn't exist etc, the job will still chug on and finish after several hours. I have also made sure to run this job manually, and make sure to fix anything that may cause those silly error messages mentioned before. ALSO, if more information helps, I have more information... The job is TSQL statement, which simply is an 'exec run_automated 1,0,1' which calls a stored procedure, passes those parms to it. The stored procedure being called does branch out and call other stored procedures, which may in turn call others (never more than 3 deep). Thanks.

'View Job History'
... has been dropped. [SQLSTATE 01000] (Message 1923) Index (ID = 2) is being rebuilt. [SQLSTATE 01000] (Message 1918) Index (ID = 2) is being rebuilt. [SQLSTATE 01000] (Message 1918) Y [SQLSTATE 01000] (Message 0) ENSURE_PROD_JDE [SQLSTATE 01000] (Message 0) The clustered index has been dropped. [SQLSTATE 01000] (Message 1923) Index (ID = 2) is being rebuilt. [SQLSTATE 01000] (Message 1918) Index (ID = 2) is being rebuilt. [SQLSTATE 01000] (Message 1918) Y [SQLSTATE 01000] (Message 0) ENSURE_DIV [SQLSTATE 01000] (Message 0) The clustered index has been dropped. [SQLSTATE 01000] (Message 1923) Index (ID = 2) is being rebuilt. [SQLSTATE 01000] (Message 1918) Index (ID = 2) is being rebuilt. [SQLSTATE 01000] (Message 1918) Y [SQLSTATE 01000] (Message 0) ENSURE_SALES_REP [SQLSTATE 01000] (Message 0) The clustered index has been dropped. [SQLSTATE 01000] (Message 1923) Index (ID = 2) is being rebuilt. [SQLSTATE 01000] (Message 1918) Index (ID = 3) is being rebuilt. [SQLSTATE... The step failed.

View Replies !   View Related
ADO Connection Fails
I have an intermittent problem in a ADO application that cannot
connec to a SQL 7.0 server. The error message is similar to,
" USER 'null' is not a trusted login id user etc...... ".
Then a login box appears with the ' trusted connection' option
already selected. If I deselect it and try a standatd login with
a non-existant login id, obviously it fails. But then the interesting
thing is, if I select the' trusted connection ' option again in
the same login box, the connection thsi time is successful.

Any help from any body please?


Thanks.

Ranjit

View Replies !   View Related
TCP/IP Connection To SQL 7.0 Fails
Hi,

Recently I read in a listserver message about the bug BUG #: 56445 which causes the TCP/IP connection
to SQL 7.0 SP1 servers to fails and that a fix has been relased. I could however not find any reference
to this bug neither in MSDN not in TechNet. Has anybody seen this anywhere?


Thanks.

Ranjit

View Replies !   View Related
Script Fails
I have a script that is generated from main frame.
This script updates about 113,000 rows.
I keep getting an error message 225, 16.
From Books on line
225 "Refrenced object (name %*.s) dropped during query optimization"

16 Too many table names in the query. The maximum allowed is %d. knowing that it updates only one table this message does not make sense.
It is on sql server 6.5.

Any help will be very much appreciated.
Thanks in advance
Al

View Replies !   View Related

Copyright © 2005-08 www.BigResource.com, All rights reserved