I`m having difficulty performing a SQL dump using a network drive. I have successfully created a backup device on a network drive but when I go to perform a backup using it I get the following error message: "Can`t open dump device `RSS4DATARSA3_Dump.Dat`, device error or device off line. Please consult the SQL Server error log for more details. (Message 3201)" I can successfully perform a backup using a local drive but not this network drive. I have checked the permissions on the network drive and is seems ok. I use the following command to try to perform the backup: "DUMP DATABASE RSA3 TO DISK = `Rss4DataRSA3_Dump.Dat WITH STATS = 10, INIT". Any help would be most appreciated. Thanks in advance!
I start receiving error 'Access is denied' executing following command: exec xp_cmdshell 'dir \IP-ADDRESSSHARE_NAME*.*'
The configuration is following: Two computers CO1 and CO2 Both computers are not in domain, Both computers use the same local windows account to run their instances of SQL server 2005 and passwords for those accounts are the same Both local accounts are in their local administrative groups Both servers do not have configured proxy account. I execute sql commands under ther sysadmin account
If I execute this command from CO1 to CO2, everything works. exec xp_cmdshell 'dir \CO2_IPSHARE_NAME*.*' If I execute from CO2 to CO1 I receive access denied. exec xp_cmdshell 'dir \CO1_IPSHARE_NAME*.*'
If I will log in to the computer CO2 under account of SQL server and execute the dir command from it, it works. dir \CO1_IPSHARE_NAME*.*
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?
We have a Windows 2003 Web Edition server serving a site through IIS. It connects to a Windows 2003 Standard Edition server running SQL 2000 SP3a.
This site receives the following error as seen in the topic: [DBNETLIB][ConnectionRead (recv()).]General network error. Check your network documentation.
We've configured the server network utility to only allow TCP/IP connections. The connection string for the site is as follows:
Any ideas or tips on solving this issue? We've noticed it is due to larger queries as smaller ones do work with no problems.
The servers are behind a BSD box running iptables, has 1433,1434 along with standard web ports wide open. Anything outbound is allowed.
Some further testing via ODBC on the IIS server improved things. No more connection pooling for the SQL Server driver allows for 1/3 of the query to run. Still 2/3s of it doesn't show up, and that general network error message appears.
Hi While running a DTS, many times the error message: "[DBNETLIB][ConnetionWrite (WrapperWrite()).]General network error. Check your network documentation." appears. Does somebody knows why?
I am running the DTS from a computer (not the server where the DTS is stored) and it is connected without any problem when this happens.
My application is running fine, as i can login to it and also able to view pages. But when i open Order management(having 3K records) its give me error,
General Network Error. Check your network documentation
I have also searched many articles and tried following solutions but nothing working
- connectiontimeout = 0, max pool size = 7500/100, pooling = false
- SSL disabling enforce security false as mentioned in microsoft kb article.
And there's nothing any issue with hardware/firewall as my application's login and other forms are working fine(which use same database with same connection string)
Hi We have a written a error log in Global.asax. which capture below mentioned error in the prodcution server. Same applications is working fine in some locations and some loactions we are getting the error.Any body knows why this error is occurs.Any body knows why this error is occurs. Error Message:General network error. Check your network documentation.Stack Trace: at System.Data.SqlClient.SqlInternalConnection.OpenAndLogin() at System.Data.SqlClient.SqlInternalConnection..ctor(SqlConnection connection, SqlConnectionString connectionOptions) at System.Data.SqlClient.SqlConnection.Open() at datalayer.sqldb.Execute(String ProcedureName, SqlParameter[] Parameters) at lms.User.GetUserDetails(String strUserid)ITs at LMS.Login.w_btn_Login_Click(Object sender, EventArgs e) at System.Web.UI.WebControls.Button.OnClick(EventArgs e) at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
Hi,I am using .Net 1.1 for my web application.And my database server is SQL Server 2005. My application is running fine, as i can login to it and also able to view pages. But when i open Order management(having 3K records) its give me error,General Network Error. Check your network documentation I have also searched many articles and tried following solutions but nothing working- connectiontimeout = 0, max pool size = 7500/100, pooling = false- SSL disabling enforce security false as mentioned in microsoft kb article. And there's nothing any issue with hardware/firewall as my application's login and other forms are working fine(which use same database with same connection string) Can any one please help me to solve this error?
When I try to update the site setting, I get this Error and I don't know how to fix.
Server Error in '/DotNetNuke' Application. --------------------------------------------------------------------------------
General network error. Check your network documentation. 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: General network error. Check your network documentation.
Source Error:
Line 281: Line 282: myConnection.Open() Line 283: myCommand.ExecuteNonQuery() Line 284: myConnection.Close() Line 285: End Sub
-------------------------------------------------------------------------------- Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573
Hi I get a "General Network Error Check network documentation" error sometimes, but its only while insert or update statements are fired while selects keep working perfectly.
The Error details are as follows: General network error. Check your network documentation. 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: General network error. Check your network documentation. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace:
[SqlException: General network error. Check your network documentation.] System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
In Oracle & Sybase you can set login resource limits to restrict, time of day, number of i-o's, cpu use etc for any login, at the login method. All actions done from a resource limit constrained login inherit the constraints.
Is there any way to implment this with any MS SQL Server version from 200-2005/SP2?
Before anyone answers, please do not suggest set rowcount etc. thanks.
I have a deadlock chain that shows 9 parallel insert jobs into the same table. The resource that is locked (with an exclusive lock) shows a HOBT_ID...which corresponds to a clustered index.
My question is how would INSERT statements cause a whole index to lock (there is no TABLOCK hint).
I would like to know witch is the best practices to make a .rdl file multilenguaje, that is, that the same .rdl file shows the text €œAmount€? on a label when the user is English or the text €œCantidad€? when the user is Spanish.
There are not something like the resource files in the in a VS.NET web application????
I am new to SSIS, and have been struggling recently with SSIS development. I would like to find out if there are some good books out there on SSIS besides, the online resources, and BOL. Possibly a good book or tutorials. Thanks.
I would like to know witch is the best practices to make a .rdl file multilenguaje, that is, that the same .rdl file shows the text €œAmount€? on a label when the user is English or the text €œCantidad€? when the user is Spanish.
There are not something like the resource files in the in a VS.NET web application????
DTSTransformCopy: ValidateSchema failed; see Extended Error Information. TransformCopy 'DTSTransformation_10' validation error: Source column too narrow to contain a valid value of destination column's datatype for column pair 1 (source column 'Col010'(DBTYPE_STR), destination column 'CHECKDAT' (DBTYPE_DBTIMESTAMP)).
Hi,I am getting the following error (When i am trying to update the column thru windows service) Please let me know the solution for the following.The following error is comming only when i set CommandTimeout to infinity (Commandtimeout=0).General network error. Check your network documentation. Number 11 Procedure ConnectionRead (recv()). Class 20 State 0 Source .Net SqlClient Data Provider Server Line number 0 Thanks and Best RegardsNagaraju A
What are some good CASE programming to use in comjuction with SQL 7. What are some good resources for researching. Also, are there any good DB confrences coming up?
I use cursors inside stored procedures, they are generally 20 - 50 records. I have been told that cursors are very resource intensive. Am I setting myself up for scaling problems when we have hundreds of users all running these procedures? The cursors are only used within the context of the stored procedure. Any opinions/insight on this would be appreciated.
I'm attempting to update a table of around 100,000 records with a table of 20,000 records using a cursor since the update is based on a row by row criteria. When doing this I'm getting an error
--Resource is low some results are dropped--
I then cut down the table with 20,000 to a table of 5,000 and still get the same error. I've also tried to use a fast_forward cursor but still no luck Can any-one help. I know there is a way to do this using a quick update statement but I need to know this for other insert statements anyway. Help Help
after moving the resource database files with this command:
ALTER DATABASE mssqlsystemresource MODIFY FILE (NAME=data, FILENAME= 'new_path_of_mastermssqlsystemresource.mdf'); GO ALTER DATABASE mssqlsystemresource MODIFY FILE (NAME=log, FILENAME= 'new_path_of_mastermssqlsystemresource.ldf'); GO
I am getting this error trying to do anything in the instance while I have it started in minimal mode (/f /t3608)
(the instance WILL NOT COME UP UNLESS I USE THE /F /T3608 from a command promt.. please .. any suggestions?????????????????????? Also.. I checked and the primary file is NOT READ-ONLY.
File activation failure. The physical file name "E:MSSQLKOCSQLDEV01Datafilesmssqlsystemresource.ldf" may be incorrect.
The log cannot be rebuilt when the primary file is read-only.
File activation failure. The physical file name "E:MSSQLKOCSQLDEV01Datafilesmssqlsystemresource.ldf" may be incorrect.
The log cannot be rebuilt when the primary file is read-only.
Msg 945, Level 14, State 2, Line 1
Database 'mssqlsystemresource' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
We have a JDBC project that works with SQLServer, along with otherDBs. During development, we noticed that resource useage on SQLServerseemed to grow steadily - Processes, Process Locks and/or Object Locks,according to the "Current Activity" section of Enterprise Manager.Fairly quickly (a few hours), SQLServer would use so many resources itused up all available system memory and the system would crash.Without understanding much about why that was happening, mostly out oftrial and error, we started using transactions, which seemed to fix theproblem. Now, one of our customers seems to be seeing the problem again:511 Process Locks, 18 Object Locks, 526 Processesafter a few hours. The system runs out of memory and crashes. We havemultiple test configurations, including Linux, Win2K, XP, but we donot see the same behaviour - we typically see no more than 20 or 30processes, process locks or object locks, and our tests seem to runindefinitely. Since we can not reliably reproduce the symptoms that ourcustomer sees, it is very difficult for us to analyze, let alone, fixthe problem.Does anyone - especially SQLServer pros - have any insight as to what isgoing on here and/or how to fix it? Like how does a process, processlock or object lock relate to JDBC? process <-> connection,object <-> row, table... or what, locks?Thanks,Gary WhittenJoin Bytes!
Just downloaded a not too great white-paper (sponsored by HP) called SQL Server Infrastucture Optimaztion and it had a brief but eye catching section on something called 'Pooled Resource Clustering'. See below
Pooled-Resource Clustering Pooled-resource clustering is a combination, of sorts, of Windows clustering and virtualization. Essentially, it€™s a means of allowing SQL Server instances to become €œvirtual SQL Servers€? in the sense of true VMs. They€™re encapsulated and can be easily and quickly moved between physical computers. It borrows concepts from Windows clustering but does so with a crucial difference that eliminates the resource management overhead that comes along with Windows clustering. Another term for this technique is shared storage clustering. Technology Overview With pooled-resource clustering, a cluster of servers€”which can all have different hardware specifications€”are connected to a single, shared storage system (typically a SAN). By leveraging a Windows-based cluster file system, each of the nodes in the cluster can €œsee€? the
same storage area. That is, they all have (for example) an S drive,
I googled this and can't find any more about it. So my question is simple can anyone provide more info about this method. I tried tried the authors web site burt its all sales info address(
I have a 2005 server that is upgraded to SP2 and the error log indicates it is version 9.00.3042.00. However, the system resource database for the same server is reporting as version 9.00.2047.00. From another post I have found out the some replication problems I am having are due to this discrepancy.
I have reapplied SP2 hoping it would change the resource db version, but it did not. Is there another way I can upgrade the resource db without re-installing SQL from scratch?
We've been working hard with our teams here to get better/more/good information out to our users. We€™ve created a new a customized Windows Live search, that limits results to Books Online. Check this out, and make sure you let your contacts know to visit it and provide feedback: http://search.live.com/macros/sql_server_user_education/booksonline
We want to generate as much traffic as possible here so that we can see if this is useful to our users. We€™d love to hear back from everyone we can!
I was watching Bob Tabor's SQL Server 2005 Express for Beginners videos from the ASP.net 2.0 website http://www.asp.net/learn/videos/default.aspx?. In lesson 5 Manipulating the Database Data he refers to download the sample database SQLVideoResources.zip file from the above website.
I searched and did not find it. Can anyone please direct me?
I am using SSIS for sending E-Mails based on certain transactions in SQL Server. I need to dynamically populate the E-Mail content as the content some times needs to be in Japanese text. I would like to use resource files for this. Could anyone please help me on using resource files in SSIS.
after moving the resource database files with this command:
Code Snippet ALTER DATABASE mssqlsystemresource MODIFY FILE (NAME=data, FILENAME= 'new_path_of_mastermssqlsystemresource.mdf'); GO ALTER DATABASE mssqlsystemresource MODIFY FILE (NAME=log, FILENAME= 'new_path_of_mastermssqlsystemresource.ldf'); GO
I am getting this error trying to do anything in the instance while I have it started in minimal mode (/f /t3608) (the instance WILL NOT COME UP UNLESS I USE THE /F /T3608 from a command promt.. please .. any suggestions??????????????????????
File activation failure. The physical file name "E:MSSQLKOCSQLDEV01Datafilesmssqlsystemresource.ldf" may be incorrect.
The log cannot be rebuilt when the primary file is read-only.
File activation failure. The physical file name "E:MSSQLKOCSQLDEV01Datafilesmssqlsystemresource.ldf" may be incorrect.
The log cannot be rebuilt when the primary file is read-only.
Msg 945, Level 14, State 2, Line 1
Database 'mssqlsystemresource' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
