espandot 4 #1 Oluşturuldu: Nisan 24, 2018 EVET ARKADAŞLAR yaklaşık 1 haftadır forumda paylasılmıs olan OldSchoolKO'nun databesinin aşırı şişme sorunuyla ılgılı ugrasıyorum ancak ne yaptıysam şişmeye devam ettı. Ancak az önce aklıma bırsey geldı ve SQL'de managementte SQL SERVER loglara bakayım dedım ve gözüme birşey çarptı. Sanırım şişmenin sebebide asagıda paylasacagım olay. Her 1 sanıyede sureklı tekrar edıyor ve sanırım loglara kayıtlanıyor ve o kayıtlandıkca database şişiyor. Şimdi esas can alıcı nokta bu sorunu nasıl duzeltıcez. Haydı aslansınız yaparsınız koclarım opuyorum sizleri :D@ espandotEdit (MOMENTUM) Konu başlıklarını açıklayıcı ve düzgün şekilde yazalım, iyi forumlar.KOD:04/24/2018 20:07:03,spid55,Unknown,Setting database option RECOVERY to SIMPLE for database 'kn_online'.04/24/2018 20:06:56,Logon,Unknown,Login failed for user 'sa'. Reason: An attempt to login using SQL authentication failed. Server is configured for Windows authentication only. [CLIENT: 111.194.168.235]04/24/2018 20:06:56,Logon,Unknown,Error: 18456 Severity: 14 State: 58.04/24/2018 20:06:54,Logon,Unknown,Login failed for user 'sa'. Reason: An attempt to login using SQL authentication failed. Server is configured for Windows authentication only. [CLIENT: 111.194.168.235]04/24/2018 20:06:54,Logon,Unknown,Error: 18456 Severity: 14 State: 58.04/24/2018 20:06:53,Logon,Unknown,Login failed for user 'sa'. Reason: An attempt to login using SQL authentication failed. Server is configured for Windows authentication only. [CLIENT: 111.194.168.235]04/24/2018 20:06:53,Logon,Unknown,Error: 18456 Severity: 14 State: 58.04/24/2018 20:06:51,Logon,Unknown,Login failed for user 'sa'. Reason: An attempt to login using SQL authentication failed. Server is configured for Windows authentication only. [CLIENT: 111.194.168.235]04/24/2018 20:06:51,Logon,Unknown,Error: 18456 Severity: 14 State: 58.04/24/2018 20:06:49,Logon,Unknown,Login failed for user 'sa'. Reason: An attempt to login using SQL authentication failed. Server is configured for Windows authentication only. [CLIENT: 111.194.168.235]04/24/2018 20:06:49,Logon,Unknown,Error: 18456 Severity: 14 State: 58.04/24/2018 20:06:48,Logon,Unknown,Login failed for user 'sa'. Reason: An attempt to login using SQL authentication failed. Server is configured for Windows authentication only. [CLIENT: 111.194.168.235]04/24/2018 20:06:48,Logon,Unknown,Error: 18456 Severity: 14 State: 58.04/24/2018 20:06:46,Logon,Unknown,Login failed for user 'su'. Reason: An attempt to login using SQL authentication failed. Server is configured for Windows authentication only. [CLIENT: 111.194.168.235]04/24/2018 20:06:46,Logon,Unknown,Error: 18456 Severity: 14 State: 58.04/24/2018 20:06:44,Logon,Unknown,Login failed for user 'sa'. Reason: An attempt to login using SQL authentication failed. Server is configured for Windows authentication only. [CLIENT: 111.194.168.235]04/24/2018 20:06:44,Logon,Unknown,Error: 18456 Severity: 14 State: 58.04/24/2018 20:06:42,Logon,Unknown,Login failed for user 'sa'. Reason: An attempt to login using SQL authentication failed. Server is configured for Windows authentication only. [CLIENT: 111.194.168.235]04/24/2018 20:06:42,Logon,Unknown,Error: 18456 Severity: 14 State: 58.04/24/2018 20:06:41,Logon,Unknown,Login failed for user 'sa'. Reason: An attempt to login using SQL authentication failed. Server is configured for Windows authentication only. [CLIENT: 111.194.168.235]04/24/2018 20:06:41,Logon,Unknown,Error: 18456 Severity: 14 State: 58.04/24/2018 20:06:39,Logon,Unknown,Login failed for user 'sa'. Reason: An attempt to login using SQL authentication failed. Server is configured for Windows authentication only. [CLIENT: 111.194.168.235]04/24/2018 20:06:39,Logon,Unknown,Error: 18456 Severity: 14 State: 58.04/24/2018 20:06:37,Logon,Unknown,Login failed for user 'sysdba'. Reason: An attempt to login using SQL authentication failed. Server is configured for Windows authentication only. [CLIENT: 111.194.168.235]04/24/2018 20:06:37,Logon,Unknown,Error: 18456 Severity: 14 State: 58.04/24/2018 20:06:36,Logon,Unknown,Login failed for user 'sa'. Reason: An attempt to login using SQL authentication failed. Server is configured for Windows authentication only. [CLIENT: 111.194.168.235]04/24/2018 20:06:36,Logon,Unknown,Error: 18456 Severity: 14 State: 58.04/24/2018 20:06:34,Logon,Unknown,Login failed for user 'sa'. Reason: An attempt to login using SQL authentication failed. Server is configured for Windows authentication only. [CLIENT: 111.194.168.235]04/24/2018 20:06:34,Logon,Unknown,Error: 18456 Severity: 14 State: 58.04/24/2018 20:06:32,Logon,Unknown,Login failed for user 'sa'. Reason: An attempt to login using SQL authentication failed. Server is configured for Windows authentication only. [CLIENT: 111.194.168.235]04/24/2018 20:06:32,Logon,Unknown,Error: 18456 Severity: 14 State: 58.04/24/2018 20:06:31,Logon,Unknown,Login failed for user 'sa'. Reason: An attempt to login using SQL authentication failed. Server is configured for Windows authentication only. [CLIENT: 111.194.168.235]04/24/2018 20:06:31,Logon,Unknown,Error: 18456 Severity: 14 State: 58.04/24/2018 20:06:29,Logon,Unknown,Login failed for user 'sa'. Reason: An attempt to login using SQL authentication failed. Server is configured for Windows authentication only. [CLIENT: 111.194.168.235]04/24/2018 20:06:29,Logon,Unknown,Error: 18456 Severity: 14 State: 58.04/24/2018 20:06:27,Logon,Unknown,Login failed for user 'sa'. Reason: An attempt to login using SQL authentication failed. Server is configured for Windows authentication only. [CLIENT: 111.194.168.235]04/24/2018 20:06:27,Logon,Unknown,Error: 18456 Severity: 14 State: 58.04/24/2018 20:06:26,Logon,Unknown,Login failed for user 'sa'. Reason: An attempt to login using SQL authentication failed. Server is configured for Windows authentication only. [CLIENT: 111.194.168.235]04/24/2018 20:06:26,Logon,Unknown,Error: 18456 Severity: 14 State: 58.04/24/2018 20:06:24,Logon,Unknown,Login failed for user 'sa'. Reason: An attempt to login using SQL authentication failed. Server is configured for Windows authentication only. [CLIENT: 111.194.168.235]04/24/2018 20:06:24,Logon,Unknown,Error: 18456 Severity: 14 State: 58.04/24/2018 20:06:22,Logon,Unknown,Login failed for user 'sa'. Reason: An attempt to login using SQL authentication failed. Server is configured for Windows authentication only. [CLIENT: 111.194.168.235]04/24/2018 20:06:22,Logon,Unknown,Error: 18456 Severity: 14 State: 58.04/24/2018 20:06:20,Logon,Unknown,Login failed for user 'sa'. Reason: An attempt to login using SQL authentication failed. Server is configured for Windows authentication only. [CLIENT: 111.194.168.235]04/24/2018 20:06:20,Logon,Unknown,Error: 18456 Severity: 14 State: 58.04/24/2018 20:06:19,Logon,Unknown,Login failed for user 'sa'. Reason: An attempt to login using SQL authentication failed. Server is configured for Windows authentication only. [CLIENT: 111.194.168.235]04/24/2018 20:06:19,Logon,Unknown,Error: 18456 Severity: 14 State: 58.-- mesaja ek olarak --Unutmadan bunlar sadece %1lık bır kısmı bu verdıgı sorun sayfalarca surup gıdıyor ancak hepsı aynı-- mesaja ek olarak --Ayrıca Database paylasılmadan 3 gun once son yapılmaya calısılan degısıklıkler bunlar sorunu cozmede yardımcı olabılır dıye paylasıyorum bunlarıda bu hata alınan degısıklıkler yapıldıktan sonra az once paylasmıs oldugum hata kodunu sureklı cevırıyor SQL her sanıye gene 10/27/2017 tarıhınde bu paylastıgım hatlardan sonrasında aynı hatayı sureklı cevırıyor.10/27/2017 20:13:02,Server,Unknown,Software Usage Metrics is enabled.10/27/2017 20:12:34,Server,Unknown,Common language runtime (CLR) functionality initialized using CLR version v4.0.30319 from C:\Windows\Microsoft.NET\Framework64\v4.0.30319\.10/27/2017 20:12:34,spid7s,Unknown,Recovery is complete. This is an informational message only. No user action is required.10/27/2017 20:12:33,spid20s,Unknown,Service Broker manager has started.10/27/2017 20:12:33,spid20s,Unknown,The Database Mirroring endpoint is in disabled or stopped state.10/27/2017 20:12:33,spid20s,Unknown,The Service Broker endpoint is in disabled or stopped state.10/27/2017 20:12:33,spid11s,Unknown,The tempdb database has 1 data file(s).10/27/2017 20:12:32,spid11s,Unknown,Recovery completed for database tempdb (database ID 2) in 1 second(s) (analysis 1937 ms redo 0 ms undo 0 ms.) This is an informational message only. No user action is required.10/27/2017 20:12:30,spid11s,Unknown,Starting up database 'tempdb'.10/27/2017 20:12:29,spid7s,Unknown,1 transactions rolled back in database 'kn_online' (5:0). This is an informational message only. No user action is required.10/27/2017 20:12:29,spid19s,Unknown,653 transactions rolled forward in database 'kn_online' (5:0). This is an informational message only. No user action is required.10/27/2017 20:12:28,spid11s,Unknown,Clearing tempdb database.10/27/2017 20:12:28,spid7s,Unknown,0 transactions rolled back in database 'msdb' (4:0). This is an informational message only. No user action is required.10/27/2017 20:12:28,Server,Unknown,The SQL Server Network Interface library could not register the Service Principal Name (SPN) [ MSSQLSvc/WIN-7AG784RAQN6:1433 ] for the SQL Server service. Windows return code: 0xffffffff state: 63. Failure to register a SPN might cause integrated authentication to use NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies and if the SPN has not been manually registered.10/27/2017 20:12:28,Server,Unknown,The SQL Server Network Interface library could not register the Service Principal Name (SPN) [ MSSQLSvc/WIN-7AG784RAQN6 ] for the SQL Server service. Windows return code: 0xffffffff state: 63. Failure to register a SPN might cause integrated authentication to use NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies and if the SPN has not been manually registered.10/27/2017 20:12:28,spid17s,Unknown,1 transactions rolled forward in database 'msdb' (4:0). This is an informational message only. No user action is required.10/27/2017 20:12:28,Server,Unknown,SQL Server is attempting to register a Service Principal Name (SPN) for the SQL Server service. Kerberos authentication will not be possible until a SPN is registered for the SQL Server service. This is an informational message. No user action is required.10/27/2017 20:12:28,spid15s,Unknown,SQL Server is now ready for client connections. This is an informational message; no user action is required.10/27/2017 20:12:28,spid11s,Unknown,Starting up database 'model'.10/27/2017 20:12:28,Server,Unknown,Dedicated admin connection support was established for listening locally on port 1434.10/27/2017 20:12:28,Server,Unknown,Server is listening on [ 127.0.0.1 1434].10/27/2017 20:12:28,Server,Unknown,Server is listening on [ ::1 1434].10/27/2017 20:12:28,spid15s,Unknown,Server local connection provider is ready to accept connection on [ \\.\pipe\sql\query ].10/27/2017 20:12:28,spid15s,Unknown,Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].10/27/2017 20:12:28,spid15s,Unknown,Server is listening on [ 'any' 1433].10/27/2017 20:12:28,spid15s,Unknown,Server is listening on [ 'any' 1433].10/27/2017 20:12:28,spid15s,Unknown,A self-generated certificate was successfully loaded for encryption.10/27/2017 20:12:27,spid11s,Unknown,The resource database build version is 12.00.5000. This is an informational message only. No user action is required.10/27/2017 20:12:27,spid19s,Unknown,Starting up database 'kn_online'.10/27/2017 20:12:27,spid11s,Unknown,Starting up database 'mssqlsystemresource'.10/27/2017 20:12:27,spid17s,Unknown,Starting up database 'msdb'.10/27/2017 20:12:27,spid7s,Unknown,Server name is 'WIN-7AG784RAQN6'. This is an informational message only. No user action is required.10/27/2017 20:12:27,spid7s,Unknown,SQL Trace ID 1 was started by login "sa".10/27/2017 20:12:26,spid7s,Unknown,SQL Server Audit has started the audits. This is an informational message. No user action is required.10/27/2017 20:12:26,spid7s,Unknown,SQL Server Audit is starting the audits. This is an informational message. No user action is required.10/27/2017 20:12:25,spid7s,Unknown,Resource governor reconfiguration succeeded.10/27/2017 20:12:25,Server,Unknown,CLR version v4.0.30319 loaded.10/27/2017 20:12:24,spid7s,Unknown,Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.10/27/2017 20:12:24,spid7s,Unknown,0 transactions rolled back in database 'master' (1:0). This is an informational message only. No user action is required.10/27/2017 20:12:24,spid7s,Unknown,3 transactions rolled forward in database 'master' (1:0). This is an informational message only. No user action is required.10/27/2017 20:12:24,spid7s,Unknown,Starting up database 'master'.10/27/2017 20:12:24,Server,Unknown,Database Instant File Initialization: disabled. For security and performance considerations see the topic 'Database Instant File Initialization' in SQL Server Books Online. This is an informational message only. No user action is required.10/27/2017 20:12:24,Server,Unknown,Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.10/27/2017 20:12:24,Server,Unknown,Node configuration: node 0: CPU mask: 0x0000000000000003:0 Active CPU mask: 0x0000000000000003:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.10/27/2017 20:12:24,Server,Unknown,The maximum number of dedicated administrator connections for this instance is '1'10/27/2017 20:12:24,Server,Unknown,This instance of SQL Server last reported using a process ID of 1036 at 9/30/2017 2:15:38 PM (local) 9/30/2017 11:15:38 AM (UTC). This is an informational message only; no user action is required.10/27/2017 20:12:20,Server,Unknown,Default collation: SQL_Latin1_General_CP1_CI_AS (us_english 1033)10/27/2017 20:12:18,Server,Unknown,Using conventional memory in the memory manager.10/27/2017 20:12:18,Server,Unknown,Detected 4095 MB of RAM. This is an informational message; no user action is required.10/27/2017 20:12:18,Server,Unknown,SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.10/27/2017 20:12:18,Server,Unknown,SQL Server detected 1 sockets with 2 cores per socket and 2 logical processors per socket 2 total logical processors; using 2 logical processors based on SQL Server licensing. This is an informational message; no user action is required.10/27/2017 20:12:17,Server,Unknown,Command Line Startup Parameters: -s "MSSQLSERVER"10/27/2017 20:12:17,Server,Unknown,Registry startup parameters: -d C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\master.mdf -e C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Log\ERRORLOG -l C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\mastlog.ldf10/27/2017 20:12:17,Server,Unknown,The service account is 'NT Service\MSSQLSERVER'. This is an informational message; no user action is required.10/27/2017 20:12:17,Server,Unknown,Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Log\ERRORLOG'.10/27/2017 20:12:17,Server,Unknown,Authentication mode is WINDOWS-ONLY.10/27/2017 20:12:17,Server,Unknown,System Manufacturer: 'VMware Inc.' System Model: 'VMware Virtual Platform'.10/27/2017 20:12:17,Server,Unknown,Server process ID is 1036.10/27/2017 20:12:17,Server,Unknown,All rights reserved.10/27/2017 20:12:17,Server,Unknown,(c) Microsoft Corporation.10/27/2017 20:12:17,Server,Unknown,UTC adjustment: 3:0010/27/2017 20:12:17,Server,Unknown,Microsoft SQL Server 2014 (SP2-GDR) (KB4019093) - 12.0.5207.0 (X64) Jul 3 2017 02:25:44 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.3 (Build 9600: ) (Hypervisor) Mesajı raporla İletiyi paylaş Link to post Sitelerde Paylaş
MOMENTUM 330 #2 Nisan 24, 2018 tarihinde gönderildi Gizli İçerik Gizli içeriği görmek için bu konuya bir mesaj yazın. Bu makaleye bir göz atarsan sorunu büyük ihtimalle çözeceksin 1 Mesajı raporla İletiyi paylaş Link to post Sitelerde Paylaş
espandot 4 #3 Konu Sahibi Nisan 24, 2018 tarihinde gönderildi kesinlikle göz atacagım teşekkürler momentum, şu anda @ CENGLYY arkadaşımız ilgileniyor sağolsun ama bilgi olsun diye mutlaka göz atacagım çok teşekkür ederim Mesajı raporla İletiyi paylaş Link to post Sitelerde Paylaş
we1982 26 #4 Mayıs 16, 2018 tarihinde gönderildi bir bakalım makaleye Mesajı raporla İletiyi paylaş Link to post Sitelerde Paylaş
espandot 4 #5 Konu Sahibi Mayıs 16, 2018 tarihinde gönderildi Alıntıbir bakalım makaleye sorun cozuldu hocam cok sagolasın forumda sısmeyen versıyonunu paylastılar Mesajı raporla İletiyi paylaş Link to post Sitelerde Paylaş
Rhaegal 2 #6 Haziran 16, 2018 tarihinde gönderildi neymiş bakalm Mesajı raporla İletiyi paylaş Link to post Sitelerde Paylaş
donz05 30 #7 Haziran 16, 2018 tarihinde gönderildi gizli konu open... Mesajı raporla İletiyi paylaş Link to post Sitelerde Paylaş
Spades 5 #8 Temmuz 10, 2018 tarihinde gönderildi teşekkürler Mesajı raporla İletiyi paylaş Link to post Sitelerde Paylaş
xterme 174 #9 Ekim 26, 2018 tarihinde gönderildi Tesekurlerr Mesajı raporla İletiyi paylaş Link to post Sitelerde Paylaş
MRX 1 #10 Kasım 4, 2018 tarihinde gönderildi teşekkürler Mesajı raporla İletiyi paylaş Link to post Sitelerde Paylaş
sez3rr 6 #11 Kasım 4, 2018 tarihinde gönderildi teşekkürler Mesajı raporla İletiyi paylaş Link to post Sitelerde Paylaş
valentinako 0 #12 Mayıs 6, 2019 tarihinde gönderildi tesekuurler Mesajı raporla İletiyi paylaş Link to post Sitelerde Paylaş
Kaanizm33 0 #13 Aralık 22, 2019 tarihinde gönderildi teşekkürler Mesajı raporla İletiyi paylaş Link to post Sitelerde Paylaş
Julien 10 #14 Ağustos 12, 2022 tarihinde gönderildi teşekkürler Mesajı raporla İletiyi paylaş Link to post Sitelerde Paylaş