Stack Overflow
Stack Overflow

Questions tagged [truncate-log]

11 questions
4
votes
2 answers

SQL Server 2005 Transaction Log too big

I am running SQL Server 2005. My db backup scheme is: Recovery model: FULL Backup Type: Full Backup component: Database Backup set will expire: after 0 days Overwrite media: Back up to the existing media set, Append to the existing backup set The db…
RevoJoe
  • 41
  • 4
3
votes
1 answer

How to capture truncate statement information in SQL Server 2012

I would like to capture the truncate statements information along with the user/Login information for all database in my production server. Example: Use mydb go truncate table deleteme_table I would like to capture the information into the table…
Sandeep Pulikonda
  • 774
  • 3
  • 13
  • 26
1
vote
0 answers

SHRINKFILE not reducing SQL Server Express data file

We have a SQL Server Express instance, where one database reached 10Gb. We have deleted 90% of the larger db table records, supposedly clearing 4Gb of space, according to allocation_units.used_pages. DBCC SHRINKFILE has reduced the log file, but…
fcaserio
  • 726
  • 1
  • 9
  • 18
1
vote
1 answer

SQL Server 2008 R2 log files filled up the drive

So some of us dev's are starting to take over the management of some of our SQL Server boxes as we upgrade to SQL Server 2008 R2. In the past, we've manually reduced the log file sizes by using USE [databaseName] GO DBCC…
Jon
  • 301
  • 1
  • 5
  • 19
0
votes
0 answers

Grafana&Aliyun SLS integration: Turncate path to remove GET querystring

I want to count HTTP requests per path along with time. To do this, we use aliyun SLS (a log service) where all all nginx logs reside at, and granafa for display. The expected dashboard should be like: x-axis: time y-axis: number of requests for a…
shijie xu
  • 1,975
  • 21
  • 52
0
votes
3 answers

SQL replication - Publication deleted, but log file still growing

To preface, I've seen the command to answer this question before, but now I can't find it again, so I'm just looking for the single SQL statement that will solve my problem. I had two publications on a SQL Server 2000 database at one point, but I've…
SqlRyan
  • 33,116
  • 33
  • 114
  • 199
0
votes
1 answer

NLog Truncate syntax

I'm changing NLog.config file for UiPath. I want to increase truncate value to 20000 and I've tried following syntax but it's not working.
Maryam
  • 357
  • 1
  • 5
  • 16
0
votes
4 answers

Table is automatically truncated on SQL Server

I have a really strange problem on my SQL Server. Every night 2 tables, that I have recently created, are being automatically truncated... I am quite sure, that it is truncate, as my ON DELETE Trigger does not log any delete…
Bebus
  • 15
  • 1
  • 11
0
votes
0 answers

Permanently delete data from SQL server database

I am currently working on a WinForm application with SQL Server Express 2012 and entity framework 6. Now my Client want the option of deleting all the data from the database upon his request. I read many articles online which say that data can we…
Er. Blogger
  • 9
  • 5
0
votes
0 answers

Using Log4cplus for C++, logging is paused when 3rd party method is called and log file is truncated

When 3rd party method is called, i get the below error. Looks like there is problem with the file handle when 3rd party function is called. Later, logging starts after 1 or 2 secs. 07/22/14 12:00:22 [5944] DEBUG log4cplus:ERROR file is not open :…
Madhu
  • 1
0
votes
1 answer

tackle high syslog issue in sybase

What I understand from the syslog is that- necessary info is logged into a file so that rollback can be performed based on the info stored into syslog file. From last few months I am facing high syslog usage in my sybase database. Checking on the…
user1678270
  • 41
  • 4