Hi All,
I am working on a server movement work.The application is moving from sql server 2000/windows 2000 to sql server2005/windows 2003.I have a DTS package including some stored procedures which operates on the sql server.
I am using xp_cmdshell for copying and deleting excel files.And I am using microsoft.jet.4.0 to fill the excel file with data from a temp table.
The dts goes fine but it is not copying the excel template from one location to other.Again while deleting the 2 months old file i got an error saying cannot delete the files.
It was running correctly in sqlserver 2000.I have enabled the xp_cmdshell feature in the configuration.
Please help me and suggest me.
Thanks
I have used the copy database wizard, but I realized I had forgotten to shrink the transaction log file. So I canceled the wizard. My database, detached by the wizard, has now disappeared. The mdf file is still there, but when I try to attach it manually I get the "create file encountered operating system error 5 while attempting to open the physical file..." error.
I am facing a problem on a server which has raid 5 solution (3 disks), the raid controller went down 2 of the disks were off in the Bios.
We added the 3 disks to a different server identical in brand and architecture, the raid controller was able to reconfigure the virtual drive H:.
All files were there, we installed sql server 2005 on the new server, but when we tried to attach the database we got the error below:
TITLE: Microsoft SQL Server Management Studio ------------------------------
Attach database failed for Server 'myserver'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
The operating system returned error 38(Reached the end of the file.) to SQL Server during a read at offset 0x00000000af0000 in file 'C:Datamylog_log.LDF'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online. Operating system error 38(Reached the end of the file.) on file "C:Datamylog_log.LDF" during ReadFileHdr. Could not open new database 'mydb'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 823)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=823&LinkId=20476
------------------------------ BUTTONS:
OK ------------------------------
I tried the following steps but it always failed:
- create a new db with the same name of the lost db;
- put the db in emergency mode;
- stop sql service and replace the mdf file;
- start sql service;
- Run Dbcc checkdb('mydb')
we got the error below:
Msg 945, Level 14, State 2, Line 1
Database 'ism0506' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
I am working in a C# database application quick test where I basically use two types of access to an SQL Server Express database. In the first part of the code, I use the traditional connection declaring a SqlConnection. When I just use only this kind of connection I do not have any problem. The issue starts when I access to the same database using Data Bindigs at the same time. When I start the application I got and error as soon as the instruction goes to open the data base connection. The reported error is "Unable to open the physical file "<Niños.mdf>". Operating System Error 32: (Process does not have access to the file because is being using by another process)"
For additional information my connection string is:
I am trying to attach a database to SQL 2005. This database has not previously been attached. I have only just installed SQL.
I get the following message: Unable to open physical file "C:ArrowSQLArr@DataArrow_data.mdf" Operating system error 5: "5(error not found)" (Microsoft SQL Server: Error 5120)".
I have loaded SQL and the database fiel and directory with the same user account which is a local administrator on this machine. I have checked that I have read/write access to the file.
The machine runs Windows Vista Business. SQL has SP 2 loaded. What causes this?
I had few databases developed in SQL Server 2005 Developer Edition. I have detached all the databases and stopped developing anything new other than taking reqular backup of detached .mdf and .ldf files. I installed Vista on the other Hard drive that corrupted my XP installation drive letters so I had to reinstall XP OS. I have reinstalled SQL 2005 Dev edition. Now I am trying to attach the database it is giving error of Operating system error 5: "5(Access is denied.)". I tried to copy those .mdf and .Ldf files through windows explorer and it is not letting me copy past in the other place. I am getting Access denied from OS. I have about 5 databases and only one has this problem. What is going on and how do I solve this? Is the OS has locked the file? My home computer is not in a domain. I tried to right click the file to see if I can set access permission on the file. There is no such security options. Any help is appreciated.
We have a very severe issue in our production, and this is very very ugent to fix this issue, there was a job started on server on 10th October, 2007, for backup of database of 3.2 TB, which caused this issue on 18th October, 2007. I cancelled that job and even restarted the server, but still there is same issue on the server.
I am using this command to expand the physical file,
ALTER DATABASE [ODS] MODIFY FILE ( NAME = N'ODSFG33File1', SIZE = 307200000KB )
Error:
MODIFY FILE encountered operating system error 1450(Insufficient system resources exist to complete the requested service.) while attempting to expand the physical file.
Server:
64bit Itanium Server with 4 Processors 4TB of SAN Storage 24GB of RAM MS Windows 2003 Enterprise Edition with SP1 MS SQL Server 2005 (9.0.3152) Enterprise Edition with SP2
Database:
3.2 TB Size of Partitioned Database with 60 File Groups Every File Group contains One month data in its only one physical File. Physical Files are of different size between 10GB and 300GB.
I am facing a issue with bulk upload on Test Server.
Issue: When running Openrowset command from SQL server other that Test Server query runs fine when trying to run the same command from Test Server it gives error.
Msg 4861, Level 16, State 1, Line 1
Cannot bulk load because the file "\ServerNameinputFileName.csv" could not be opened. Operating system error code 5(Access is denied.).
For example: If the command is run from System A connecting to SQL Server instance on Test Server Test Server it gives this error. If the same command with same rights is run from any other SQL server instance say Dev1 its running fine.
If the command is run from Test Server connecting to any SQL Server instance including Test Server it is running fine.
Tried: 1) Given the read/write rights on shared folder, to user under which the SQL server service is running on Test Server
2) Given the read/write rights on shared folder to everyone.
Query:
SELECT DISTINCT * FROM OPENROWSET
(
BULK '\ServerNameinputFileName.csv',
FORMATFILE='\ServerNameFormat.xml'
)
AS FileList
Please provide me with some solution. What can be the reason for such behaviour?
We are trying to attach a database in Sql Server 2005 Express on Windows Vista.It will Show the following Error.
"Unable to open the physical file "Test.mdf". Operating system error 5 :". And then we installed the SQL Server 2005 Service pack 2. This error again comes.Could you please give me the steps to resolve the problem.
Hello all, I am running into an interesting scenario on my desktop. I'm running developer edition on Windows XP Professional (9.00.3042.00 SP2 Developer Edition). OS is autopatched via corporate policy and I saw some patches go in last week. This machine is also a hand-me-down so I don't have a clean install of the databases on the machine but I am local admin.
So, starting last week after a forced remote reboot (also a policy) I noticed a few of the databases didn't start back up. I chalked it up to the hard shutdown and went along my merry way. Friday however I know I shut my machine down nicely and this morning when I booted up, I was in the same state I was last Wenesday. 7 of the 18 databases on my machine came up with
FCB:pen: Operating system error 32(The process cannot access the file because it is being used by another process.) occurred while creating or opening file 'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataTest.mdf'. Diagnose and correct the operating system error, and retry the operation. and it also logs FCB:pen failed: Could not open file C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataTest.mdf for file number 1. OS error: 32(The process cannot access the file because it is being used by another process.).
I've caught references to the auto close feature being a possible culprit, no dice as the databases in question are set to False. Recovery mode varies on the databases from Simple to Full. If I cycle the SQL Server service, whatever transient issue it was having with those files is gone. As much as I'd love to disable the virus scanner, network security would not be amused. The data and log files appear to have the same permissions as unaffected database files. Nothing's set to read only or archive as I've caught on other forums as possible gremlins. I have sufficient disk space and the databases are set for unrestricted growth.
Any thoughts on what I could look at? If it was everything coming up in RECOVERY_PENDING it's make more sense to me than a hit or miss type of thing I'm experiencing now.
This is a problem I encountered when I had to detach a database file (type .mdf):
1) I went to the MS SQL Management Server Studi and detached my database file successfully from a connection called Workhorse.
2) I needed to place the .mdf database file into a zip file in order to put it on a remote server. I did this using Shared Portal. This was also successful
3) However when I tried reattaching the database file, I got this error:
CREATE FILE encountered operating system error 5A(Access denied.) while attempting to open or create the physical file "CProgram FilesMSSQL ServerMSSQLData<databasename>.mdf'
Q) The database file and log file (ldf) exist in the correct directory so I don't know what happened. Can any one help?
I currently run SQL Server 2005 64-bit Developer Edition (Service Pack 2 - it will be SP 3 as soon as I can get hold of it). I am running this on a stand-alone box with Windows Server 2003 as the OS.
Soon, I will be buying another computer for a colleague who will be running SQL Server as specified above. However, I am not happy with Windows Server and am wondering about changing to either XP 64-bit or Vista 64-bit. The machine will not be networked.
I would welcome advice on this since, in some ways, I would be happy enough to use XP or Vista, and think that 64-bit development is more likely on Vista than on other Windows OS's. However, I am not convinced that SQL Server 2005 works with Vista and, like everyone else, have heard plenty of complaints about Vista.
Can someone please assist, we have a Database roughly 10GB in size,
For the past 2 days now we get the following errors. //////// FCB::Open failed: Could not open file D:MSSQL.1MSSQLDataHelpdesk.mdf for file number 1. OS error: 32(error not found).
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. //////// FCB::Open: Operating system error 32(error not found) occurred while creating or opening file 'D:MSSQL.1MSSQLDataHelpdesk.mdf'. Diagnose and correct the operating system error, and retry the operation.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. ////////
I have code that instantiates a sqlserver object and starts a job. Ihave used this on numerous XP workstations successfully, when I triedto move this to a Windows 2000 Application Server attached to a SmallBusiness Windows 2003 network and run the code, I am receiving theerror:Automation Error. The Operating System Cannot Run %1.(Error Number -2147024714)The following is a code snippet:*********Dim app As New SQLDMO.ApplicationDim oSQLServer As New SQLDMO.SQLServerDim oJob As SQLDMO.JoboSQLServer.LoginTimeout = 30 ' ERROR OCCURS HEREoSQLServer.LoginSecure = True**********The code fails when setting the LoginTimout parameter. The SQLDMO.dllhas been registered successfully on the server.Any ideas whey the behavior of this code is different on my applicationserver vs the client workstations on the network?ThanksMike G
Are there any restrictions in the restored database after database mirroring?
I mean, Is it full mirror of my primary database?
What I want to do:
If my machine A(with primary database) will down I will redirect my clients to a real-time copied database - mirror server. I don't want to create cluster, but I want to use database mirroring function in ms sql 2005.
We were installing SQL Express 2005 on a Vista machine. This PC has a 64 bit CPU and a 64 bit Vista operating system. I know that we need to use WOW 64 to run SQL Express 2005. My question is how do I turn on WOW64 so I can run SQL Express 2005 Vista
How to insert or retrieve images type data in sql server?I want to put a jpeg file in sql server.How can I accomplish that?>How to input into the table and how to retrieve that from the table I have a table contacts.The fields are ID int Name Varchar Photo Image
Hi, who have ever met the following errors, share an information of what could cause it??? I can't find any info that could help me find the reason. My DB went to SUSPECT mode and in the log file I got:
ForwardLogBlockReadAheadAsync: Operating system error 997(Overlapped I/O operation is in progress.) encountered.
Operating system error 997(Overlapped I/O operation is in progress.) on device 'd:MSSQLdataiservice_Log2.ldf' during ForwardLogBlockReadAheadAsync.
Error: 3414, Severity: 21, State: 1
Error: 9001, Severity: 21, State: 1
Unexpected error while commiting a ShrinkFile operation /*************************/
What is weird the 997 error occured twice during last night and the DB went into suspect mode only after the sencond one.
The database restored but it's a second time for the last month just getting a bit annoying.
Im trying to run dtsrun twice in one OSC job step e.g.
DTSRUN /F "path to dts package" /E DTSRUN /F "path to dts package2" /E
Im finding that it always runs the first line but never the second. I tried swapping the lines around and it then runs the other because tht is the first line. Again the second line won't run.
Iam using HP iPAq hw6500 series PDA. My application in installed in the PDA and when i try to open the application by taping on the application icon, Iam getting the following error.
Error: 0x80004005 E_FAIL Native Error: (25080) Description: The operating system does not support encryption. [,,,,,] Interface defining error: IID_IDBInitialize Param. 0: 0 Param. 1: 0 Param. 2: 0 Param. 3: Param. 4: Param. 5:
The application is builded on embedded VC++4.0
Can anyone help to figure out the possible reason for this error?
We are using SQL Server Compact Edition v3.1. We have 2 users running on Windows XP with Service Pack 2, who are getting errors that the Operating System does not support encryption when creating a new database. The problem is not with the code, one of the users installed the same software on a different Windows XP system and the software operates correctly. We also have many other installations that are working properly as well, so it appears to be something specific to these 2 computers.
We've had the user try repairing their .NET Framework 2.0 install, in addition to confirming that the
Crypt32.DLL and CryptUI.DLL dependencies are both present and of the correct version in WindowsSystem32. We've also verified that the users do have write access in the directory we are trying to create the database.
Is there something we can do to fix encryption on these users systems or something the users may have done to disable encryption?
I'm just learning Transact-SQL, so pardon if this is a dumb question. I would like to perform operations on neigboring rows in a database table column, and I have no idea how to do this. Say I have the following table:
Date (smalldatetime) | Value (money) date1 | value1 date2 | value2 ... dateN | valueN
hi, I am working on SQL server 6.5 using a desk top. Now I am about to buy a note book and do some development work. As far as I know, win 95,98 does not support SQL server 6.5
But SQL sever 7.0 does support win 95,98 Am I correct? I am confuzed, what notebook operating system shall I buy which will allow me to work on sql development on the road.
another issues is what if I choose to use win 98 for sql server 7.0 what are the things that I will be missing . In other word, what are the limitation that I may have when acquiring win 98 as an operating system for sql server 7.0..
Hi there. Could someone help me out. I'm performing a log restore and getting the following error within the SQL Server Error Log.
During restore restart, an I/O error occurred on checkpoint file 'G:MSSQL.1MSSQLBackupdxsh.CKP' (operating system error 1784(error not found)). The statement is proceeding but cannot be restarted. Ensure that a valid storage location exists for the checkpoint file.
IT's a very basic Restore command and i do have not specified it to Restart.
Having checked the MS website for 1784 it suggests the following:
The supplied user buffer is not valid for the requested operation
Can anyone tell me what is wrong here and why it is creating a checkpoint file or even what it is and how to overcome the error message.
