Tagged Questions
2
votes
1answer
41 views
Can I decrypt TDE transaction log files for use with 3rd party software?
Is there a way to decrypt TDE log files on disk for use with 3rd party software? I have the original key and certificates. I am trying to use the transaction files with a 3rd party tool in order to ...
4
votes
1answer
78 views
When performing a cross-database transaction, in which transaction log(s) is the information stored?
Given the following snippet:
-- error checking omitted for brevity
begin tran
exec database1..my_stored_procedure
exec database2..my_other_stored_procedure
if (@@error <> 0)
rollback
...
1
vote
2answers
139 views
Reducing high VLF count
I have been using Brent Ozar's sp_blitz script to review our database setup and have found that the VLF count is high (13562!) on the primary DB since changing to Full recovery model.
I ran a full ...
0
votes
2answers
101 views
Database not naturally shrinking log file [duplicate]
I have a database that is set to Simple recovery mode. There is 99% free space in the log file and I can manually truncate the log file right down to 500 MB.
The next day, after a daily import ...
5
votes
1answer
128 views
Why did my transaction log grow so much? [duplicate]
Possible Duplicate:
Why Does the Transaction Log Keep Growing or Run Out of Space?
About a month ago I migrated my SQL Server 2008 R2 database to a new schema. I ran scripts to migrate the ...
3
votes
0answers
155 views
Why can't I read my transaction log backup file using fn_dump_dblog?
I'm using this blog on sqlskills.com as a guide to practice finding the relevant LSN in a transaction log backup for point in time recovery.
After backing up the transaction log, I attempt to read it ...
2
votes
2answers
78 views
separating tlog and db file when using fusionio
We have a FusionIO card that we use in our production database. We have both the transaction log as well as the database files on that same drive. I know the recommendation is to place the tlog files ...
2
votes
1answer
128 views
Shrink a large log file for a “Throw Away” database
I have a copy of my prod database on a development server. I am using it to test a deployment script.
But when I run it, it says that the log file is full.
I checked and it is at 10 GB (Almost the ...
29
votes
4answers
2k views
Why does ALTER COLUMN to NOT NULL cause massive log file growth?
I have a table with 64m rows taking 4.3 GB on disk for its data.
Each row is about 30 bytes of integer columns, plus a variable NVARCHAR(255) column for text.
I added a a NULLABLE column with ...
1
vote
1answer
573 views
Why does my transaction log use so much space?
I have a staging table with 20 million rows that uses about 8GB of storage. After populating foreign keys and sanitizing data I need to move this data into a production table (which does not need all ...
6
votes
3answers
1k views
View delete statements in the Transaction log
Is it possible to view delete statements that have recently occurred in the Transaction Log?
6
votes
1answer
378 views
DBCC CHECKDB firing every 20 - 60 seconds
I have a dev environment that is rapidly approaching deployment into production and have noticed in the logs that roughly every 20 seconds I see the message:
Starting up database 'dbname'
CHECKDB for ...
3
votes
2answers
584 views
Is this procedure to Failover to Logshipped secondary and Fail back again procedure correct?
I have a primary database in Amsterdam (AMDB), and a secondary in London (LNDB). I want to fail over from AMDB, to LNDB and then back again, without having to make another full backup (because the ...
