Crashing Server - Emergency!!!!!
Mar 22, 2000
Please direct me to detailed causes of SQL server crashing after a 17805 Invalid Buffer Received From Client. Our production server goes down, following this msg.
We applied service pack 5a, and it is still crashing. It crashes using either NAMED PIPES or TCP/IP protocol (via ODBC) The driver versions are older, ODBC 3.0 and SQL Server 2.65, respectively.
I need some direction on this. I'm leaning towards the possibility that this is an application problem.
Any help, any configuration setting changes, upgrades, workarounds, will be accepted. Thank you much!
View 1 Replies
ADVERTISEMENT
Aug 10, 2004
Our SQL SERVER seems to be sick,all queries run very very slow since three days ago. SQL query analyzer can't select a efficient index to produce execute plan and the CPU is idle and lazy even if many proccess threads waiting for handle,it is very strange!! Otherwise,there are too many deadlock existing when the 2 third users use system at same time.
I have use DBCC REINDEX to re-build all indeies.
Total data used space :11.22G:
reserved index_size data unused
--------------------------------------------------
11220056 2053432 8945432 221192
data rows in some table up to 16009830,details of some table as follow:
Table_name Rows reserved data index unused
------------------------------------------------------------------------
Worksheet_Fabric 4629414 1073568 KB 782504 KB 290360 KB 704 KB
Fab_Input_Detail 16009830 804512 KB 616896 KB 187248 KB 368 KB
Product_In 4385485 774048 KB 525896 KB 247880 KB 272 KB
Dw_note 9109810 741336 KB 736600 KB 72 KB 4664 KB
Instructions_Detail 1906960 663432 KB 592800 KB 69288 KB 1344 KB
Instructions_M_Detail 2328862 94128 KB 504824 KB 88656 KB 648 KB
Product_Out 4323939 575256 KB 364880 KB 210208 KB 168 KB
Worksheet_QC_Detail 3404309 561800 KB 507552 KB 54040 KB 208 KB
SQL SERVER VERSION:
Microsoft SQL Server 7.00 - 7.00.623 (Intel X86)
Nov 27 1998 22:20:07
Copyright (c) 1988-1998 Microsoft Corporation
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
result of sp_configure:
name minimum maximum config_value run_value
----------------------------------- ----------- ----------- ---------
affinity mask 0 2147483647 0 0
allow updates 0 1 0 0
cost threshold for parallelism 0 32767 5 5
cursor threshold -1 2147483647 -1 -1
default language 0 9999 0 0
default sortorder id 0 255 197 197
extended memory size (MB) 0 2147483647 0 0
fill factor (%) 0 100 0 0
index create memory (KB) 704 1600000 0 0
language in cache 3 100 3 3
language neutral full-text 0 1 0 0
lightweight pooling 0 1 0 0
locks 5000 2147483647 0 0
max async IO 1 255 32 32
max degree of parallelism 0 32 0 0
max server memory (MB) 4 2147483647 2147483647 2147483647
max text repl size (B) 0 2147483647 65536 65536
max worker threads 10 1024 255 255
media retention 0 365 0 0
min memory per query (KB) 512 2147483647 1024 1024
min server memory (MB) 0 2147483647 0 0
nested triggers 0 1 1 1
network packet size (B) 512 65535 4096 4096
open objects 0 2147483647 0 0
priority boost 0 1 0 0
query governor cost limit 0 2147483647 0 0
query wait (s) -1 2147483647 -1 -1
recovery interval (min) 0 32767 0 0
remote access 0 1 1 1
remote login timeout (s) 0 2147483647 5 5
remote proc trans 0 1 0 0
remote query timeout (s) 0 2147483647 0 0
resource timeout (s) 5 2147483647 10 10
scan for startup procs 0 1 0 0
set working set size 0 1 0 0
show advanced options 0 1 1 1
spin counter 1 2147483647 10000 10000
time slice (ms) 50 1000 100 100
two digit year cutoff 1753 9999 2049 2049
Unicode comparison style 0 2147483647 196609 196609
Unicode locale id 0 2147483647 1028 1028
user connections 0 32767 0 0
user options 0 4095 0 0
View 10 Replies
View Related
Jul 30, 2001
I am running SMS ontop of SQL 7. I keep getting these SQL dump files and cant figure out where to begin. Can somebody help and put me on the right path?
2001-07-22 12:08:55.46 spid12 Process ID 12 attempting to unlock unowned resource PAG: 7:1:507423..
2001-07-22 12:13:21.29 spid8 Error: 1203, Severity: 20, State: 1
2001-07-22 12:13:21.29 spid8 Process ID 8 attempting to unlock unowned resource PAG: 7:1:505802..
2001-07-22 15:15:48.20 spid11 Using 'sqlimage.dll' version '4.0.5'
Dump thread - spid = 11, PSS = 0x700634b4, EC = 0x216da084
Stack Dump being sent to D:MSSQL7logSQL02866.dmp
************************************************** *****************************
*
* BEGIN STACK DUMP:
* 07/22/01 15:16:00 spid 11
*
* Input Buffer 417 bytes -
* INSERT INTO Summarizers_Status (SiteCode, MessageDLL, MessageID, Status,
* Updated, GUID_ID) SELECT DISTINCT SiteCode, "SMS_RES1.DLL", 40, (SELECT
* ISNULL(MAX(x.Status), 0) FROM Summarizer_SiteSystem x WHERE x.SiteCode
* = a.SiteCode), (SELECT ISNULL(MAX(x.TimeReported), '1/1/1998 01:00') FRO
* M Summarizer_SiteSystem x WHERE x.SiteCode = a.SiteCode), "{78B42510-ABB
* D-11d1-BB12-3A84C6000000}" FROM Summarizer_SiteSystem a
*
************************************************** *****************************
-------------------------------------------------------------------------------
Short Stack Dump
0x77f67a6b Module(ntdll+7a6b) (ZwGetContextThread+b)
0x00784f83 Module(sqlservr+384f83) (utassert_fail+19f)
0x005b572c Module(sqlservr+1b572c) (ExecutionContext::Cleanup+9d)
0x004eb421 Module(sqlservr+eb421) (ExecutionContext::Purge+45)
0x004eb182 Module(sqlservr+eb182) (stopsubprocess+e5)
0x004e9d4e Module(sqlservr+e9d4e) (subproc_main+174)
0x41092a47 Module(ums+2a47) (ProcessWorkRequests+ec)
0x4109326b Module(ums+326b) (ThreadStartRoutine+138)
0x7800bee4 Module(MSVCRT+bee4) (beginthread+ce)
0x77f04ede Module(KERNEL32+4ede) (lstrcmpiW+be)
2001-07-22 15:16:01.24 kernel SQL Server Assertion: File: <proc.c>, line=1927
Failed Assertion = 'm_activeSdesList.Head () == NULL'.
2001-07-22 15:16:01.31 spid11 Using 'sqlimage.dll' version '4.0.5'
Dump thread - spid = 11, PSS = 0x700634b4, EC = 0x216da084
Stack Dump being sent to D:MSSQL7logSQL02867.dmp
View 1 Replies
View Related
Nov 7, 2000
Help!!!
our sql server (7.0) crashed today because it's running out of space, apparently as a result of some process(es) loading data onto it that left less than one mb of free space on the C/ drive. Most of the data and backups are on the D/ drive which has tons of free space. The swap file was on C/ but the dba moved it after today's episode. His diagnosis is that there are files being created in the server's cache that are clogging it up.
What I really need to find out if there are any temp files generated by scheduled packages that could cause this to happen? We are relatively new to executing jobs on the sql server, so this was not an anticipated situation. Essentially, this server has about 12 jobs that import and transform data from an AS/400 server onto the SQL Server every week. We've been running the jobs for about 4 months and just about 3 weeks ago I noticed a big degradation in the server's performance. Also, how can I find out which physical drive the jobs are residing on? Could anyone suggest on the best course of action please?
Irene
out if there are some sort of temp files that are generated when the scheduler executes jobs on the server.
View 2 Replies
View Related
Apr 3, 2006
Hi All
Last to last friday, the server crashed.We had to restart the machine to bring up the sql server.Initially we thought this as a one odd instance.This friday, almost the same time, it crashed again. By the time users complained saying they are not able to acces the application, the server froze.I was not able to see the processes running during this time.
Now I realised there is a potential problem.
I check all the logs - > SQL Server log, SQL Agent log, Event viewer.
I dont see any error messages related to this.
Since both weekends it happened at the same time, I assume that there might be some job running on the friday evening which is bringing the server down.
I checked for all the scheduled jobs and didnt find anything. So I assume this might be because of some adhoc jobs ran from the application which is causing this issue.
This have been highly escalated by the users and I have to act :mad:
I am planning to put a trace to see the happenings during this time.
Questions
1) What all parameters(in the profiler) should i take into consideration
2) Any other ways of troubleshooting the same.
3) Any whitepapers / documents to similar issues
Plz respond,my job is at stake :(
Thanks
Sree
View 10 Replies
View Related
Aug 16, 2004
emergency help, our server1 is down, we need to restore everything from tape using server2, but when i put the tape in the server2, it said "unreadble media", what should i do to restore everything? How can the tape to be readble? Thanks, thanks.
View 14 Replies
View Related
Mar 13, 2008
is there a roll back function for sql server 2005 that would change data back to what it was before the execution of last update query?
View 8 Replies
View Related
Mar 17, 2004
Hi
We're having trouble with Enterprise manager when trying to view views or table data/properties, we get an access violation error and the database crashes sometimes corrupting tables.
Ive seen some posts stating a post SP3 for SQL Server is required and some posts saying client access should be modfied.
However our enterprise manager clients are registered with SA so I dont think that is an issue.
Can anyone give me some help with this and/or direct me to the hotfix please.
Cheers
Louise
View 2 Replies
View Related
May 20, 2004
I got a server that Crashed. My network group was able to get it up and running but it's vary fragile. One of the disk is done. What's the best way to get the my database:tables,views,stored procedured,dts packages, jobs off the bad server without crashing it again? I used the databae copy utility but found out that some of the database are replicated and it wont allow it to copy.
Thanks
Just another day in the life of a dba
View 2 Replies
View Related
May 24, 2007
i have my SQL server 2005 crashing when Events log is full
I have a hacker attacking my DB with a brut force tool but whereas he does not have the password, event log registers his access attempts as Failure Audit.
I have thousands of lines of "Failure Audit" in my event log
The event logs are set to be overwritten automatically when they reach 16Mb but it's not working correctly, they r not overwriting their content.
in SQL 2005 ERRORLOG file i see:
2007-05-14 01:57:11.57 spid80 Error: 17054, Severity: 16, State: 1.
2007-05-14 01:57:11.57 spid80 The current event was not reported to the Windows Events log. Operating system error = 1502(The event log file is full.). You may need to clear the Windows Events log if it is full.
SQL Agent cannot starts because it's not able to write in the event log that it's starting and when it cannot write in event log, it does not start and my sql server crashed
My Question is simply how to fix this issue once for all
View 3 Replies
View Related
Mar 29, 2007
I had the following erroneous code in a SQL Server stored C# procedure:
class P
{
private DateTime? e;
public P(
DateTime? e)
{
this.e= e;
}
public DateTime? E
{
get
{
return E; // correction return e;
}
set
{
E= value; // correction e = value;
}
}
}
Calling the getter of E of the class P creates an infinite number of method calls. This causes the .NET stack overflow. This sometimes caused our SQL crash. Here's the log:
29.3.2007 9:46:08 A fatal error occurred in .NET Framework runtime. The server is shutting down.
29.3.2007 9:46:10 Microsoft SQL Server 2005 - 9.00.2153.00 (X64)
May 9 2006 13:58:37
Copyright (c) 1988-2005 Microsoft Corporation
In my opinion an error in SQL server CLR stored procedure must not be able to crash the whole SQL Server, as it seems to do. Could someone verify this?
What makes finding problems like this problematic is that the only error is like ".NET stack overflow". No pointer to where in the code the error occured. It took hours for me to find the problem
View 11 Replies
View Related
Nov 15, 2000
I've installed the client tools on my notebook, and EM normally works properly. However, sometimes Enterprise Manager will crash on me for no obvious reason(it generates errors, but this takes forever, so i kill it). It is not consistent, nor can I reproduce the error, but it happens about once a day, never at the same time. Anyone else see this? My pc has win2K professional on it.
View 1 Replies
View Related
Jan 31, 2007
I just recently replaced my old HP laptop with a Sony VAIO. I installed all of my development software on it, including SQL Server 2005 and the studio. At some point when I am using the studio on this new laptop, if I try to resize any of the columns to better fit the data, it crashes my laptop. I get the infamous Blue Screen of Death.
The laptop is a Sony Vaio BX670P and it has Win XP SP2 with all of the latest and greatest updates loaded on it.
The BSD blames a driver for causing the crash and points out "win32k.exe" specifically. This has never happened to me before.
Does anyone know why this might be happening?
- - - -
- Will -
- - - -
http://www.strohlsitedesign.com
View 20 Replies
View Related
May 30, 2006
Hi,I'm accessing a pair of databases with ASP/ADO,and using stored procedures on the first access.The first access works OK - everything gets writtento where it's supposed to be.On attempting to write to a pair of database tablesin the second database (second access attempt),the server crashes, as does the app, and I get the following error:--------------------------------------------------------------------Server Error in '/Webfolder01' Application.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: A transport-level error has occurred when receiving results from the server. (provider: Shared Memory Provider, error: 0 - The pipe has been ended.)--------------------------------------------------------------------After this, I have to go into the services panel and restart SQL 2005.This doesn't happen if I use small test data sets in the first access,and I can comment out the second access attempt, and the first accessexecutes just fine with both the large and small data sets,so I'm thinking that this has something to do with synchronisation:Perhaps the second attempt is being made before the server is ready.Is there something that I need to do to make certain that SQL 2005is ready to receive data?I'm using SqlBulkCopy with both accesses, but I don't see how thatcould be a problem.--------------------------------------------------------------------[SqlException (0x80131904): A transport-level error has occurred when receiving results from the server. (provider: Shared Memory Provider, error: 0 - The pipe has been ended.)] System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +857370 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +734982 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188 System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error) +556 System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj) +164 System.Data.SqlClient.TdsParserStateObject.ReadPacket(Int32 bytesExpected) +34 System.Data.SqlClient.TdsParserStateObject.ReadBuffer() +30 System.Data.SqlClient.TdsParserStateObject.ReadByte() +17 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +59 System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal() +1327 System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer (Int32 columnCount) +916 System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState) +176 System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table) +6 Database_control.DB_ctrl_class.load_datatable_to_DB_table(DB_ref_class src_table) in i:Virtual WebfoldersDBctrl.cs:978--------------------------------------------------------------------THANK YOU VERY MUCH!!!
View 4 Replies
View Related
Mar 18, 2008
I'm having many many issues installing sql server management tools. i had visual studio 2005 installed first, but uninstalled and sql related things before trying to install sql server management tools again - i also deleted the program files/microsoft sql server/ folder so there are no references.
Firstly the system configuration check gives me a warning that the system doesn't meet the recommended hardware requirements - this is wrong... i've got 2.33Ghz dual core + 1gb of ram...
I select just management tools + client connectivity to install and click next -> the setup support files/native client/owc11 etc all install fine but workstation components etc fail and the setup log appears to either be empty and not available
and MSXML6 fails... after clicking finish the installer appears to crash - : "Microsoft SQL Server 2005 Setup has encountered a problem and needs to close. We are sorry for the inconvenience"... I have tried all sorts of variations on this install and have had no problems in the past - please help!
The setup log from the MSXML6 failure -
=== Verbose logging started: 18/03/2008 12:34:09 Build type: SHIP UNICODE 3.01.4000.4039 Calling process: C:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe ===
MSI (c) (5C:78) [12:34:09:067]: Resetting cached policy values
MSI (c) (5C:78) [12:34:09:067]: Machine policy value 'Debug' is 0
MSI (c) (5C:78) [12:34:09:067]: ******* RunEngine:
******* Product: {AEB9948B-4FF2-47C9-990E-47014492A0FE}
******* Action:
******* CommandLine: **********
MSI (c) (5C:78) [12:34:09:067]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (5C:78) [12:34:09:067]: Grabbed execution mutex.
MSI (c) (5C:78) [12:34:09:067]: Cloaking enabled.
MSI (c) (5C:78) [12:34:09:067]: Attempting to enable all disabled priveleges before calling Install on Server
MSI (c) (5C:78) [12:34:09:067]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (28:E4) [12:34:09:113]: Grabbed execution mutex.
MSI (s) (28:74) [12:34:09:113]: Resetting cached policy values
MSI (s) (28:74) [12:34:09:113]: Machine policy value 'Debug' is 0
MSI (s) (28:74) [12:34:09:113]: ******* RunEngine:
******* Product: {AEB9948B-4FF2-47C9-990E-47014492A0FE}
******* Action:
******* CommandLine: **********
MSI (s) (28:74) [12:34:09:113]: Machine policy value 'DisableUserInstalls' is 0
MSI (s) (28:74) [12:34:09:113]: MainEngineThread is returning 1605
MSI (c) (5C:78) [12:34:09:113]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (5C:78) [12:34:09:113]: MainEngineThread is returning 1605
=== Verbose logging stopped: 18/03/2008 12:34:09 ===
The log summary:
Microsoft SQL Server 2005 9.00.1399.06
==============================
OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Time : Tue Mar 18 12:05:06 2008
EOC429 : The current system does not meet recommended hardware requirements for this SQL Server release. For detailed hardware requirements, see the readme file or SQL Server Books Online.
Machine : EOC429
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_SQLSupport_1.log
--------------------------------------------------------------------------------
Machine : EOC429
Product : Microsoft SQL Server Native Client
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_SQLNCLI_1.log
--------------------------------------------------------------------------------
Machine : EOC429
Product : Microsoft Office 2003 Web Components
Product Version : 11.0.6558.0
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_OWC11_1.log
--------------------------------------------------------------------------------
Machine : EOC429
Product : Microsoft SQL Server 2005 Backward compatibility
Product Version : 8.05.1054
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_BackwardsCompat_1.log
--------------------------------------------------------------------------------
SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt.
Time : Tue Mar 18 12:19:20 2008
List of log files:
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_Core(Local).log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_SQLSupport_1.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_SQLNCLI_1.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_OWC11_1.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_BackwardsCompat_1.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_MSXML6_1.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_Datastore.xml
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_.NET Framework 2.0.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_Core.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSummary.txt
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_.NET Framework 2.0 LangPack.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_.NET Framework Upgrade Advisor.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_.NET Framework Upgrade Advisor LangPack.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_.NET Framework Windows Installer.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_.NET Framework Windows Installer LangPack.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_SNAC.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_Support.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_SCC.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_EOC429_WI.log
View 3 Replies
View Related
Sep 4, 2006
Hello All,I am having trouble with a stored procedure I am working on. Just a little background, I am trying to do a GridView inside another GridView but the trouble I am having is that each row in the Parent GridView is display the entire Child GridView. What I want to do is basically for GridView1 (Parent) Row 1 should display GridView2 (Child) Row1. So I thought let me just pass three parameters.Any Help would be greatly apperciated Field – The Column I wantProject – The Project IDTPC – Name This is the stored procedure I am working on… CREATE PROCEDURE dbo.Portal_FinancialGetJanuary( @TPC nvarchar(50), @Project int @Field varchar(1000)) AS SET NOCOUNT ON SELECT @Field, MonthFROM Portal_FinancialForecastingWHERE(((Portal_FinancialForecasting.TPC) = @TPC) AND (Portal_FinancialForecasting.Month = 'January') AND (Portal_FinancialForecasting.Project = @Project))
View 2 Replies
View Related
Jul 25, 2000
hi,
i am getting problem in sql65, service pack5a.
for some tables in my database it is showing null. I cannot able to see the records in a table. I can see these tables in sysobjects table.
owner of the some tables is "null".
I executed following query to get the table name as well as owner.
select owner = user_name(uid), name , type
from sysobjects where name = 'published_docs'
Result:
owner name type
----- ----- -----
(null) published_docs u
--Pls give any ideas.
Dont say go to 65 discussion board(sorry i am in urgent)
thank you very much
--Devi
View 1 Replies
View Related
Oct 26, 2005
Hi all,
My window xp pro suddenly cannot reboot any more.
luckily, I can get into safe mode with command prompt.
So before doing any repair or even reinstallation of the op.
I need to back up my database using transact-sql in order to restore later on completely if have to reinstall my OP system.
I have MSDE installed on my computer. so osql.exe is available
for me to back up the database. I did before with the backup command, but it's a while ago. since this time the backup is so precious to me. I want you guys to back me up.
I will go to osql dir in C:program filesmicrosoft SQL server...
then issue:
backup database CMCTIS to disk='D:sqlbackupcmcbackup.dat'
CMCTIS is the database name and d:sqlbackupcmcbackup.dat is the file I want to use later on
to restore. Since if I will probably do repair or reinstallation, the information on C: will be wiped out or damaged. that's why I will use D: drive for the backup.
Please confirm.
So later on I can restore database completely including data and store procedures, database changes, right?
I have several databases and two server instances. I have to back up database one by one right?
Please reply at your earliest convenience. Otherwise I will lose all three month database work.
Betty
View 5 Replies
View Related
Mar 3, 2006
our one of our website is down. I try to reboot the server and restart the services. It didn't help. One of our user try to ftp. But also it said he has no permission on it. Do you know what can i do?
Thanks.
View 1 Replies
View Related
Nov 20, 2005
I have just deleted a clients database by mistake ( working too many hours this weekend!). I have recovered the actual files with Ontrack file recovery software.
I have tried to attach the mdf but SQL says it's not a valid sql database file. I have also created a new database of the same name , stopped sql, copied over the original files and re-started sql . SQL ( 2000) then marks the datbase as suspect.
Does anyone have a possible
thx
Stressed & Desperate.
No backups available . No lectures please... i've just learn't the VERY hard way !!
<edit> Moved to Data Corruption forum </edit>
View 5 Replies
View Related
Dec 4, 2006
Hi all!
I need an emergency help, I will have to give this assignment tomorrow...
what is the name of the function which makes this view:
I 1
F 2
I 4
C 2
F 3
I 1
C 1
into this:
I 6
C 3
F 5
Thanks,
Balázs
View 1 Replies
View Related
Dec 4, 2006
I don't know why the last topic is locked, but here is the situation more detailed.
I know that the group by is the answer for my last question.
But the situation is sadly not this easy:
We have a Donortype table and it looks like this:
D DONORTARGETQ1 DONORTARGETQ2 DONORTARGETQ3 DONORTARGETQ4
- ------------- ------------- ------------- -------------
C 400 400 500 500
F 300 350 400 500
I 125 150 200 275
3 rows selected.
The first column is called donortype. That's what we have to use.
The contribution table looks like this:
CONTRIBUT DONORID CONTRIBUTIONAMOUNT PROGRAMNAME MEMBERNUMB
--------- ---------- ------------------ ------------------------------ ----------
03-JAN-06 2 200 Basic Research 5
07-JAN-06 3 150 Applied Research 3
27-JAN-06 7 50 Teaching Programs 1
05-FEB-06 6 100 International Programs 2
23-FEB-06 2 50 International Programs 1
03-MAR-06 1 100 Basic Research 6
30-MAR-06 5 75 Basic Research 1
15-APR-06 6 50 Teaching Programs 4
09-MAY-06 4 100 Applied Research 2
14-MAY-06 7 100 International Programs 5
29-MAY-06 7 100 Applied Research 5
11-JUN-06 5 50 Teaching Programs 5
18-JUN-06 6 75 Applied Research 2
23-JUN-06 3 50 Basic Research 3
10-JUL-06 1 100 Teaching Programs 3
16-JUL-06 4 100 International Programs 2
22-JUL-06 6 75 Applied Research 4
15-AUG-06 5 60 Applied Research 1
23-AUG-06 2 150 International Programs 1
09-SEP-06 3 175 Applied Research 6
18-SEP-06 6 150 Teaching Programs 2
01-OCT-06 2 80 International Programs 5
13-OCT-06 1 50 Basic Research 6
30-OCT-06 5 25 Applied Research 1
11-NOV-06 4 100 Teaching Programs 4
24-NOV-06 2 100 Applied Research 5
10-DEC-06 7 200 Basic Research 1
20-DEC-06 3 85 International Programs 6
28 rows selected.
We have the DonorID and the ContributionAmount here.
We also have a Donor table:
DONORID DONORNAME D DONORPROJECTION
---------- ------------------------------ - ---------------
1 Crabtree I 50
2 Genetix C 100
3 Marlo I 55
4 Mervis F 60
5 Orange Computers C 50
6 Roper Foundation F 70
7 Keltron, Inc. C 85
7 rows selected.
The third column is DonorType as well.
What I have to create is something like this
DonorType ContributionAmount
I 100
F 300
C 250
Where the 100 is the sum of ContributionAmounts performed by DonorID-s which have a DonorType I
and 300 is the sum of ContributionAmounts performed by DonorID-s which have a DonorType F
and so on...
(the numbers are made up, they are probably not correct...)
My idea was that let's create a view with DonorID and sum(ContributionAmount) grouped by DonorID.
Than join this view with the DonorType table, and create a view which contains DonorId, DonorType and sum(ContributionAmount) from the first view.
And what now?! HOw do you group this by DonorType?
View 1 Replies
View Related
Jun 3, 2006
dear:
can anyone tell how to connect to Microsoft Mobile Server 2005 using System.Data.SqlceConnection or using System.oledbConnection connect to Microsoft Access DataBase in Pocket Pc or windows CE program?
dose there any minimum requirements i need to install?would you like to list a list for me
thanks alot.
View 1 Replies
View Related
Nov 16, 2000
I am trying to replicate between two servers. I am pushing a subscription to the other server. Of course this has to write to a file on the Servers hard drive before the actual replication. (It's actually trying to write a shared drive on the server) I have checked the permissions all day and I keep getting the same thing; 'The process could not create file [path to file] the network name cannot be found' What should I check? I have checked the permissions on the drive all the way down to the folder and It hasnt helped. I have checked the host files to make sure the ip address is correct in the file. I dont understand the network name error because it's trying to write to itself. Is there anyone out there that can help me???? PLEASE????
View 2 Replies
View Related
May 9, 2006
Dear All,
We have a big concern in our Database system. We have 2000 transactions daily in our database. We need to replicate some how the database for our fail over setup. I tried transactional replication at midnight but our all systems locked and we had a lot of complaints from the customers and It was taking a lot of time to snapshot part and I had to abort it because of these reasons.
I need an advice how I can create a replication or is there any other way to replicate or is there any way to do this process without bothering the system? Please give me some advice and help..
View 1 Replies
View Related
May 10, 1999
I have a 6.5 DB in which I lost a hard drive and have to recreate the Databases. I do have the original and latest device file ***.DAT which contains all of my application Data. Is there a way I can re-create the DB and point to use this device and keep my data???
A quick response is greatly appreciated!
View 1 Replies
View Related
Apr 15, 2008
Hi all - had a bit of a nightmare at work with order accounts application. Basically - all the orders have been set to uninvoiced and I need to set the ones which have been invoiced back to invoiced. Problem is that orders can be part invoiced.
Tables as follows:
orders
orderid PK int
invoiced int
orderline
orderid int
qty int
productid int
invoices
invoiceid PK int
orderid int
invoiceline
invoiceid int
qty int
productid int
There can be multiple invoices for each order
Question is - how can I write a query which updates the order table - set invoiced to 1 where there are the same amount of items in the order as in the related invoices?
Real emergency this one folks!
Hopefully someone can help me out!
Stephen.
View 8 Replies
View Related
Dec 4, 2006
I absolutely agree with you.
I managed to find the error, it was a typo.
Here is the code, if somebody is interested about it. It is oracle, not SQL server, but the idea is the same.
drop view a;
drop view b;
drop view figure5_9;
create view a
as
select d.donorID, dt.donortype, dt.donortargetq1
from donortype dt, donor d
where d.donortype=dt.donortype;
select * from a;
create view b
as
select a.donortype, sum(c.ContributionAmount) as amount
from Contribution c, a
where c.ContributionDate between '01-JAN-06' and '31-MAR-06' and a.donorID=c.donorID
group by a.donortype;
select * from b;
create view figure5_9
as
select b.donortype, a.donortargetq1, b.amount, b.amount/a.donortargetq1 as percentage
from a, b
where a.donortype=b.donortype
group by b.donortype, a.donortargetq1, b.amount;
select * from figure5_9;
Thanks for the help anyway ;-)
View 2 Replies
View Related
May 10, 2006
Dear All,We have a big concern in our Database system. We have 2000 transactionsdaily in our database. We need to replicate some how the database forour fail over setup. I tried transactional replication at midnight butour all systems locked and we had a lot of complaints from thecustomers and It was taking a lot of time to snapshot part and I had toabort it because of these reasons.I need an advice how I can create a replication or is there any otherway to replicate or is there any way to do this process withoutbothering the system? Please give me some advice and help..Thanksasa.
View 9 Replies
View Related
Feb 20, 2002
I have successfully restored my old MSSQL7.0 database from a computer that crashed - but the database is several months old. I do, however, have the most recent log files (*.ldf) - the actual log file and NOT a backup log file. Is there any way i can update my restored databse with the most recent .ldf files?
View 1 Replies
View Related
Oct 16, 2000
Hi, I don't have any backup file for database. But I do have *.mdf and *.ldf files on tape backup for all the databases on server. Our server has crashed and we are trying to rebuild it. Our DBA is not accessible right now.
Can please anyone help how to put sql server back with all the databases?
I will really appreciate your help...
Thanks a lot in advance..
View 3 Replies
View Related
Nov 8, 2005
Dear All:
I have a text file that need to use bulk insert to do the import, but after I run the command line as follows, an error message do come out at once:
my command line is:
BULK INSERT im_data
FROM 'c:
pt_kioskex051107.txt' WITH (FIELDTERMINATOR = ' ')
and the error is "unexpected end-of-file(eof) encountered in data file. Now i attached one of the file and hope someone could help me out and let me know what's wrong with it. Thanks for all.
Best rgds,
Ivan Vong
View 4 Replies
View Related
Dec 19, 2005
Has anybody here seen and resolved the following error?
The MS DTC Transaction Manager is in an inconsistent state and cannot proceed. Please contact Microsoft Product Support. (null)
File: . mtx.cpp, Line: 2570.
We've had this just crop up on a server over the last week. Not finding a lot.
View 4 Replies
View Related
